If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can you add the same data series to all charts in a workbook
I have numerous charts on separate worksheets in one workbook and would like
to add the same data series to all the charts. I have tried highlighting all the worksheets and adding the series to no avail. |
#2
|
|||
|
|||
How can you add the same data series to all charts in a workbook
I'd save your workbook, just in case this doesn't work as I think it should.
You can select the series in the chart that includes the series and copy the formula for the series. It looks something like =SERIES(...) Paste that in each chart you want to add it to. "MBubier" wrote in message ... I have numerous charts on separate worksheets in one workbook and would like to add the same data series to all the charts. I have tried highlighting all the worksheets and adding the series to no avail. |
#3
|
|||
|
|||
How can you add the same data series to all charts in a workbook
Try this:
Plot the series in a new chart. Copy the chart, then select a chart that needs the new series, choose Paste Special from the Edit menu, with the Formulas option. Select the next chart and repeat the paste special (use the F4 key as a shortcut for Repeat Last Action). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "MBubier" wrote in message ... I have numerous charts on separate worksheets in one workbook and would like to add the same data series to all the charts. I have tried highlighting all the worksheets and adding the series to no avail. |
#4
|
|||
|
|||
How can you add the same data series to all charts in a workbo
This worked!! Thanks!
"Jon Peltier" wrote: Try this: Plot the series in a new chart. Copy the chart, then select a chart that needs the new series, choose Paste Special from the Edit menu, with the Formulas option. Select the next chart and repeat the paste special (use the F4 key as a shortcut for Repeat Last Action). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "MBubier" wrote in message ... I have numerous charts on separate worksheets in one workbook and would like to add the same data series to all the charts. I have tried highlighting all the worksheets and adding the series to no avail. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
Charts Line Types for Multiple Data Series not Printing Properly | Seanb | Charts and Charting | 0 | August 22nd, 2005 06:35 PM |
XL Charts: Let my mouse drag all data labels for a whole series. | Stuart Bratesman | Charts and Charting | 1 | August 10th, 2005 04:21 PM |
SQL view of messed up action queries | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 09:53 PM |