Need help with an Excel Graph

[Nikki91775]

I know some of you out there are excellent with Excel charts so that is why I posting this.


I am in need of a graph that looks like a bucket in some sense. I want to show my PY Order numbers as a flat line across. Than I want to show my current year orders as another line, and we are down so it would be below the flat line. So we want an open space so we know we need countermeasures to get to the number. Then I need just two points at the top of the straight line showing our plan number and stretch number.


So lets just say this is what I have to plot:


Stretch Target = 10

Plan Target = 9

Actual Orders = 7

PY Orders = 8


Let me know if you have any ideas.

 

[Hui]

Nikki


Have a look at:

https://www.dropbox.com/s/e14ie3uxxbw9oee/Bucket%20Chart.xlsm


It uses similar techniques as described here

http://chandoo.org/wp/2011/04/13/how-to-make-a-5-star-chart/

Except that it uses a Scatter chart as the base

 

[Nikki91775]

Hi, I cannot see anything from dropbox, we have it blocked. Can you e-mail me at xxx ?


Thanks.

 

[Hui]

Can some else email

I've gone to bed

 

[NARAYANK991]

Hi Nikki ,


I have sent it to your email address.


Narayan