Rotate axis labels in chart of Excel 2013

Close the dialog, then you can see the axis labels are rotated. In the Format Axis dialog, click Alignment tab and go to the Text Layout section to select the direction you need from the list box of Text direction. Right click at the axis you want to rotate its labels, select Format Axis from the context menu. If you do not want to resize the chart size to meet the labels, you can rotate the axis labels to show the labels clearly in Excel.ġ. Sometimes, the axis labels in chart are so long that the labels are huddled together as shown as below screenshot. Stagger - Use this mode to distribute data labels on multiple levels (default is 2), to increase the inter-label space available on each level.How to rotate axis labels in chart in Excel?.Rotate & Slant - If the visibility of label texts is not clear even after rotating the labels, you can slant them.Pure Rotation - In case you are using long data labels, you can rotate them to prevent label texts from getting truncated, with ellipses at the end.FusionCharts supports tags within the label text, to put breakpoints at specific positions. Auto mode - The default âautoâ mode automatically adjusts a particular data label and prevents overlapping of the labels.In this example, the x-axis labels are the name of the countries for which the oil reserves are shown.įusionCharts supports smart label management, which ensures that labels avoid overlapping and are displayed clearly, no matter how long or short they are.

Labels are displayed along the x-axis of the chart. They showcase the relationship between the axes and the data plots. To know more about this feature, click here. This can come in handy for improving aesthetics of a chart. Using FusionCharts, you can choose to display the chart caption on the left or the right hand side of the chart canvas. The subcaption of the chart states the unit in which the measurements of oil reserves is shown.įusionCharts provides plenty of options to set captions and subcaptions, with smart space management. For example - âCountries With Most Oil Reserves â clearly depicts the data that is shown on the chart. Text can be in the form of chart captions, subcaptions, axis titles, data values, and data labels.įor quick reference on all the customizations, refer to the following list:Ī well-written caption makes a chart much easier to comprehend. Any form of text appearing on the chart canvas area adds more details to the data visualization.

Excel 2016 chart axis labels angle