Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I copy a graph and use the data in the new worksheet?
I have new data in different worksheets all with the same data format. I
want to make the same graph in each worksheet using the data in that worksheet but I was hoping not to have to recreate the graph and select all the data in each worksheet. Is there a way to do this as long as the data is in the same place in each worksheet? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I copy a graph and use the data in the new worksheet?
Copy the sheet with the chart. The chart points to the new sheet's data.
Copy a new set of data, and paste it over the data that the chart is pointing to, and the chart will update. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Brendanluc" wrote in message ... I have new data in different worksheets all with the same data format. I want to make the same graph in each worksheet using the data in that worksheet but I was hoping not to have to recreate the graph and select all the data in each worksheet. Is there a way to do this as long as the data is in the same place in each worksheet? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I copy a graph and use the data in the new worksheet?
That works great! Thanks.
"Jon Peltier" wrote: Copy the sheet with the chart. The chart points to the new sheet's data. Copy a new set of data, and paste it over the data that the chart is pointing to, and the chart will update. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Brendanluc" wrote in message ... I have new data in different worksheets all with the same data format. I want to make the same graph in each worksheet using the data in that worksheet but I was hoping not to have to recreate the graph and select all the data in each worksheet. Is there a way to do this as long as the data is in the same place in each worksheet? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I copy a graph and use the data in the new worksheet?
Hi
i think you can just right clicknon the graph and then copy and paste as normal "Brendanluc" wrote: I have new data in different worksheets all with the same data format. I want to make the same graph in each worksheet using the data in that worksheet but I was hoping not to have to recreate the graph and select all the data in each worksheet. Is there a way to do this as long as the data is in the same place in each worksheet? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I copy a graph and use the data in the new worksheet?
Doing this maintains the links to the data for the original chart, which is
tedious to relink if you have more than one or two charts. I showed Brendan an easier way to chart new data without having to redefine the chart's links. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "LADYBUG" wrote in message ... Hi i think you can just right clicknon the graph and then copy and paste as normal "Brendanluc" wrote: I have new data in different worksheets all with the same data format. I want to make the same graph in each worksheet using the data in that worksheet but I was hoping not to have to recreate the graph and select all the data in each worksheet. Is there a way to do this as long as the data is in the same place in each worksheet? |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I copy a graph and use the data in the new worksheet?
Jon,
For some reason I can't make this work. I copy the entire spredsheet with embedded graphs, but it is till referencing the original sheet and not the copy. Helge "Jon Peltier" wrote: Doing this maintains the links to the data for the original chart, which is tedious to relink if you have more than one or two charts. I showed Brendan an easier way to chart new data without having to redefine the chart's links. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "LADYBUG" wrote in message ... Hi i think you can just right clicknon the graph and then copy and paste as normal "Brendanluc" wrote: I have new data in different worksheets all with the same data format. I want to make the same graph in each worksheet using the data in that worksheet but I was hoping not to have to recreate the graph and select all the data in each worksheet. Is there a way to do this as long as the data is in the same place in each worksheet? |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I copy a graph and use the data in the new worksheet?
What version of Excel? The 2007 Beta doesn't do this correctly yet. If it's
not the Beta, then we don't know enough about the issue you're having. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Helge" wrote in message ... Jon, For some reason I can't make this work. I copy the entire spredsheet with embedded graphs, but it is till referencing the original sheet and not the copy. Helge "Jon Peltier" wrote: Doing this maintains the links to the data for the original chart, which is tedious to relink if you have more than one or two charts. I showed Brendan an easier way to chart new data without having to redefine the chart's links. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "LADYBUG" wrote in message ... Hi i think you can just right clicknon the graph and then copy and paste as normal "Brendanluc" wrote: I have new data in different worksheets all with the same data format. I want to make the same graph in each worksheet using the data in that worksheet but I was hoping not to have to recreate the graph and select all the data in each worksheet. Is there a way to do this as long as the data is in the same place in each worksheet? |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I copy a graph and use the data in the new worksheet?
I have the same problem now that I have Excell 2007. I can't copy a
worksheet with a graph and have the new sheet use the data on the new sheet for the graph. When will there be a fix for this problem? Thanks Carl Gray "Jon Peltier" wrote: What version of Excel? The 2007 Beta doesn't do this correctly yet. If it's not the Beta, then we don't know enough about the issue you're having. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Helge" wrote in message ... Jon, For some reason I can't make this work. I copy the entire spredsheet with embedded graphs, but it is till referencing the original sheet and not the copy. Helge "Jon Peltier" wrote: Doing this maintains the links to the data for the original chart, which is tedious to relink if you have more than one or two charts. I showed Brendan an easier way to chart new data without having to redefine the chart's links. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "LADYBUG" wrote in message ... Hi i think you can just right clicknon the graph and then copy and paste as normal "Brendanluc" wrote: I have new data in different worksheets all with the same data format. I want to make the same graph in each worksheet using the data in that worksheet but I was hoping not to have to recreate the graph and select all the data in each worksheet. Is there a way to do this as long as the data is in the same place in each worksheet? |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I copy a graph and use the data in the new worksheet?
I have experienced this problem in some circumstances, but when asked about
it this morning I could not reproduce the error. Stay tuned. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "cbanditos" wrote in message ... I have the same problem now that I have Excell 2007. I can't copy a worksheet with a graph and have the new sheet use the data on the new sheet for the graph. When will there be a fix for this problem? Thanks Carl Gray "Jon Peltier" wrote: What version of Excel? The 2007 Beta doesn't do this correctly yet. If it's not the Beta, then we don't know enough about the issue you're having. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Helge" wrote in message ... Jon, For some reason I can't make this work. I copy the entire spredsheet with embedded graphs, but it is till referencing the original sheet and not the copy. Helge "Jon Peltier" wrote: Doing this maintains the links to the data for the original chart, which is tedious to relink if you have more than one or two charts. I showed Brendan an easier way to chart new data without having to redefine the chart's links. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "LADYBUG" wrote in message ... Hi i think you can just right clicknon the graph and then copy and paste as normal "Brendanluc" wrote: I have new data in different worksheets all with the same data format. I want to make the same graph in each worksheet using the data in that worksheet but I was hoping not to have to recreate the graph and select all the data in each worksheet. Is there a way to do this as long as the data is in the same place in each worksheet? |
#10
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I copy a graph and use the data in the new worksheet?
Hi,
I'm trying to do the same thing, and copying the sheet works fine for most of the charts, but I'm having problems with some. The problem occurs with some filled in radar charts. They have only one series in the original chart plus axis labels. However, once the sheet is copied, the charts have two series with the axis labels as the other series (and not as axis labels). How do I stop excel from confusing axis labels with data points? Is is because the labels are numbers? (The labels span 0-360 as they signify degrees in a circle) It's really annoying because I have 30 of these charts on each sheet, so changing each one individually would be a really boring task. Thanks Asa "Jon Peltier" wrote: I have experienced this problem in some circumstances, but when asked about it this morning I could not reproduce the error. Stay tuned. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "cbanditos" wrote in message ... I have the same problem now that I have Excell 2007. I can't copy a worksheet with a graph and have the new sheet use the data on the new sheet for the graph. When will there be a fix for this problem? Thanks Carl Gray "Jon Peltier" wrote: What version of Excel? The 2007 Beta doesn't do this correctly yet. If it's not the Beta, then we don't know enough about the issue you're having. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Helge" wrote in message ... Jon, For some reason I can't make this work. I copy the entire spredsheet with embedded graphs, but it is till referencing the original sheet and not the copy. Helge "Jon Peltier" wrote: Doing this maintains the links to the data for the original chart, which is tedious to relink if you have more than one or two charts. I showed Brendan an easier way to chart new data without having to redefine the chart's links. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "LADYBUG" wrote in message ... Hi i think you can just right clicknon the graph and then copy and paste as normal "Brendanluc" wrote: I have new data in different worksheets all with the same data format. I want to make the same graph in each worksheet using the data in that worksheet but I was hoping not to have to recreate the graph and select all the data in each worksheet. Is there a way to do this as long as the data is in the same place in each worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|