Replicating a Chart with new data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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!!!
 
Back
Top