Hi,

Create a column chart for all the data and then select the series you want
to plot as a line.
Change the chart type for this series.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"ddavis13" wrote in message
...
I have 6 products that I have created a bar chart for showing total units
sold for 5 years. I want to add a line (just one) that shows the total
units
sold for the entire product category over the same time period to the same
chart. I tried combination chart but it changes 1/2 the product to line
and
keeps 1/2 of them bars...