I've figured out how to conditionally format my column graph columns
with help from Jon Pelletier's formula. I'd now like to add a line
graph to the overall graph to show overall business trending in
addition to the site trending in the columns. The existing graph
template that allows for column and lines only allows two series for
columns and any additional series must be lines. I need to have three
series for columns and one for a line. Does anyone know how I can do
this?

Forget those built-in custom types. They're not very flexible. If you learn
to make your own combos, you'll have a lot of power in your pocket.

Add the data for the line series to thee chart. Right-click the series,
choose Chart Type, and select a line style. Format to suit.

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


"Snow" wrote in message
...
I've figured out how to conditionally format my column graph columns
with help from Jon Pelletier's formula. I'd now like to add a line
graph to the overall graph to show overall business trending in
addition to the site trending in the columns. The existing graph
template that allows for column and lines only allows two series for
columns and any additional series must be lines. I need to have three
series for columns and one for a line. Does anyone know how I can do
this?

Thanks Jon, that worked perfectly.

Where would would be the best place to get info on making my own
combos?
you are right, that would be very powerful!

Appreciate all your help with conditional formatting and adding to the
graph.

Making your own combo chart simply means changing the chart type of an
individual series.

http://peltiertech.com/Excel/Charts/ComboCharts.html

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


"Snow" wrote in message
...


Thanks Jon, that worked perfectly.

Where would would be the best place to get info on making my own
combos?
you are right, that would be very powerful!

Appreciate all your help with conditional formatting and adding to the
graph.