Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Bar Chart with Vertical Line

Skip to first unread message

Barb Reinhardt

unread,
Nov 15, 2004, 9:34:50 AM11/15/04
to
I have a Bar Chart with Character data in the Y axis and numeric data in the
X axis. I want to put a vertical line on the chart. I have reviewed Jon
Peltier's documents on putting horizontal and vertical lines on Column
Charts, but haven't been able to get it to work for Bar Charts. Can
someone assist?

Thanks,
Barb


Andy Pope

unread,
Nov 15, 2004, 9:41:01 AM11/15/04
to
Hi Barb,

Have a look at my average line example. There is a sheet detailing
methods for Bar charts.
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

Barb Reinhardt wrote:

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Barb Reinhardt

unread,
Nov 15, 2004, 10:10:47 AM11/15/04
to
Andy,

I've been able to put a horizontal line on a "Column Chart" (like your
example), but have not been able to put a vertical line on a "Bar Chart".
I'm using the Excel terms for charts here. When I put in the data on the
chart for the horizontal line and then change it to a "line" chart, the line
is drawn horizontally on the graph and the axis labels change. I have not
been able to get a vertical line on a bar chart at all.

Barb

"Andy Pope" <an...@andypope.info> wrote in message
news:%23RdqnEy...@tk2msftngp13.phx.gbl...

Andy Pope

unread,
Nov 15, 2004, 10:53:50 AM11/15/04
to
You need to use an xy scatter instead of Line chart. This will then
allow you to get the vertical line.

Do you check the workbook. It has examples for column, bar and area charts.

Barb Reinhardt

unread,
Nov 15, 2004, 12:58:35 PM11/15/04
to
When I first reviewed your site, it read like it was for Column Charts, not
Bar Charts. You may want to update that. I'm very hesitant to d/l anything
if it isn't obvious that it might be useful.

I'm still having difficulty. What I did forget to mention is that I have a
stacked bar chart. Should this still work?

Barb

"Andy Pope" <an...@andypope.info> wrote in message

news:uPb3Ttyy...@TK2MSFTNGP12.phx.gbl...

Andy Pope

unread,
Nov 15, 2004, 4:14:40 PM11/15/04
to
You maybe right about the lack of detail on the web page, I'll add that
to my ToDo List :)

If you are still having difficulties you can privately email me you
workbook and I will take a look see.

Barb Reinhardt

unread,
Nov 15, 2004, 4:44:49 PM11/15/04
to
I got it to work, but I'm not sure I could explain what I did. Thanks for
your assistance.


"Andy Pope" <an...@andypope.info> wrote in message

news:%23uYPbh1...@TK2MSFTNGP15.phx.gbl...

0 new messages