| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how to globally change souce data on plot
I have a x-y scatter chart with about 40 individual lines originating from
individual spreadsheet tab for each line. I need to clone this chart multiple times, changing only the column references for the x and y parameters. To accomplish this I currently go to "chart," "source data" and manually change the x and y references for each line. Is there a way to globally change the cell references for all line on the chart? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple scatter graphes how to plot 3 sets of data for x y on th. | Charts and Charting in Excel | |||
| MS Query Data Source Change | Excel Discussion (Misc queries) | |||
| Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
| scatter plot & label for a data point | Charts and Charting in Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
