Excel chart : I want to plot on the same chart bar and line

G

Guest

I'm having trouble with the custom bar and line chart.
I have an average and 3 sub groups for 3 years (X axis)
The average and sub groups can share one axis.
I want the average as a bar, the 3 subs as lines.
All I can get currently is 2 bars and 2 lines - I cannot make the first sub
group move from a bar to a liine presentation. How do I do this?
Thanks
 
J

Jon Peltier

It will help if you use the Excel terminology. If the bars are vertical,
it's a column chart.

Forget the built in custom types. Make a line chart with all of your data.
Select the series you want to change, go to Chart menu > Chart Type, and
select a column type.

Voila, your first homemade combination chart!

- 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

How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Odd chart type needed 2
plot range bar chart 1
Help with Bar-Line Chart..not aligned?? 1
Adding a line to a bar chart 1
Chart with columns and lines 1
A line chart 3
Line and Bar on same chart 2

Top