Edit Data Settings in Data Charts

Under the button Data in the action bar, you can make further changes to your data chart (Figure 1, “Button Data”).

The available options depend on the chart type in use. For example, you can edit your series preferences as well as the series and category order for most charts, but not for bubble or scatter charts.

For waterfall charts, you can also set the waterfall direction.

In addition, you have the option to create, edit and break Excel links.

Under Series, you can decide if you want to use the columns or rows in Excel as series. The other option will then be used as categories (Figure 2, “Options for Series”).

Under Series Order in PPT, you can decide if the series are sorted according to their order in Excel or if this order should be reversed (Figure 3, “Options for Series Order”).

Under Categories Order in PPT, you can decide if the categories are sorted according to their order in Excel or if this order should be reversed (Figure 4, “Options for Category Order”).

For circle charts, you can decide if the categories are sorted clockwise or counter clockwise (Figure 5, “Options for Category Order in Circle Charts”).

For waterfall charts, under Waterfall Direction, you can decide if the waterfall direction should go from left to right or from right to left (Figure 6, “Options for Waterfall Direction (Waterfall Chart)”).

For waterfall bar charts, under Waterfall Direction, you can decide if the waterfall direction should go from bottom to top or from top to bottom (Figure 7, “Options for Waterfall Direction (Waterfall Bar Chart)”).