Format second series as line chart

[Shorty]

How do you " Format second series as line chart" ? I am trying to add an
average line to a bar chart. Thank You

 

[Jon Peltier]

Shorty -

Add the series first. Then select it, choose Chart Type from the Chart
menu, and pick the line style you want.

I have some additional techniques for adding lines to charts here:

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

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