View Single Post
  #5   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.charting,microsoft.public.excel.printing
Andy Pope
 
Posts: n/a
Default How to add an average line to a bar chart?

<tongue firmly in check
Mine of course!
</tongue firmly in check

It really depends on the complexity of your chart and data.
But for a Bar chart the xy-scatter approach would probably be best.

Cheers
Andy

Dmitry wrote:
Which method is better?
"Andy Pope" сообщил/сообщила в новостях следующее:
...

Hi,

The following pages have examples of how to add lines.

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

Dmitry wrote:

Hello specialists!
How to add an average line to a bar chart like in the following chart?:
Best regards,
Dima


--

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





--

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