If you havent yet created the document open excel and click blank workbook then create your graph before continuing.ĭouble click an excel document that contains a graph. Right click the category labels you want to change and click select data. Axis labels make excel charts easier to understand. Click primary horizontal axis title or primary vertical axis title. If you are using excel 20102007 you can insert the axis label into the chart with following steps. Your chart uses text in the source data for these axis labels. And on those charts where axes are used the only chart elements that are present by default include. Navigate to chart tools layout tab and then click axis titles see screenshot. Make sure youre working in excel for the web edit mode. To keep the text in the source data on the worksheet the way it is and just create custom labels you can enter new label text thats independent of the worksheet data.
To change the text of the category labels on the horizontal axis. Microsoft excel a powerful spreadsheet software allows you to store data make calculations on it and create stunning graphs and charts out of your data.Įxcel Charts Conditionally Highlight Axis Labels On Excel Chart Click anywhere in the chart to show the chart tools on the ribbon. If youre in view mode click edit workbook edit in excel for the web.
