Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 2nd 12, 01:26 PM
Junior Member
 
First recorded activity by ExcelBanter: Sep 2012
Posts: 4
Default how to copy XY charts into new worksheet?

I want to replicate an XY chart from Worksheet #1 into a new chart on Worksheet #2, but keeping the cell references exactly the same on each worksheet. By simply copying and pasting, the source data on the new chart in Worksheet #2 continues to point to the cell references on Worksheet #1. I want it to point to its own unique data values on Worksheet #2. Without a workaround, I must manually re-enter all the source data on Chart 2 and my XY chart has over 100 unique series, therefore it's very labor intensive. Thank you.

  #2   Report Post  
Old October 2nd 12, 04:04 PM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by Excel Poser View Post
I want to replicate an XY chart from Worksheet #1 into a new chart on Worksheet #2, but keeping the cell references exactly the same on each worksheet. By simply copying and pasting, the source data on the new chart in Worksheet #2 continues to point to the cell references on Worksheet #1. I want it to point to its own unique data values on Worksheet #2. Without a workaround, I must manually re-enter all the source data on Chart 2 and my XY chart has over 100 unique series, therefore it's very labor intensive. Thank you.
How about making a copy of the first worksheet then copying and pasting the second worksheet over this new one? You can then delete sheet 2.

I'm not sure there is an easier way.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy/Paste Charts; Define Destination of Charts in PowerPoint ryguy7272 Excel Programming 2 January 24th 08 09:04 PM
Copy Charts from Excel worksheet to PowerPoint Koulla Excel Programming 3 October 30th 06 03:28 PM
HELP!! Charts won't copy across to another worksheet David G Broadbent Charts and Charting in Excel 2 September 18th 06 09:51 PM
How to copy charts bob777 Excel Discussion (Misc queries) 0 November 30th 05 10:46 AM
COPY CHARTS msnews.microsoft.com[_6_] Excel Programming 1 September 27th 03 06:27 PM


All times are GMT +1. The time now is 12:59 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017