Hi;
I am an advanced user of Excel - at least to the degree that I use Excel regularly and have some solid fundamentals under my belt. However, I am perplexed on how to graph something a little unusual. Consider it a 'special case' graphing request. Here are the details ....
1. On the X axis, I would like time based values, one week for 6 months / 1 year at a time is fine.
2. On the Y axis, I would like values from 0 to 100 - essentially I would like the Y axis to represent the percentage chance that something is going to happen.
3. In the graph area itself I would like 'ball' or 'balloons' to cross the X and Y axis so (for example something that is planned to happen in week 1 has a 40% chance of happening, and something that is planned to happen on week 5 has a 70% chance of happening).
3.1 I would like the SIZE of the balloon to be related to the value of the event. (For example in week 1, there is a 40% chance something will happen and it will be worth 100$, and in week 5 there is a 70% chance something will happen and it will be worth 300$).
3.2 I have a requirement that the 'balls' / 'balloons' be coloured based on what kind of event will happen. (For example in week 1, there is a 40% chance something will happen and it will be worth 100$ and it deals with our New York office, and in week 5 there is a 70% chance something will happen and it will be worth 300$ and it deals with our London office).
Help! I have struggled with this for a while - and I am not having any fun at all now.
Andrew L.
Bookmarks