on bar graph, how to superimpose line of average values over bars

G

Guest

i am creating a bar graph with death rates for 8 cities in los angeles for a
particular disease. Now I would like to draw a constant line at a particular
rate through the entire bar graph to indicate the target rate.
 
G

Guest

Thanks that was very helpful. I got stuck on a minute detail: Label Last
Point. Currently the value of my horiz line is labeled at the 0 x-axis point
and it is also labeled at the 1-axis point on my secondary axis. I was
reading through the link titled "Label Last Point" but it is talking about
creating a module. I'm not exactly sure how to do that. Any ideas?
 
A

Andy Pope

You need to go to the VBE (visual basic editor) within excel ALT+F11
In the project window you should see your current workbook. Select it
and then via the menus Insert > Module. This will add a code module to
your project. You can then copy/paste the code.

Here is a non vba solution
http://www.andypope.info/charts/Labellast.htm

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 Variable Graph - want average line??? 1
How do I insert symbol to indicate significance on a bar graph? 1
How do 1 bar & 2 line series over the correct date? 1
How do I change bars into just lines on a bar graph? 1
How to add different error bars to each data point in excel 2
How to insert a dotted line in a graph to indicate an average num 3
Stacked columns width too thin - how can I alter? 1
How do I use a single cell value to chart a horizontal line in Exc 9

Top