How to make Three Bars and one line with a second axis in EXCEL

J

JAS123

I want to make a Chart in EXCEL such that I canhave three or more BARS and
one Line..The line I want in a second axis.
 
B

Barb R.

Let's say you have three series that you want for bars and one that you want
plotted as a line. Create a bar chart using all 4 series. Select the
series that you want to change to a line and right click on the series.
You can change the chart type for the series at this point. I believe it
will put it on a secondary axis automatically.
 

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

Make Y-axis values correspond to x- axis value 1
sideways stacked bar charts with line series on the same axis 0
Finding asymptote equation and how to draw them in excel 0
multiple series bar and line chart 2
Plotting Line Graphs to Specific Bar Graphs 0
simple chart 0
Odd chart type needed 1
Adding a line to a population bar chart 0

Top