View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
SD[_3_] SD[_3_] is offline
external usenet poster
 
Posts: 2
Default Line Charts or ?

Hello All,

Thinking ways on how to create charts for the following data ... I
mean , if I use line charts , its all over the place, which would be
the best chart for this kind of data, so that it effectively comes out
nicely ? Should we just take off value of A which are greater than
100% and mention that in the side ? Any help would be appreciated .

thanks
SD


Qtr1 2005 Qtr2 2005 Qtr3 2005 Qtr4 2005 Qtr1 2009 Qtr2
2009 Qtr3 2009
A 185% 150% 100% 108% 23% 10% -1%
B 0% -3% -2% 2% 11% 4% 4%
C 2% -5% -5% -1% 10% 1% -2%
D -18% -15% -19% -17% 13% 9% 2%
E 4% 7% -5% -7% -15% -19% -18%
F 8% 12% 4% 8% 16% 8% 11%
Market -3% 0% -3% -1% 7% 2% -3%