Adding 1 series of data in 234 charts were 3 series already exist

**Joachimjr** · 07-09-2014, 07:22 AM

Hello,

Is there any smarter way than adding 1 more series manually to every chart? The range of the column is consistant to every 5th column.

Thanks in advance,
Joachim

**Andy Pope** · 07-09-2014, 10:14 AM

Only smarter way is with VBA code.

**Kaper** · 07-09-2014, 10:25 AM

You probably shall prepare VBA macro to do this. Unfortunalely you posted no sample file, so have a look on a dummy attached.
I made some 4 graphs there, then registered a simple macro while adding a new series to a one graph.

Please Login or Register  to view this content.

Then I deleted this newly added series from the graph. And to a code of macro added a loop going through all ChartObjects in the worksheet. It looks now:

Please Login or Register  to view this content.

Run it and you will see the result - similar method can probably be applied to your workbook.
Of course the code could be more developed etc. But already such simple one shall do what was described above.