Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Copying charts with automatic change of data source
I need to chart a lot of small tables that I generate by copy and paste to
have different data depending on the data I paste it next to. It takes me a long time to set up a chart for even one of these tables and I need to paste like over 100 of them. I'd like to be able to copy the table I'm making (it pulls data from other areas in the spreadsheet depending upon where I paste it) along with a chart which changes as the associated table is pasted. The pasted table works fine, but when I copy the chart, the data always refers back to the original table. If I try and just make another chart by highlighting the whole table and inserting a chart, I find I have to do all sorts of changes to make the chart work. How do I copy a chart so that the data it pulls from changes in a relational way as does the copy/paste of Excel formulas? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Copying charts with automatic change of data source
What you need to do is copy the whole sheet that contains the data range
and chart. The chart on the copied sheet refers to the data on the copied sheet. Replace this copied data with the new data, so the copied chart relates to the new data. If you want the tables and charts on a single sheet, select the range that includes the table and chart on the copied sheet, cut (don't copy) and switch to the other sheet, select a cell, and paste. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Abracadabra wrote: I need to chart a lot of small tables that I generate by copy and paste to have different data depending on the data I paste it next to. It takes me a long time to set up a chart for even one of these tables and I need to paste like over 100 of them. I'd like to be able to copy the table I'm making (it pulls data from other areas in the spreadsheet depending upon where I paste it) along with a chart which changes as the associated table is pasted. The pasted table works fine, but when I copy the chart, the data always refers back to the original table. If I try and just make another chart by highlighting the whole table and inserting a chart, I find I have to do all sorts of changes to make the chart work. How do I copy a chart so that the data it pulls from changes in a relational way as does the copy/paste of Excel formulas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot change data source for copied charts | Charts and Charting in Excel | |||
change source data in multiple charts | Charts and Charting in Excel | |||
Copying Charts While Changing Source Data | Charts and Charting in Excel | |||
Auto-increment data source cell references when copying charts | Excel Discussion (Misc queries) | |||
How do I create charts that change source data automatically? | Charts and Charting in Excel |