Thank you! I thought that would change the entire graph. I don't suppose
there is a way to do it with side by side, instead of clustered, columns?

Julie

"Jon Peltier" wrote:

Select the series you need to change, then on the Chart menu, select
Chart Type, and choose a clustered column for this series.

Next time, don't even frustrate yourself with the custom chart type,
just start by making a clustered column chart, then select the total out
of this mess, and use Chart Chart Type to make it a line.

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


IOWAJulie wrote:

I have a data set with 3 numbers and a total. I'd like to total to display
differently than the 3 numbers. I'd prefer a bar chart (side by side, not
stacked) with a line for the total.

Thank you!