Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
% 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How may I macro update a normal distribution chart from new data? | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |