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.