Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 22nd 06, 10:37 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 2
Default on bar graph, how to superimpose line of average values over bars

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.

  #2   Report Post  
Old August 22nd 06, 10:45 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default on bar graph, how to superimpose line of average values overbars

Hi,

Rather than drawing the line using shapes, which will be static, add an
extra data series. Here are a few pages on the subject.

http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm
http://www.processtrends.com/pg_char...ontal_line.htm

Cheers
Andy

Kavitha wrote:
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.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Old August 23rd 06, 12:23 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 2
Default on bar graph, how to superimpose line of average values over b

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?

"Andy Pope" wrote:

Hi,

Rather than drawing the line using shapes, which will be static, add an
extra data series. Here are a few pages on the subject.

http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm
http://www.processtrends.com/pg_char...ontal_line.htm

Cheers
Andy

Kavitha wrote:
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.


--

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

  #4   Report Post  
Old August 23rd 06, 08:59 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default on bar graph, how to superimpose line of average values overb

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

Kavitha wrote:
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?

"Andy Pope" wrote:


Hi,

Rather than drawing the line using shapes, which will be static, add an
extra data series. Here are a few pages on the subject.

http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm
http://www.processtrends.com/pg_char...ontal_line.htm

Cheers
Andy

Kavitha wrote:

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.


--

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


--

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line Graph with 2 lines Need help making line graph with 2 lines Charts and Charting in Excel 5 May 19th 06 08:42 PM
Different lines in a spreadsheet on the same line in graph? Leisha Phifer Charts and Charting in Excel 1 May 9th 06 08:42 PM
line of best fit/reading values from graphs Becky Hutchinson Excel Discussion (Misc queries) 4 December 27th 05 07:16 PM
Line Graph Problem Nick I Charts and Charting in Excel 2 October 6th 05 02:06 PM
How can i make values appear at the top of bars in a bar graph? Dylan Charts and Charting in Excel 1 January 28th 05 02:16 AM


All times are GMT +1. The time now is 11:15 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017