Charting

[SD]

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%

 

[Bernard Liengme]

Line chart would be best
But why not put the A data series on a secondary axis, then the lower values
will clearly display
best wishes

 

[Anthony Fontana]

One of the first things you need to do when choosing a chart is to decide
what you are trying to show. If you want to show trends over time, a line
chart would be good. If you want to show parts of a whole, a PIE chart would
be a top choice. Stacked column charts kind of mix the two - parts of a
whole and trends over time.

What do you want to show with this data?

 

[Tim Mastrogiacomo]

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%

If you are trying to show changes within each group relative to
itself, you can normalize the data and then chart it.


Tim Mastrogiacomo