Adding a line to my CF column graph - help!

  • Thread starter Thread starter Snow
  • Start date Start date
S

Snow

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
 
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.
 
Back
Top