Hi,

See these explanations.

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

Cheers
Andy

Julien wrote:
> How to draw a line in bar chart which corresponds to a fixed value and would
> allow to compare the other values represented by the bars?
> Thanks a lot for your help!


--

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