Can I copy x-y scatter plot data direct from one plot to another?

C

Chris

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.
 
T

Tushar Mehta

That's an interesting idea but I don't know of any easy way to do it.
Depending on your VBA comfort level, you could write a VBA routine that
builds on John Walkenbach's http://j-walk.com/ss/excel/tips/tip83.htm.
John's tip may be more than enough for you but if your data
organization is sufficiently complex, the class module may return
incorrect results.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top