Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I copy x-y scatter plot data direct from one plot to another?
I would like to add data from one or more x-y scatter plots to another x-y
scatter plot. I have several plots containing data each representing a small map. I would like to add one of those plots (maps) to an existing plot (map) without individually creating a set of new series and adding each one, one at a time, to the plot. I would prefer to somehow simply copy and past the plot or somehow reference the plot to be added but can find no commands to allow me to do this. Thank you for you time. |
#3
|
|||
|
|||
If you select a series in the source chart, you see its formula in the
formula bar. It starts with =SERIES( Select and copy this formula in the formula bar, select the target chart's plot area or chart area, click in the formula bar, paste the formula, and press Enter, and the series appears in the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Chris wrote: I would like to add data from one or more x-y scatter plots to another x-y scatter plot. I have several plots containing data each representing a small map. I would like to add one of those plots (maps) to an existing plot (map) without individually creating a set of new series and adding each one, one at a time, to the plot. I would prefer to somehow simply copy and past the plot or somehow reference the plot to be added but can find no commands to allow me to do this. Thank you for you time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple scatter graphes how to plot 3 sets of data for x y on th. | Charts and Charting in Excel | |||
how to add data points to a scatter plot with trend line | Charts and Charting in Excel | |||
How do I copy data (word) into respective cells when the data bei. | New Users to Excel | |||
BUG?: Excel scatter chart: will not plot x-values | Excel Discussion (Misc queries) | |||
how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel |