How do I make a chart with 4 bars on one axis/1 line on 2nd axis?

  • Thread starter Thread starter AnnieW
  • Start date Start date
A

AnnieW

I am trying to do something that seems like it should be simple with a custom
graph, but in trying to build my own custom graph am not seeing how to really
do any customizing.
I want to make a 2-axis chart, but instead of 1/2 the series being bars and
1/2 lines, I want to do all bars except for the very last one as a line (4
bars, 1 line).
I'm using MS Excel 2000.
Thanks for any help!
AnnieW
 
I want to make a 2-axis chart, but instead of 1/2 the series being bars and
1/2 lines, I want to do all bars except for the very last one as a line (4
bars, 1 line).
Click to expand...

So-called "combination" charts in Excel are a bit of a racket. They act
like they're offering you something special or difficult, but really,
every single series is individually customizable, within certain limits.

So just make a plain old bar chart, then right-click on the very last
series, and change the chart type to a line. You don't need those half
bar/half line "special" types.
 
Make the chart with five bars, right click the bar series you want as a
line, choose Chart Type, and choose a line type. Then right click on the new
line series, select Format, and navigate on the dialog until you have a
chance to change the axis to secondary.

- Jon
 
Del Cotter said:
So-called "combination" charts in Excel are a bit of a racket. They act
like they're offering you something special or difficult, but really,
every single series is individually customizable, within certain limits.
Click to expand...

In fact, the built-in combination charts are less flexible and predictable
than a combination chart you make yourself. Suppose you make a built in
combo with 2 lines and 2 columns, then you want to add 2 lines. Excel will
helpfully make the chart into a 3 line-3 column combo. If you create it
yourself from a 4 line series, and change two to columns, then Excel will
not be compelled to change what you've already done.

- Jon
 
In fact, the built-in combination charts are less flexible and predictable
than a combination chart you make yourself. Suppose you make a built in
combo with 2 lines and 2 columns, then you want to add 2 lines. Excel will
helpfully make the chart into a 3 line-3 column combo. If you create it
yourself from a 4 line series, and change two to columns, then Excel will
not be compelled to change what you've already done.
Click to expand...

That's terrible, I had no idea they did that. But that's because I never
touch the things.
 
Back
Top