Plots data from a related Pivot Table. Available in all chart formats.
Includes Filters which can be changed either in the Pivot Chart or related Pivot Table.
Changes to either a Pivot Table or Pivot Chart will automatically be reflected in the other.
Data Format
- x-axis: Categories (e.g. countries)
- Categories are plotted on either the horizontal (e.g. column) or vertical (e.g. bar) axis, dependent on the chart type selected.
- Categories can be filtered both within the Pivot Table and Pivot Chart.
- y-axis: Series (e.g. total population)
- Data for a Pivot Chart is drawn directly from a related Pivot Table.
- Series are distributed along the horizontal or vertical axis, dependent on the chart type selected.
- Chart options such as handling positive and negative values are dependent on the chart type selected.
- Filters and sort options are available in both the Pivot Table and Pivot Chart.
Try it now!
- Select a region using the filters on either the Pivot Table or Pivot Chart to view population data.
- Note how the table, chart and title adjust to reflect the different population values of each country/region.
- A Top 10 Value filter is currently applied to countries, based on their percentage of regional population.