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

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.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______