M
MJ
BACKGROUND:
First off, I inherited a set of graphs (line chart over area chart) that
track a set of 3 percentages numbers along a timelime from left to right
(older to newest). In these graphs the data series covers the date ranges in
the data table all the way to the right (even if the value is NULL), ie:
02/02 02/09 02/16 02/23 ... 07/05 07/12 07/19 07/26
(1) 35.6 37.2 37.8 39.7 ... 39.1 36.8
(2) 42.3 40.2 39.8 37.6 ... 43.2 44.1
(3) 22.1 22.6 22.4 22.7 ... 18.6 19.1
In the original graphs the data series lines in each case would plot the
point for that respective week and when it reached the end of the data (7/12)
the plot stops. It does NOT drop to zero even though the data series
includes the cells through to 7/26.
CURRENT PROBLEM:
I recently made some changes to these graphs (adding an another graph on
same page with a different data table). I did NOT make any change to the
Chart Type, Source Data, or Cart Options... but now the graphs drop off to
zero and track to the end of the data source (time).
I want it to stop at the point the data stops, not to the end of the date
range (as it did in BACKGROUND before I made the change of adding another
graph). I know I cloud brute force it by changing the data source each time
but this is not practical since there are 30 tabs of graphs and this is
produced weekly.
Can any of you help me fix this minor problem and major frustration?
Thanks in advance for your help.
First off, I inherited a set of graphs (line chart over area chart) that
track a set of 3 percentages numbers along a timelime from left to right
(older to newest). In these graphs the data series covers the date ranges in
the data table all the way to the right (even if the value is NULL), ie:
02/02 02/09 02/16 02/23 ... 07/05 07/12 07/19 07/26
(1) 35.6 37.2 37.8 39.7 ... 39.1 36.8
(2) 42.3 40.2 39.8 37.6 ... 43.2 44.1
(3) 22.1 22.6 22.4 22.7 ... 18.6 19.1
In the original graphs the data series lines in each case would plot the
point for that respective week and when it reached the end of the data (7/12)
the plot stops. It does NOT drop to zero even though the data series
includes the cells through to 7/26.
CURRENT PROBLEM:
I recently made some changes to these graphs (adding an another graph on
same page with a different data table). I did NOT make any change to the
Chart Type, Source Data, or Cart Options... but now the graphs drop off to
zero and track to the end of the data source (time).
I want it to stop at the point the data stops, not to the end of the date
range (as it did in BACKGROUND before I made the change of adding another
graph). I know I cloud brute force it by changing the data source each time
but this is not practical since there are 30 tabs of graphs and this is
produced weekly.
Can any of you help me fix this minor problem and major frustration?
Thanks in advance for your help.