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