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? |
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 |