Hi folks, need a quick bit of assistance. My girlfriend needs a couple of visual graph shapes to display a point, specifically a vitamin intake model of stress and contributing factors. She needs one line graph that displays an inverse bell curve shape and one that shows a decreasing linear relationship to a point and then plateaus off to a constant value. Anyone know how I can get these graphs to represent in Excel or how else I can do them?
Excel help - need a couple of nothing formulas to generate appropriate graph shapes
- Thread starter Deadbeat
- Start date
Soldato
- Joined
- 31 May 2009
- Posts
- 21,468
Can you not just import a couple of clipart graph images that are appropraite, or do you want them to represent specific values?
Soldato
- Joined
- 15 Feb 2011
- Posts
- 10,234
- Location
- Slough
do you need the data as a graph in excel, or do you just need a graph of some sort?
the inverse bell curve could be done with the negative of the normal distribution function, adding a constant if needed.
the only way i can think of getting a linear decrease followed by a straight line is to have two separate functions with ranges (eg: x + y = 5 for x <= 4, y = 1 for x > 4)
the inverse bell curve could be done with the negative of the normal distribution function, adding a constant if needed.
the only way i can think of getting a linear decrease followed by a straight line is to have two separate functions with ranges (eg: x + y = 5 for x <= 4, y = 1 for x > 4)