Multiple charts

[Jo Ball]

Hi

I need to create multiple charts from one set of data, where each new column
of data will need a new chart using the same categories from the first
columns. Is there any quick way of producing multiple charts for this at the
same time?

Thanks

 

[Dixit Dominus]

Hi,
I think you can create your first chart, and set everything up how you like
it. Then, copy the chart and paste it several times. Then, left click on
some white space inside the plot area of each new chart, to select it, and
scroll over to where your data is stored. The data source columns should be
highlighted. You can just left-click-grab onto the edges of those columns
and move them over to the next column that you want. And repeat.

Hope this helps.