Creating a Combination Bar Chart with 2 Lines

G

Guest

I am trying to create a bar chart with 2 line series. The Y-axis for the
vertical bars would be on the left and the Y-axis for the 2 line series would
be on the right (3 series were defined). The horizontal axis for all series
are calendar months (Jan, Feb, etc.) Every time I setup the chart my chart
only displays a single line, ignoring the other line series. The vertical
bars come out fine.

Any thoughts on what I am doing wrong?

Thanks
Bill Falzone
 
J

Jon Peltier

Don't use the built in types. Make the chart using all columns. Select a
series that you want to change (click on it right in the chart), then go to
Chart menu > Chart Type, and pick a line sub-type. Select the next one you
want to change and repeat (or use F4 as a shortcut key to repeat). Then
select a series you want on the secondary axis, go to Format menu > Selected
Series, and on the Axis tab, choose Secondary. Select the next and repeat
(F4).

- Jon
 

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

combination chart 1
vertical scale on both ends of bar chart 1
Odd chart type needed 2
Chart with columns and lines 1
One Column on 1st y-axis and 3 lines on 2nd y-axis 1
Column Chart with 2 axes 7
Stacked column chart narrow bars wanted 5
multiple series bar and line chart 2

Top