Option
Description
Examples
Allows you to sort the items in each individual category in most kinds of multi-series Bar and Lollipop charts. You can choose an ascending or descending sort. If you select Default , the default sort is applied. This option does not work when the Value Scale > Log Scale box is checked.
In the example at right, bars within all categories are sorted in descending order.
Allows you to sort categories in many kinds of Bar and Lollipop charts by their total values, in either ascending or descending order. If you select Default , the default sort is applied. This option does not work when the chart has automatic time scaling applied. (You can turn off automatic time scaling by checking the box for Category Scale > Never Use Time Scale .
In the example at right, the categories are sorted by their totals in ascending order.
Maximum Bars
Allows you to specify the number of bars that appear in your Bar chart. Data for all remaining bars is lumped into a single "Other" bar (unless you hide this bar using the Hide 'Other' Bar toggle.
The example at right shows a Bar chart in which the maximum number of bars has been set to 7.
Hide 'Other' Bars
Hides or shows the "Other" bar that appears when you set a maximum number of bars using the Maximum Bars option.
—
Series on Left Scale
Refers to the number of lines and bars in Grouped Bar with Line, Stacked Bar with Line, and Grouped and Stacked Bar with Line graphs. By default, the first series that appears in your legend for these chart types becomes a line, and all remaining series become bars. However, you can convert series from bars to lines by entering the desired number of lines in Chart Properties . For example, if your chart had three series, the first series appearing in your legend would appear as a line, and the remaining two series would appear as bars. You could turn the second series into a line by entering 2 in the Series on Left Scale field. For more information about Grouped Bar with Line, Stacked Bar with Line, and Grouped and Stacked Bar with Line graphs, see Grouped and Stacked Bar with Line Chart , respectively.
—
Line Style
Lets you change the line style in Grouped Bar with Line, Stacked Bar with Line, and Grouped and Stacked Bar with Line graphs. By default, lines in these chart types appear angular. If you want, you can change the line style to be curved. The example shows a Stacked Bar with Line chart in which the Curved line style has been set.
Number of Symbol Series
Refers to the number of series in Grouped Bar with Symbol and Stacked Bar with Symbol graphs in which symbols appear in place of lines. By default, the first series that appears in your legend is made up of symbols, and all remaining series become bars. However, you can convert series from bars to symbols by entering the desired number of symbols series in Chart Properties . For example, if your chart had three series, the first series appearing in your legend would appear as symbols, and the remaining two series would appear as bars. You could turn the second series into symbols by entering 2 in the Number of Symbol Series field. For more information about Grouped Bar with Line and Stacked Bar with Line graphs, see Stacked Bar with Line Graph , respectively.
—
Sync Value Scales
Determines whether value scales in dual-scale graphs (such as Grouped Bar with Line and Stacked Bar with Line graphs) are synced. For more information, see Syncing Value Scales in a Dual-Scale Chart . The example shows a chart with synced value scales.
Hide Second Scale
Hides the second value scale in dual-scale graphs (such as Grouped Bar with Line and Stacked Bar with Line graphs) in which you have synced the scales using the Sync Value Scales option. For more information, see Syncing Value Scales in a Dual-Scale Chart .
—
Sync Zero Lines
Syncs the zero lines in dual-scale graphs with negative values so the "0" values match.
The first example at right shows a dual-scale graph with scales that do not match. The right-side graph is being used to measure sales, which are always going to be positive; hence the scale starts at 0. However, the left-side scale is being used to measure profit, which may dip below 0. In this case, the scale starts at -2000. Because the scales do not match, the graph is difficult to interpret.
The second example shows the same graph with the zero lines synced. Even though the other values do not match, the viewer can easily use the zero line as a reference point to interpret the line and bars simultaneously.
Number of Running Total Lines
Lets you specify the number of lines in line-bar combination charts that are running total lines. Lines that become running total lines are determined by your chart series order as it appears in your legend. For example, if you indicated that you wanted two running total lines, the lines corresponding to the first two line series in your legend would become running total lines.
In the example, the blue and light green lines are running total lines; the dark green line is not.
Number of Running Total Bars
Lets you specify the number of bars in line-bar combination charts that are running total bars. Bars that become running total bars are determined by your chart series order as it appears in your legend. For example, if you indicated that you wanted two running total bars, the bars corresponding to the first two bar series in your legend would become running total bars.
In the example, the light and dark green bars are running total bars; the other bars are not.
Number of Running Total Series
Lets you choose the number of aggregated series in most Running Total charts. Series that remain aggregated are determined by your chart series order as it appears in your legend. For example, if you had a Running Total Grouped Bar chart and you indicated that you wanted two running total series, the bars corresponding to the first two bar series in your legend would remain aggregated, and all other bars would show their literal values.
In the example, only one series has been selected as a running total series. This is the blue series at the bottom of each stack. All other series are shown with their literal values.
Hide Group in Legend
Hides the legend text for the "group bars" in Nested Bar graphs (the vertical or horizontal gray bars that show the total for each category).
—
Group Legend Text
Lets you specify the legend text for the "group bars" in Nested Bar graphs (the vertical or horizontal gray bars that show the totals for each category). In the example, the default group bar legend text has been replaced with the words "Group Total."
