Replicating a Chart with new data

[Guest]

I have formatted a chart using a specific data set referring to one
enterprise. I want to duplicate / replicate that same chart for a second and
third etc enterprise from different data on the same worksheet. I want to
have a series of separate cgarts within the workbook all dynamically linked
to the data sheet. I hope this is clear - I amtrying to save time by not
having to reformat every new chart as there are 47 of them!

 

[Ed Ferrero]

Hi Patrick,

You could copy the chart, then select the data series and change the range
that is referred to.

Or you could build a chart that refers to a range in the worksheet and then
put formulas in that range that allow you to select different data sets.

A sample workbook that uses the second method is shown at
http://www.edferrero.com/ExcelCharts/tabid/102/Default.aspx - look for
'Reporting'

Ed Ferrero
www.edferrero.com

 

[Guest]

Thanks for the info Ed.
I will visit the site you have identified. However in the first part of your
reply you suggest copying the chart, pasting it and then changing the data
range.
This is exactly what I did to find that the second data series transferred
but NOT in the same places as in the original - despite the data set looking
exactly the same as the first. So I ended up with a set of values in series 1
that were formatted in a specific way - what I wanted. Then having changed to
series 2 data the data adopts the format of another column. So the result is
that I have to reformat all the 'chart types' within the multiple data chart
to get the same result as the first chart. Very frustrating!!!