If you specify the TRENDVAR= option, you can provide distinct labels for the vertical axes of the and trend charts by breaking the vertical axis into two parts with a split character. Specify the ...

How to Chart 24 Hours on a Vertical Axis in Excel. ... Axis Labels" box. Select the cells in column A and click "OK." Click "OK" to close the dialog box. The chart now correctly tracks your data.

Instead, you need to add the chart labels after you create the chart. Adding the x-axis and y-axis labels can be done in the usual way. However, Excel has no specific tools for adding individual ...