Hummmmm. More puzzling than I anticipated. When I use the wizzard and try to
change just the columns I want to make into dtacked bars, I can't find
anything that controls just that set of data for the one year in question.
When I attempt to follow your direction, |Jon, I have trouble understanding
how I'm to proceedwithout that wizzard. I used the F11 key after reading
HELP but that was no help. I still can't control the one or two years I
want.
There are about a dozen series; two of these will be stacked columns and the
remaining 10 line type. I can't find a way to mix the types. I see two axes
charts but that still would let me stack the columns on one axes then draw
the lines on the other... or will it?
"jaygreg" wrote in message
...
Thanks guys. I'll give it a try.
"Jon Peltier" wrote in message
...
What Del forgot to tell you was to ignore the built-in custom chart
types
and construct your own combination chart. After you get the floating
columns looking right, add another series with the line data, which adds
another column on the stack. Select the new series, go to Chart menu
Chart Type, and select the Line chart subtype you want.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"Del Cotter" wrote in message
...
On Mon, 16 Jul 2007, in microsoft.public.excel.charting,
jaygreg said:
I'm using Excel 2003. I want to creat several bars on a Line-Bar chart
that
begin above the X axis. Example: scale is 0 to 4000. Several lines are
plotted but a few bars are need that start at numbers like 1200 to
3500;
the
bottom of the bar is at 1200 and the top is at 3500. Can someone give
me
a
thumbnail on how to do this or poit me to a reference please.
Make a Stacked Column type of chart, with the first bar being 1200 and
the second bar being 3500-1200=2300. Then format the lower bar so that
it
has no line and no fill. Now it's invisible, so the top bar looks as
though it's floating in air.
--
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.