Hello!

I would like to develop an Area Chart that contains both Actual Data (data that is available for days before today), and Forecast Data (data that expect to have for the next 7 days). In order to make it appear easy to follow, I would like the format of the Area Chart to be different for the Actual and Forecast data.

I was able to easily create this phenomenon with Line Charts, however, I really want to do this with an Area Chart since each data series builds on the other.

How can I create an Area Chart, that for the past 7 days, the series are formatted one way, and for the next 7 days, they are formatted a different way (ideally, the forward 7 days will have a dashed fill, and the previous 7 days have a solid fill - same colors).

I attached a picture below that may better explain what I am trying.

I am OK with anything necessary (i.e. Macros, VB, etc.), but would likely need some guidance.

Thanks a bunch!!!

area_chartj.JPG