Axis and Series Display for Charts

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.

image alt text

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.

image alt 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.

image alt text

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.

image alt text

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.

image alt text

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.

image alt text

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.

image alt text

For pie and doughnut charts, there are a number of settings to give you control over the display:

  • Color for each slice
  • Explode for all or selected slices
  • Show Label (includes options for Name, Value and Percent)
  • Border size and color
  • Value (includes Precision, Separator and Distance)

    image alt text