Coloring the area of a beach under a curve
Solved
Lilas
-
Lilas -
Lilas -
Hello,
I have a graph with a curve, and there are two areas under this curve that I want to color.
For that, I created two formulas to obtain the areas corresponding to the regions to be colored.
So far so good, except that my areas are "deformed"; I would like the line of the area extending from the axis to the curve to be perpendicular to the axis, but it is slanted.
Do you know how to fix this problem?
I have a graph with a curve, and there are two areas under this curve that I want to color.
For that, I created two formulas to obtain the areas corresponding to the regions to be colored.
So far so good, except that my areas are "deformed"; I would like the line of the area extending from the axis to the curve to be perpendicular to the axis, but it is slanted.
Do you know how to fix this problem?
2 answers
Hello,
To color the area under a curve, you add a series like "Area".
But you need to:
-- double the X values
-- Choose a "Chronological" X axis (in Excel 2003 it's in the chart options; in Excel 2007 and later you need to find an option that allows you to choose X labels in the form of dates???)
-- Assign the value =NA() to certain points so that the curve goes "straight" without passing through intermediate 0s.
For the labels, you can adopt a custom format: dd
https://www.cjoint.com/?3GrtAUMq3VB
To color the area under a curve, you add a series like "Area".
But you need to:
-- double the X values
-- Choose a "Chronological" X axis (in Excel 2003 it's in the chart options; in Excel 2007 and later you need to find an option that allows you to choose X labels in the form of dates???)
-- Assign the value =NA() to certain points so that the curve goes "straight" without passing through intermediate 0s.
For the labels, you can adopt a custom format: dd
https://www.cjoint.com/?3GrtAUMq3VB