Make the chart with two series. Put all the dates in column A, put the
actuals in column B down to some date with blanks below, put the forecast in
column C from that date downward with blanks above. Plot this data, format
the two series the way you want them to appear (one solid, one dashed). As
you add an actual value, delete a forecast value. The chart keeps up
automatically.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"sahafi" wrote in message
...
I have a line chart with weekly data for 2 years. Weeks on the X axis and
Pounds on the Y axis. They represents actual and forecasted pounds. I need
to
show the first portion of the line (actual) with solid color while the
rest
of the line (forecast) with dotted line. We are talking about one single
line
for production. How can I accomplish this? I don't want to do it manually.
I'd rather have it changes automatically every week when the actual data
override the forecasted data.
Thanks.
sahafi