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
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
Only smarter way is with VBA code.
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.
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.Please Login or Register to view this content.
Of course the code could be more developed etc. But already such simple one shall do what was described above.
Last edited by Kaper; 07-09-2014 at 10:27 AM.
Best Regards,
Kaper
Thank you very much Kaper!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks