Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Paste a chart and get the source data to be from the new worksheet
I want to paste an Excel chart from worksheet 1 to worksheet 2 and for the
newly pasted chart in sheet 2 to reference the sourse data as worksheet 2 not its original data from sheet 1. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Paste a chart and get the source data to be from the new worksheet
Here's an easy way to get what you want.
1. Copy the whole worksheet that the chart is embedded in. 2. Copy the new data you want in the copied chart. 3. Select the data range of the copied sheet. 4. Use Paste Special - Formulas or Values to put the desired data in the chart's source data range. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Excelfool" wrote in message ... I want to paste an Excel chart from worksheet 1 to worksheet 2 and for the newly pasted chart in sheet 2 to reference the sourse data as worksheet 2 not its original data from sheet 1. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Paste a chart and get the source data to be from the new worksheet
I am also trying to do the same thing. I have about 50 worksheets - making
a copy of the one sheet that has the graph then copying and pasting the entire contents of each of the other 49 sheets, then renaming the sheet after it is pasted is a lot of work. Is there not some other simple way to make the graph series definitions "relative" such that pasting the plot on each sheet references the same cells but on the new sheet? Thanks, Rick "Jon Peltier" wrote in message ... | Here's an easy way to get what you want. | | 1. Copy the whole worksheet that the chart is embedded in. | 2. Copy the new data you want in the copied chart. | 3. Select the data range of the copied sheet. | 4. Use Paste Special - Formulas or Values to put the desired data in the | chart's source data range. | | - Jon | ------- | Jon Peltier, Microsoft Excel MVP | Tutorials and Custom Solutions | http://PeltierTech.com | _______ | | | "Excelfool" wrote in message | ... | I want to paste an Excel chart from worksheet 1 to worksheet 2 and for the | newly pasted chart in sheet 2 to reference the sourse data as worksheet 2 | not | its original data from sheet 1. | | |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Paste a chart and get the source data to be from the new worksheet
No. If there were an easier way, I would have shared it.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Rick J" wrote in message ... I am also trying to do the same thing. I have about 50 worksheets - making a copy of the one sheet that has the graph then copying and pasting the entire contents of each of the other 49 sheets, then renaming the sheet after it is pasted is a lot of work. Is there not some other simple way to make the graph series definitions "relative" such that pasting the plot on each sheet references the same cells but on the new sheet? Thanks, Rick "Jon Peltier" wrote in message ... | Here's an easy way to get what you want. | | 1. Copy the whole worksheet that the chart is embedded in. | 2. Copy the new data you want in the copied chart. | 3. Select the data range of the copied sheet. | 4. Use Paste Special - Formulas or Values to put the desired data in the | chart's source data range. | | - Jon | ------- | Jon Peltier, Microsoft Excel MVP | Tutorials and Custom Solutions | http://PeltierTech.com | _______ | | | "Excelfool" wrote in message | ... | I want to paste an Excel chart from worksheet 1 to worksheet 2 and for the | newly pasted chart in sheet 2 to reference the sourse data as worksheet 2 | not | its original data from sheet 1. | | |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Paste a chart and get the source data to be from the new worksheet
Thanks John - Rick
"Jon Peltier" wrote in message ... | No. If there were an easier way, I would have shared it. | | - Jon | ------- | Jon Peltier, Microsoft Excel MVP | Tutorials and Custom Solutions | http://PeltierTech.com | _______ | | | "Rick J" wrote in message | ... | I am also trying to do the same thing. I have about 50 worksheets - making | a copy of the one sheet that has the graph then copying and pasting the | entire contents of each of the other 49 sheets, then renaming the sheet | after it is pasted is a lot of work. Is there not some other simple way | to | make the graph series definitions "relative" such that pasting the plot on | each sheet references the same cells but on the new sheet? | | Thanks, | Rick | | | "Jon Peltier" wrote in message | ... | | Here's an easy way to get what you want. | | | | 1. Copy the whole worksheet that the chart is embedded in. | | 2. Copy the new data you want in the copied chart. | | 3. Select the data range of the copied sheet. | | 4. Use Paste Special - Formulas or Values to put the desired data in the | | chart's source data range. | | | | - Jon | | ------- | | Jon Peltier, Microsoft Excel MVP | | Tutorials and Custom Solutions | | http://PeltierTech.com | | _______ | | | | | | "Excelfool" wrote in message | | ... | | I want to paste an Excel chart from worksheet 1 to worksheet 2 and for | the | | newly pasted chart in sheet 2 to reference the sourse data as | worksheet | 2 | | not | | its original data from sheet 1. | | | | | | | | |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Paste a chart and get the source data to be from the new worksheet
This thread depresses me.
I have a file which has 100+ sheets in it, with each sheet named after a date and filled with all sorts of data. A new chart per sheet has been requested and it would be great to be able to remove the sheet name and have the source data be relative and just copy and paste the chart 100+ times across the sheets. It seems I'm going to have to actually create a chart 100+ times, which stinks. "Excelfool" wrote: I want to paste an Excel chart from worksheet 1 to worksheet 2 and for the newly pasted chart in sheet 2 to reference the sourse data as worksheet 2 not its original data from sheet 1. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|