how to globally change souce data on plot

S

scoons

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Non Linear Scatter plot, need to find y value 3
Plot area changed after reopen document 0
Chart Plot Area changes in Excel 2007 0
Getting data point from an accel chart 0
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Chart size relative to contents 1
Labeling on independently stacked line chart 0

Top