How to create multiple charts from a range of data?

[AAKBD]

I've scoured the internet past two days, but could not find any solution. More accurately, I don't know which keywords should I use to search it out.

The problem is as follows, I need to create quite a number of charts from a very large data set. An example of what I was doing is given below. One method I am using is CTRL+D to duplicate the chart and then adjusting the series by dragging the series column.

Obviously, this is time-consuming and not suitable for large data sets (say 100 or more series). I also need to arrange these charts in a printable form.

Any help to make this thing manageable would be appreciated.

vCQK8.png

[Kaper]

May be some simple macro would be a good starting point?
I've registered macro while creating one graph and then changed it to be run in a loop.
It generates a row of graphs, but rearranging them into x columns by y rows will be probably easy to be done manual.

In the attached file you will fing both recorded macro, and the ready to play one. Of course you probably would need to adjust heights, widths and positions, but it's already there, so just play with numbers :-) Or register your process of creation and for instance tilting dates on axis description and copy them into the working macro (remembering to always work with obj. ... shape object (or with obj.Chart.Axes(xlCategory). ... etc) not "Activechart etc. as goes the result of the macro recorder)

the code:

Please Login or Register  to view this content.

[Zaerick]

Is there a reason you can't just use a pivot chart? Do you need to visually see all the charts at the same time? Or do you just need to be able to print which one you want on demand? If the later just do a pivot chart.

[Kaper]

I also need to arrange these charts in a printable form.

I understood this as the requirement to see/print many graphs at the same time.

As I mentioned, rearranging could be done manually, but the arrangement could be also done by macro.
For instance to get 4 columns (for other number of columns use it instead of red fours in thje code below) such modification of lines 7 and 8 of above code could be used:

Please Login or Register  to view this content.