graphs

[crtas1]

I have a graph that I have added a series to. This same graph is on 7 spreadsheets. I would like to copy the graph that I added the series to onto the other spreadsheets. I need the other spreadsheets to still have their same data sources but to add this one series. So far when I copy it turns into an exact copy or adds one spreadsheets info into the other creating about 8 series.
Any suggestions?

 

[Andrew Poulsom]

Try this:

1. Click on the series you wish to copy.
2. Select all the text in the Formula Bar (the SERIES formula) and press Ctrl+Insert.
3. Click on the edge of your target chart, point at the Formula bar and press Shift+Insert then Enter.
4. After the new series has been added you can edit the Sheet reference in the Formula Bar if necessary.

 

[crtas1]

That added a series but didn't keep the colors and it was pulling from the original tab still. I have 6 graphs per tab. 12 tabs per worksheet and 8 worksheets. What I would like to do is change all graphs on one worksheet and copy the changes to the other 7 worksheets tab by tab. I need it to copy the same formating and also pull from the exact same location just on the new workbook.

 

[Andrew Poulsom]

There is no quick way because, as you have seen, the SERIES formula always contains absolute references. You will have to do them one by one and change the sheet references (and the colours) after the copy.

Better get on with it!

 

[crtas1]

Man that suxs. That is going to take forever. Oh well thanks for your help.