excel for mac line graph color certain area

Excel Line Graph Color Certain Area Series That Fills
Excel Line Graph Color Certain Area How To Color The

For a better experience, please enable JavaScript in your browser before proceeding.

Excel Line Graph Color Certain Area How To Color The

I have figured out how to color the entire area under the curve: Excel 2016 (Windows) 32 bit.

Trouble is, the curve is a function of the length, so if you just cut off the formula at a certain X, it throws the whole curve off.

Excel Line Graph Color Certain Area Series That Fills

The first two columns of data are the X-Y coordinates of the curve to fill under, the values below the table are the minimum and maximum of the horizontal axis, and the third and fourth columns are the data for the area chart series that fills below the curve.

Note that the first and last X values for the area chart data are repeated, and the first and last Y values for the area chart are zero; these features ensure a vertical edge on the left and right.

Select the first two columns and create an XY chart (top left chart).

Copy the next two columns, select the chart, and use Paste Special to add the data as a new series, series in columns, first column has X data, first row has series names (top center chart).

Format the new series, and select Secondary Axis (top right chart).

Convert secondary horizontal axis to a date-scale (middle right chart).

Hide the secondary horizontal axis: format so it uses no line, has no axis tick labels and no axis tick marks (bottom left chart).

Here is the data and the three individual filled regions under the curve.

Not in addition to min and max below the data table, there is also the two X values where the different colored fill regions meet.

They are here for reference and are not used in any formulas, although they could be if you wanted to get clever.

There are three columns with area chart Y values for the three series we will have to add, and note that each range of nonzero values is surrounded by zeros.

Copy the next four columns, select the chart, and use Paste Special to add the data as new series, series in columns, first column has X data, first row has series names (top center chart).

Format the three new series, and select Secondary Axis (top right chart).

Right click each new series, choose Change Series Chart Type, and select Area Chart (middle left chart).

In cell A2 if the value A then allow both positive and negative integers.

I have attached sample data, i need someone to help me convert the left side to how the data looks on the right.

Excel For Mac Line Graph Color Certain Area