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
|
|||
|
|||
Change the source data in multiple charts
See an example of a dynamic chart at www.stfx.ca/people/bliengme/ExcelTips
Bernard "rfogator" wrote in message ... I have a monthly report that I publish that has a large number of charts attached to it. Every month I go in and manually change the source data in each individual chart. The columns are the only thing that change in the source data, the rows remain the same. Is there a way to automate the process or make a blanket change to the columns in the source data to eliminate this tedious process?????? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Change the source data in multiple charts
On Thu, 23 Oct 2003 09:58:35 -0400, rfogator =
wrote: I have a monthly report that I publish that has a large number of char= ts attached to it. Every month I go in and manually change the source data in each individual chart. The columns are the only thing that change in the source data, the rows remain the same. Is there a way to automate the process or make a blanket change to the= columns in the source data to eliminate this tedious process?????? If Bernard's suggestion does not match your wish, I'd suggest recording = a = macro that changes the chart in the way you like. You'll probably have = to = edit the macro to make it do exactly what you want on each chart, but th= e = macro recorder will get you a long way. And if/when you try the macro = recorder, come back with questions as you get along. -- = Dave dvt at psu dot edu |
#3
|
|||
|
|||
Change the source data in multiple charts
I got tired of doing this by hand, so I wrote a little macro to handle
it. You can change any parts of text in the series formulas, much the same as Find-Replace works in the worksheet. To change the columns, I find it's safest to include the dollar signs, i.e., change $C$ to $D$, so you don't accidentally rename a worksheet or something. http://www.geocities.com/jonpeltier/...hgSrsFmla.html - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ rfogator wrote: I have a monthly report that I publish that has a large number of charts attached to it. Every month I go in and manually change the source data in each individual chart. The columns are the only thing that change in the source data, the rows remain the same. Is there a way to automate the process or make a blanket change to the columns in the source data to eliminate this tedious process?????? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|