Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cells don't upate | Excel Discussion (Misc queries) | |||
Automatic Upate of NOW() function? | Excel Worksheet Functions | |||
link excel charts to web pages and update charts automatically | Charts and Charting in Excel | |||
Automatically create charts | Charts and Charting in Excel | |||
Is there a macro to create charts automatically? | Charts and Charting in Excel |