Devise a chart for this data

[neodjandre]

Hello,

Could someone help me devise an appropriate chart for these kind of data?

I am using Excel 2010

http://img.photobucket.com/albums/v158/neodjandre/ScreenHunter_07Mar162331.jpg

many thanks in advance
Andy

 

[shg]

Maybe normalize the the average and average +/- 1 standard deviation to the chart scale and then plot on a high/low/close (stock) chart:

      -A- -B-- --C--- --D--- E ----F---- --G--- --H--- --I---
  1   Min Max   Avg   St Dev              High   Low   Close 
  2    0   90  38.54  25.75    Exp-Inexp 71.43  14.21  42.82 
  3    1   96  40.66  26.54      Lux-Ess 69.68  13.81  41.75 
  4    1   92  38.11  28.24      Lrg-Sml 71.81   9.75  40.78 
  5    1  100  38.28  27.91    Cons-Save 65.85   9.46  37.66

G2 and down: =100* (C2+D2-$A2)/($B2-$A2)

H2 and down: =100* (C2-D2-$A2)/($B2-$A2)

I2 and down: =100* (C2-$A2)/($B2-$A2)

 

[neodjandre]

ok I was able to do that but I can't seem to draw any conclusions by looking at the chart... can you?

thanks a lot for the help

 

[shg]

Says to me people are scaling back, but not overwhelmingly, and they are widely dispersed.

You're welcome.