T
Tony7659
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%
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%