Keep in mind that we need to arrange the source data in the following way: the entire source Range and Insert a new Clustered Column chart. For example, put the Q1 and Q2 data in separate rows, and then insert blank row after each group of data row and header row, please remember to … In the above example, each zone split into a different month, so first, we need to arrange data based on Zone-wise. they all have a different Data Labels array. Continuous learning from pryor.com. I am trying to update the data range source for a chart in VBA, dynamically and for multiple separate columns. 0. Tags: Excel Chart Multiple Series. Linear chart). Thanks! Right click the Chart and choose Source Data. Stacked Column Chart in Excel Example #1. I'd like to create a BubleGraph chart, with multiple series.