View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
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