Excelfan19355
New Member
- Joined
- Feb 15, 2018
- Messages
- 1
Hello Excel users!
In short, I'm trying to create a bell curve to show low-end and high-end housing prices that I can afford based on a budget and the curve can adjust according to income.
Before I go into detail, may I say that I'm brand new to this site and this is my first question to post. If you choose to lend a hand, I'd appreciate as much detail as possible--especially since I've never done this kind of graphing before (I don't know about statistics, standard deviations, etc.). I've read forum boards for years on a variety of topics and unfortunately, they don't always provide the detail that I wish they would....
Anyway, let's say that I know I can afford a $300,000 home and that $300,000 is located in cell C12. I'd like the bell curve to reference cell C12 and put that figure in the middle (or at the top of the bell) with a vertical line straight down to the x axis and then increments of $25,000 to the left of the bell down to $200,000 and to the right of the bell up to $400,000. I'd like to have a heavy solid black line to represent the center vertical line and dark gray dotted lines to represent the increments to the left and right. I'd also like to be able to shade in those increments from the left to the right in increasing color density from a very light red at the $200,000 - $225,000 increment to a dark maroon at the $375,000 - $400,000 increment. I don't need a y axis as the only thing I need to show is the increments from $200,000 to $400,000. Oh, the $200,000 is located in cell C11 and the $400,000 is in cell C13.
So I hope that I was clear enough. Can anyone lend a hand?
Thanks so much!
In short, I'm trying to create a bell curve to show low-end and high-end housing prices that I can afford based on a budget and the curve can adjust according to income.
Before I go into detail, may I say that I'm brand new to this site and this is my first question to post. If you choose to lend a hand, I'd appreciate as much detail as possible--especially since I've never done this kind of graphing before (I don't know about statistics, standard deviations, etc.). I've read forum boards for years on a variety of topics and unfortunately, they don't always provide the detail that I wish they would....
Anyway, let's say that I know I can afford a $300,000 home and that $300,000 is located in cell C12. I'd like the bell curve to reference cell C12 and put that figure in the middle (or at the top of the bell) with a vertical line straight down to the x axis and then increments of $25,000 to the left of the bell down to $200,000 and to the right of the bell up to $400,000. I'd like to have a heavy solid black line to represent the center vertical line and dark gray dotted lines to represent the increments to the left and right. I'd also like to be able to shade in those increments from the left to the right in increasing color density from a very light red at the $200,000 - $225,000 increment to a dark maroon at the $375,000 - $400,000 increment. I don't need a y axis as the only thing I need to show is the increments from $200,000 to $400,000. Oh, the $200,000 is located in cell C11 and the $400,000 is in cell C13.
So I hope that I was clear enough. Can anyone lend a hand?
Thanks so much!