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.

--

MJ

With the chart selected: Tools } Option } Chart and specify how missing data
is to be treated.
With so many chart this could be a task. Maybe someone will write you a VBA
procedure but it is too late at night for me.
Any way new data could have =NA() in place of blanks?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"MJ" wrote in message
...
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.

--

MJ

Get GrabIt add-in for $ on the website http://www.datatrendsoftware.com/
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"MJ" wrote in message
...
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.

--

MJ

Sorry, I was replying to another message
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Bernard Liengme" wrote in message
...
Get GrabIt add-in for $ on the website http://www.datatrendsoftware.com/
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"MJ" wrote in message
...
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.

--

MJ