A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old June 1st, 2005, 12:14 AM
Chris
external usenet poster
 
Posts: n/a
Default 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.
  #2  
Old June 3rd, 2005, 01:00 PM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default

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

In article ,
says...
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  
Old June 3rd, 2005, 01:20 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default

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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy data between 2 Excel for comparison Boba General Discussion 1 February 18th, 2005 01:56 AM
Format on data to import to Access tables? (I need your advice) Niklas Östergren General Discussion 5 December 13th, 2004 03:54 PM
Is this possible with Excel Chart? q582gmzhi Charts and Charting 1 September 8th, 2004 03:33 AM
Scatter plot changes to line plot with data gaps Jim Charts and Charting 14 October 8th, 2003 05:10 PM


All times are GMT +1. The time now is 10:01 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.