| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
chart series macro
I have a line chart that feeds from data as below. Is there a way to write a
macro that automatically feeds the chart with the latest 13 weeks of data? (only percentages above 0.0%). Thanks. Tony. Week Total 1 59.06% 2 71.68% 3 47.80% 4 48.63% 5 60.44% 6 79.66% 7 61.81% 8 88.14% 9 78.80% 10 94.35% 11 119.80% 12 149.79% 13 118.44% 14 105.85% 15 0.0% 16 0.0% 17 0.0% |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add series to a chart using a macro | Excel Programming | |||
| macro to change series xvalues in chart | Excel Programming | |||
| Expand Chart Macro to Plot Multiple Series | Excel Programming | |||
| Use a macro to expand data series for chart? | Charts and Charting in Excel | |||
| Adding data series to chart via macro | Charts and Charting in Excel | |||
Threaded Mode
