Change data series options

This topic lists the additional options you can use to modify the data series in your charts.

Important: The options that appear or are available to you in the Options tab will depend on the chart you are using.

Most charts have an option called Vary colors by point—select this checkbox to vary the colors of data markers in a single-series chart.

Column chart

Overlap    To change the overlap of the data markers in each category, enter a value between -100 and 100 in the box. The higher the value, the greater the overlap within the category.

Gap width    To change the spacing between categories of data markers, enter a value between 0 (zero) and 500. The higher the value, the greater the distance between each category.

Series lines    These lines connect the data series in 2-D stacked bar and column charts to emphasize the difference in measurement between each data series. Pie of pie and bar of pie charts display series lines by default to connect the main pie chart with the secondary pie or bar chart. Select this checkbox if you want to show series lines in your chart.

Bar/Cylinder/Pyramid/Cone charts

You can change the chart depth in 3-D charts that have axes, the gap depth in 3-D perspective charts, and the gap width in 3-D bar or column charts.

Line/Stock chart

Gap width    To change the spacing between categories of data markers, enter a value between 0 (zero) and 500. The higher the value, the greater the distance between each category.

High-low lines    Available in 2-D line/stock charts and displayed by default in stock charts, high-low lines extend from the highest value to the lowest value in each category. Select this checkbox if you want to add high-low lines to your chart.

Up/down bars    Useful in line/stock charts with multiple data series, up-down bars indicate the difference between data points in the first data series and the last data series. By default, these bars are also added to stock charts, such as Open-High-Low-Close and Volume-Open-High-Low-Close. Select this checkbox if you want to add up/down bars to your chart.

Drop lines    Available in 2-D and 3-D area, stock, and line charts, these lines extend from data points to the horizontal (category) axis to help clarify where one data marker ends and the next data marker starts. Select this checkbox if you want to add drop lines to your area chart.

Pie/Doughnut chart

Angle of first slice    You can rotate a pie chart or a doughnut chart for clarity or emphasis of labels. Type a value between 0 (zero) and 360 to specify the angle at which you want the first slice to appear.

Doughnut hole size    This option is available to doughnut charts only. Type a value between 10 and 90 to specify the diameter of the hole.

Vary colors by slice    Clear this checkbox to display all data points of a data series in the same color on a pie chart or donut chart.

Area chart

Drop lines    Available in 2-D and 3-D area and line charts, these lines extend from data points to the horizontal (category) axis to help clarify where one data marker ends and the next data marker starts. Select this checkbox if you want to add drop lines to your area chart.

Radar chart

Category labels    Clear this checkbox if you don't want category labels to appear in the chart.

Bubble chart

You can set the size of the bubble chart by area or width.

Scale bubble size to    Enter a percentage value to scale the bubble sizes in your chart.

Show negative bubbles    Select this option if you want to display negative bubbles in your bubble chart.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×