View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Fenil Shah[_2_] Fenil Shah[_2_] is offline
external usenet poster
 
Posts: 17
Default Show average value as a horizontal line in a column chart

Hey Jon,

Thank you so much for your help. It worked like a dream! Thanks man

Fenil.

"Jon Peltier" wrote:

Here are some illustrated tutorials:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Fenil Shah" <Fenil wrote in message
...
Have created a column chart showing world GDP and World Merchandise
Exports(Annual percentage change) for the years 1995 to 2005. Want to
show
the average GDP growth (1995-2005) and average export growth (1995-2005),
both as horizontal dotted lines on the chart. How do I do it? I am using
Microsoft office XP pro.