View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Del Cotter Del Cotter is offline
external usenet poster
 
Posts: 560
Default How do I make a chart with 4 bars on one axis/1 line on 2nd axis?

On Fri, 15 Aug 2008, in microsoft.public.excel.charting,
Jon Peltier said:
"Del Cotter" wrote in message
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.


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.


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

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.