If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
how to globally change souce data on plot
This web page describes a technique to change series formulas en masse:
http://peltiertech.com/Excel/Charts/ChgSrsFmla.html It provides a link to a workbook that contains a macro to change these formulas. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "scoons" wrote in message ... 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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cross program data sharing | m_jurrens | General Discussion | 1 | December 16th, 2005 05:29 PM |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
Sort pages? | David | General Discussion | 15 | May 13th, 2005 11:33 PM |
Charting data ranges that change | mikelee101 | Charts and Charting | 2 | December 16th, 2004 11:07 PM |
Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |