Forum Discussion
How to make shading on Excel chart and move x axis labels to the bottom and rotate 45 degrees
Sorry, I should have written -80 and 20, as it is in the workbook.
To add a new series, click anywhere on the chart, then click Select Data on the Chart Design tab of the ribbon.
Under Legend Entries (Series), click Add.
In the axis options for the vertical axis, specify that the horizontal axis crosses at -80:
Also specify -80 as minimum value.
In the text options for the horizontal axis, specify a custom angle of -45 degress (or whichever value you prefer):
For the yellow shading, add a series with constant value -80, and a series with constant value -20.
In the Change Chart Type dialog, change the chart type for the new series to Stacked Area.
Change the color from whatever Excel decides to yellow.
Finally, remove the new series form the legend.
See the attached version.
- Ok, I got the axis formatting done. But for the shading I'm confused. You say to add series of -80 and -20 but on your workbook it is -80 and 20 (positive 20, not negative). Also, I don't understand how to ADD the new series to the existing chart vs using Insert Chart.
Sorry, I should have written -80 and 20, as it is in the workbook.
To add a new series, click anywhere on the chart, then click Select Data on the Chart Design tab of the ribbon.
Under Legend Entries (Series), click Add.
