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
|
|||
|
|||
Macro to upate the charts automatically
Hi,
I need help to build a macro that updates my charts based on the dates selected by the user. My charts has three lines which data is pulled from different tabs in the same spreadsheet. I would like to allow the user to select different fiscal weeks (start week and end week) and based on this range, the chart selected by the user would be updated. Since I have several charts, I need the user to select the time range and the chart he/she wants to update first, before running the macro? Any insights would be helpful. Thank you in advance. |
#2
|
|||
|
|||
Macro to upate the charts automatically
Actually, you may not need a macro. It's complicated, but I've written about
a formula and dynamic name approach he Dynamic Charting By Dates http://pubs.logicalexpressions.com/P...cle.asp?ID=246 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "CCheng" wrote in message ... Hi, I need help to build a macro that updates my charts based on the dates selected by the user. My charts has three lines which data is pulled from different tabs in the same spreadsheet. I would like to allow the user to select different fiscal weeks (start week and end week) and based on this range, the chart selected by the user would be updated. Since I have several charts, I need the user to select the time range and the chart he/she wants to update first, before running the macro? Any insights would be helpful. Thank you in advance. |
Thread Tools | |
Display Modes | |
|
|