View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Nick1UK Nick1UK is offline
external usenet poster
 
Posts: 1
Default % distribution chart

I have a data range of 900 days (% daily performance) ranging from + 1.23%
down to -.86% and all possibilities in between. i wish to graph this data
range so that X axis is the daily % return and Y axis is the % of days with
said return. Bar cahrt that will look like a bell chart as most days have a
+.05/-.05% gain or loss with the central column as 0 going left along the X
axis will decend to say -1% and going right will ascend to say 1.5%.
I have seen it done but can not seem to create it myself.

best regards

nick