Line and Column Graph

[Nikki]

I have a graph that has six series. Each column has a line that goes with it.
Ex-
Pink bar and Pink Line
Blue Bar and Blue Line
Green Bar and Green Line

Now all the lines line up on the middle bar which happens to be pink. I
want each data point to line up with the correct color bar not with the
middle bar.

 

[Barb Reinhardt]

What kind of bar chart do you have? Clustered, Stacked?

 

[Nikki]

Clustered-I saw there was a link to a website that had the directions - Now I
am not sure about how to add the spacing to the graph.
http://www.peltiertech.com/Excel/Charts/ClusterColAndLine.html

What kind of bar chart do you have? Clustered, Stacked?

 

[Jon Peltier]

Nikki -

The last approach, Line-Column Combination Chart with Sparse Data Range,
is probably easiest to get the spacing correct.

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

Clustered-I saw there was a link to a website that had the directions - Now I
am not sure about how to add the spacing to the graph.
http://www.peltiertech.com/Excel/Charts/ClusterColAndLine.html

: