Advanced Chart Formatting

Series Data and Plot Area Fill

Under the Advanced options, you can change the display of the information along your axes between Horizontal and Vertical on Series Data. If you are using a column chart, you will also have the option to set column width and overlap under the Advanced options.

Also under Advanced options is the Plot Area Fill checkbox, which will fill the chart background with a solid color or gradients of colors.

image alt text

Axis Tab Features

On the Axis tab, select the axis you want to modify from the Current drop-down box. Each axis available on the chart is displayed based on its location (Bottom, Left, or Right). The formatting options will differ based on the axis you select.

image alt text

If you change the title of the axis, it is immediately reflected on the chart itself. You can also change the color of the axis title by clicking in the color box to the right of the title box and choosing which color you want.

By default, the Show Title slider is set to Shown, but if you don't want a title on the axis, move the slider. Similarly, you can choose whether the gridlines on the chart are displayed by checking and unchecking the Show Gridlines box. You can also choose to display or hide the lines along the axis of a chart via the Show Line option.

By checking the Label Frequency checkbox, you can choose how often to display data points. You can change the frequency by either using the arrow buttons to scroll up and down to change the values or by highlighting and typing a value in the box.

The Label Angle box changes the angle of the axis label. By default, it is set to zero, and is displayed horizontally. You can increase the angle up to 90 degrees, which will display the labels vertically.

If you choose Left instead of Bottom in the Axis drop-down box, you will see some additional options relevant to that axis. The first difference is the Range section. You can use this to set an explicit range for your chart, if the data included has unnecessary portions. You can also check the Always Show Zero box, and the data on the Left axis will begin with zero.

image alt text

Another section available under the Left axis menu is Step Size. Similar to the Range section, you can choose how many steps are between your data points by either scrolling up and down in the Step Size value box or by highlighting the text and typing in a value.

In the Prefix box, you can type in a symbol that will appear before all the values along the Left axis. A common example would be a dollar sign.

The last option on the Left axis menu is the Precision section. This controls how many decimal places are displayed for the values along the Left axis. By default, the Auto Precision box is checked, and the Charts feature will make its best approximation for the chart. You can uncheck this and change the value as needed.

The Show Line, Show Ticks, Show Gridlines, Zero Line, and Show Values options allow you to control and fine-tune the display of information related to a particular axis in your chart.

Series Tab Features

The Series tab contains options that allow you to format how each data series is displayed on your chart. You can select which series of data to work with from the Title drop-down. Depending on the chart type, different options for formatting your data will appear below the Title selection. These options may include the width and style of lines in a line chart, the color of slices in a pie chart, the colors for positive and negative change in a waterfall chart, and more.