Forum Discussion
Solved
How to make shading on Excel chart and move x axis labels to the bottom and rotate 45 degrees
I am using Excel 365 (I have a Windows 365 Family subscription) on Windows 10 Home. I have made an Excel workbook which has Wi-Fi signal strength measurements in several parts of my house for two loc...
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.
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.