Jon,
Thanks so much. You have ended my frustrations. I was almost there but
didn't realize the cells had to be null.
Thanks again,
Cheryl

"Jon Peltier" wrote:

I did this for a line-chart-only chart here, but it can easily be extended
to your combo chart:

http://peltiertech.com/WordPress/200...area-charts-1/

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


"CB" wrote in message
...
I have a combination chart that shows bars for each months sales
projections
and actual sales. I also have lines that represent the cumulative actual
sales and the cumulative projected sales. I would like to show the actual
sales to date and continue that line from current date with the projected
sales. Any Ideas?