Axis Display for Charts
To access the settings and controls to modify the bottom and left axes, right-click on a chart and choose Chart Properties.
To create an axis title, double click on the text field next to Title in the Bottom Axis and Left Axis sections in Chart Properties. Add your title text and format using the text edit icons in the toolbar.
For more information about formatting bottom and left axis title, see Formatting Chart Text.
To show or hide the axis labels, use the Show Labels sliders for the bottom and left axes. Set angle of rotation by entering a number between 0 and 90. Zero sets the labels for standard horizontal display. Ninety sets the labels for vertical display.
To Show Ticks or hide tick marks, click the toggle under Bottom Axis and Left Axis. You can also show gridlines by clicking Show Grid for each axis. To show or hide each axis line, click the Show Line toggle.
To reverse the scale of measure on the left axis, use the Reverse Scale slider. This will allow you to display the largest values at the bottom and the smallest values at the top.
For the Bottom Axis, you also have the option to Expand to Edge. For the Left Axis, you can Show Zero Line and change the color for that line.
For the Left Axis there are a few additional options including setting the Min Value, the Max Value and the Step Size. This helps to control the display and clarify numbers that may be clustered.
Series Display for Charts
In Chart Properties, the Series section contains options that allow you to format the display of each data series in your chart. Choose whether to modify All Series or a specific series in the drop-down menu.
Different formatting options are available for data series based on the chart type. For column, bar, area and waterfall charts, these options include the following and more:
- Style and width of lines and markers in a line chart
- Bar Padding and Bar Group Padding for column charts
- Colors for positive and negative change in a waterfall chart.
You can also hide categories and series in charts by hiding rows and columns in the chart's data table. Any hidden row/column will not be plotted on the chart.
There may be times when you want to move a series from the left axis to the right axis or from the right axis to the left axis. For example, if you are showing two sets of data with widely varying scales.
Choose the series you’d like to work with in the Chart Properties panel. Then choose Left or Right from the Axis drop-down menu.
For pie and doughnut charts, there are a number of settings to give you control over the display: