Series options

Use these options to change the display of data series or data points in your chart.

Important: Depending on the type of your chart, different series options will be available.

Category labels     Selected by default, this option displays category labels for the data series. Clear this check box if you want to hide category labels. This option is only available on radar charts.

Split Series By     Controls which slices are displayed in the secondary chart of a pie of pie or bar of pie chart. You can spit the series by position, value, percentage of a value, or a custom plot. This option is only available for pie of pie or bar of pie charts.

Second plot contains     Controls the number of values that are displayed in the secondary chart of a pie of pie or bar of pie chart. This option is only available for pie of pie or bar of pie charts.

  • For position, this option changes to Second plot contains the last, and you can specify the number of slices in the Values box.

  • For values, this option changes to Second plot contains all values less than, and you can specify the value that you want.

  • For percentage value, this option changes to Second plot contain all values less than, and you can specify the percentage that you want.

  • For a custom plot, you can select the data points that you want to display in the secondary chart.

    Point belongs to     Controls the plot area of a selected data point in a pie of pie or bar of pie chart. You can specify where you want to move the selected data point by clicking First Plot or Second Plot in the list box. This option is only available for pie of pie or bar of pie charts.

Angle of first slice

No Rotation to Full Rotation     Rotates the selected data series. Move the sliding handle to the rotation degree that you want, or type a number between 0 and 360 degrees. The default setting is 0 degrees. This option is only available for pie or doughnut charts.

Pie Explosion     Controls the spacing between the selected data points of the data series and the center of the pie chart. Move the sliding handle to the percentage of explosion that you want, or type a percentage between 0 and 400 in the text box. The default setting is 0%. This option is only available for pie charts. The name of this option changes to Point Explosion when a single pie slice is selected.

Doughnut Explosion     Controls the spacing between the selected data series or data points and the center of the doughnut chart. Move the sliding handle to the percentage of explosion that you want, or type a percentage between 0 and 400 in the text box. The default setting is 0%. This option is only available for doughnut charts. The name of this option changes to Point Explosion when a single doughnut slice is selected.

Doughnut Hole Size     Controls the size of the doughnut hole. Move the sliding handle to the percentage of doughnut hole size that you want, or type a percentage between 10 and 90 in the text box. The default setting is 50%. This option is only available for doughnut charts.

Second Plot Size     Controls the size of the secondary chart. Move the sliding handle to the percentage that you want, or type a percentage between 5 and 200 in the text box. The default setting is 5%. This option is only available for pie of pie or bar of pie charts.

Series Overlap

Separated to Overlapped    Controls the spacing between individual data points of the data series that are displayed for each category. Move the sliding handle to the percentage of separation or overlap that you want, or type a percentage of separation or overlap in the Percentage box. Use a negative percentage to separate data points or a positive percentage to overlap them. The default setting is 0%.

Gap Depth

No Gap to Large Gap    Determines the spacing between the clusters of data points that are displayed for each category. Move the sliding handle to the percentage of gap width that you want, or type a percentage between 0 and 500 in the Gap Width box. The default setting is 150%. This option is only available for 3-D charts.

Gap Width

No Gap to Large Gap    Determines the spacing between the clusters of data points that are displayed for each category. Move the sliding handle to the percentage of gap width that you want, or type a percentage between 0 and 500 in the Gap Width box. The default setting is 150%.

Plot Series On

Primary Axis     Selected by default, this option displays selected data series on the primary vertical (value) axis.

Secondary Axis     Displays selected data series on the secondary vertical (value) axis, adding this axis to the chart when you plot the first data series on the secondary axis. You can plot one or more data series on the secondary axis.

Note: If all of the data series have been moved to a secondary axis, leaving no data series on the primary axis, the secondary axis is converted to a primary axis.

Size represents

Area of bubbles     Selected by default, the entire area of each bubble represents the data that is used to determine the size of the bubble. For example, this option is useful if the data represents a measurement, such as square footage. This option is only available for a bubble chart.

Width of bubbles     The width or diameter of each bubble represents the data that is used to determine the size of the bubble, which is useful for comparison purposes. This option is only available for a bubble chart.

Scale bubble size to     Scales the bubble size for a data series by a percentage between 0 and 300 that you type in the text box —the larger the percentage, the larger the bubbles. This option is only available for a bubble chart.

Show negative bubbles     By default, when an entire data series contains negative bubble sizes, the series is not displayed. If you want to display the negative bubbles in the chart, select the Show Negative Bubbles check box. This option is only available for a bubble chart.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×