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.
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, Series 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 charts, column, area and waterfall charts, area 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.
For pie and doughnut charts, there are a number of settings to give you control over the display: