In that group, you will see a button with an a and b and an arrow all on an angle.On the Home tab of the Ribbon, find the Alignment group.Launch MS Excel 2007 if it isn't already open.You will be pleased to know that it is very easy to accomplish in Excel 2007. It also will allow you to display more information in less space. If so, I am sure that you will agree that it is very impressive. Give the chart a title and resize as required:Ī big thanks to Jim Fitch for sharing this clever idea.You have no doubt seen spreadsheets and charts that had diagonal or vertical text, I am sure. Step 8 – Resize Plot Area to allow room for date labels. Select the zero labels > Data Labels > More Options:Ĭheck the box ‘Value from cells’ (available in Excel 2013 onward), then select the range of dates: While you’re adding elements (4 in image below) also remove the gridlines and legend if required (6 & 7 in image below): Use the drop-down list on the Chart Format tab to select the ‘date label position’ series as it’s no longer visible in the chart.

Step 5 – Add Data Labels to the 'Date Label Position' Series. Step 4 – Hide the horizontal axis labels: Tip*: the dates are shown in their date serial number format, but you can simply enter the new date in your regional date format (d/m/y or m/d/y) and Excel will convert it to the date serial number for you after you press enter: Step 3 – Set the desired minimum and maximum dates (Scatter Charts Only) Step 2 - Hide the line for the ‘Date Label Position’ series: I’m going to insert a scatter chart so I can show you another trick most people don’t know*. Step 1 - Insert a regular line or scatter chart. Note: if your chart has negative values then set the ‘Date Label Position’ to a value lower than the minimum negative value so that the labels sit below the line in the chart. We want these labels to sit below the zero position in the chart and we do this by adding a series to the chart with a value of zero for each date, as you can see below: The trick here is to use labels for the horizontal date axis.

Steps to Label Specific Excel Chart Axis Dates xlsx file please ensure your browser doesn't change the file extension on download. Excel for Customer Service Professionalsĭownload the Excel Workbook and follow along.

How to angle text in excel graph