How do I change a data series from bars to lines in an Excel char.

G

Guest

I am creating a chart with 2 Y axis, one is percent and the other numbers.
There are 5 data series for the percent axis which I want to display as
lines, and 2 series for the numbers which I want to show as bars. Excel
seems to automatically make half the series bars and half lines. How can I
convert some of the bars to lines?
 
G

Guest

mrocke,

To change a bar series to a line series, click once on one of the bar series
that you want to convert to a line. Right-click on your mouse, go to Chart
Type in the menu, and select a line chart. Hit the OK button.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Error Bars to Series and Colour 1
multiple series bar and line chart 2
How do I make a chart with 4 bars on one axis/1 line on 2nd axis? 4
One Column on 1st y-axis and 3 lines on 2nd y-axis 1
2nd Axes - primary series data of only 1 series disappears! 1
Line chart with vertical bars 2
Column Chart with 2 axes 7
Creating a Combination Bar Chart with 2 Lines 1

Top