It would be easier if you posted an example workbook.

You need to extend the number of categories in all the series. The data to go on the right needs to be in the final categories data slot.