Bar Chart with Vertical Line

  • Thread starter Thread starter Barb Reinhardt
  • Start date Start date
B

Barb Reinhardt

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,

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
 
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 said:
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
Click to expand...
 
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 said:
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.
Click to expand...
 
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.

Cheers
Andy

Barb said:
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
Click to expand...
 
I got it to work, but I'm not sure I could explain what I did. Thanks for
your assistance.


Andy Pope said:
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.

Cheers
Andy
Click to expand...
 
Back
Top