Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HELP- Copying a Data Series to Another Graph???
Hi- I'm using Excel 2002 and I've got a lot of XY (Scatter) graphs. When I add a new data series to one graph, it is defined by 3 values (Name, X Value and Y Value) If I want to add this data series to 7 or 8 add'l graphs, I know that I can copy/paste these 3 values to each of them. Is there a simpler way to accomplish this? thnx |
#2
|
|||
|
|||
Phil -
Select the series, then copy the series formula in the formula bar; the series formula holds your three values, plus a fourth, the plot order (and a fifth, bubble sizes, if it's from a bubble chart). Select another chart's plot area (this is important: select the box defined on the left and bottom by the axes, or it won't work), click in the formula bar, paste in the formula you copied, change the plot order parameter if desired, and press Enter. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ phil6666 wrote: Hi- I'm using Excel 2002 and I've got a lot of XY (Scatter) graphs. When I add a new data series to one graph, it is defined by 3 values (Name, X Value and Y Value) If I want to add this data series to 7 or 8 add'l graphs, I know that I can copy/paste these 3 values to each of them. Is there a simpler way to accomplish this? thnx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add a second axis to a graph with 2 data series? | Charts and Charting in Excel | |||
how do I change the data series an an excel graph | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |