I have 2 sets of data (order qty and forecast qty) that I would like
to chart on a line graph. x-axis by month, y-axis by quantity. The
forecast qty line would run along the entire x-axis for the 12 months.
However, the order qty line would only be filled in at the end of
each month. For example in May, the order qty line would only show
data for qty order Jan - May. The forecast line would extend from Jan
- Dec.

Problem:
The order qty line would display "0" for months June-December. This
causes the trend line to be skewed when compared to just charting both
lines from Jan - May. Is there a way to have the forecast line for
the entire year and the order qty line only display display a partial
trend line that will extend automatically when inserted into the data
table.

Hamilton

Hamilton -

Use dynamic ranges to chart the data. This way, there are no zeros in
the actual data. For examples and links:

http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

hamking wrote:

> I have 2 sets of data (order qty and forecast qty) that I would like
> to chart on a line graph. x-axis by month, y-axis by quantity. The
> forecast qty line would run along the entire x-axis for the 12 months.
> However, the order qty line would only be filled in at the end of
> each month. For example in May, the order qty line would only show
> data for qty order Jan - May. The forecast line would extend from Jan
> - Dec.
>
> Problem:
> The order qty line would display "0" for months June-December. This
> causes the trend line to be skewed when compared to just charting both
> lines from Jan - May. Is there a way to have the forecast line for
> the entire year and the order qty line only display display a partial
> trend line that will extend automatically when inserted into the data
> table.
>
> Hamilton