Examples of chart types in PivotChart view

ShowArea

An area chart emphasizes the magnitude of change over time. By displaying the sum of the plotted values, an area chart also shows the relationship of parts to a whole.

Area chart

In this example, an area chart emphasizes increased sales in Washington and illustrates the contribution of each state to total sales.

ShowColumn

A column chart shows data changes over a period of time or illustrates comparisons among items. To emphasize variation over time, categories are organized horizontally and values are organized vertically.

Column chart

Stacked column charts show the relationship of individual items to the whole.

Stacked column chart

ShowBar

A bar chart illustrates comparisons between individual items. To focus on comparing values and to place less emphasis on time, categories are organized vertically and values are organized horizontally.

Bar chart

Stacked bar charts show the relationship of individual items to the whole.

Stacked bar chart

ShowLine

A line chart shows trends in data at equal intervals.

Line chart

ShowSmoothLine

A smooth line chart shows trends in data at equal intervals, smoothed to show the estimated data between intervals.

Smooth line chart

ShowPie

A pie chart shows the proportional size of items that make up a data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern. You can plot one or more data series in a chart.) to the sum of the items. It always shows only one data series and is useful when you want to emphasize a significant element.

Pie chart

You can also create a stacked pie chart, which is a pie chart with more than one series.

Stacked pie chart

ShowDoughnut

Like a pie chart, a doughnut chart shows the relationship of parts to a whole, but a doughnut chart consists of rings and can contain more than one data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern. You can plot one or more data series in a chart.). Each ring of the doughnut chart represents a data series.

Doughnut chart

ShowStock

Two stock chart types are often used to illustrate stock prices: open-high-low-close and high-low-close. These charts can also be used for scientific data — for example, to indicate high-low-average temperatures. The chart in the example is a high-low-close chart.

Data to be charted and stock chart

ShowXY (Scatter)

An xy (scatter) chart either shows the relationships among the numeric values in several data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern. You can plot one or more data series in a chart.) or plots two groups of numbers as one series of xy coordinates. This chart shows uneven intervals — or clusters — of data and is commonly used for scientific data.

When you arrange your data, place the x values in one row or column with corresponding y values in the adjacent row or column in an x-y x-y arrangement.

xy (scatter) chart

ShowBubble

A bubble chart is a type of xy (scatter) chart. The size of the data marker (data marker: A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value. Related data markers in a chart constitute a data series.) indicates the value of a third variable.

To arrange your data, place the x values in one row or column and then enter the corresponding y values and bubble sizes in the adjacent rows or columns.

Data to be charted

Bubble chart

ShowRadar

In a radar chart, each category has its own value axis that radiates from the center point. Lines connect all the values in the same data series (data series: Related data points that are plotted in a chart and originate from datasheet rows or columns. Each data series in a chart has a unique color or pattern. You can plot one or more data series in a chart. Pie charts have only one data series.).

Radar chart

A radar chart compares the aggregate values of several data series. In this chart, the data series that covers the most area, Brand A, represents the brand with the highest vitamin content.

ShowPolar

Polar chart

A polar chart compares the relationship of angles and distances. The chart in this example illustrates elevation angles for two heights of a radio antenna.

 
 
Applies to:
Access 2003