S Shorty Aug 1, 2004 #1 How do you " Format second series as line chart" ? I am trying to add an average line to a bar chart. Thank You
How do you " Format second series as line chart" ? I am trying to add an average line to a bar chart. Thank You
J Jon Peltier Aug 1, 2004 #2 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/ _______
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/ _______