A chart is a graphic that display screens numeric information in a compact, visual layout and also that reveals crucial information relationships. You can add a chart to a form/report to visualize your information and also make increated decisions. You have the right to bind the chart to a table or query and customize the chart via a selection of properties. You deserve to also make the chart interenergetic. For example, if you pick a different category field on a type or report filter, you check out various chart values. In Access, you have the right to create column, line, bar, pie, and combo charts.

You are watching: A chart that compares three set of values in a three-dimensional chart is _____.

Note Having a trouble displaying your chart? For even more indevelopment, check out Chart disshows up once you add a Legend (Series) in the Chart Settings pane.

Combo chart: a clustered column chart of ybeforehand residence sales and also line chart of monthly average price


What carry out you want to do? Create a chart — Beginning steps— File settings— Format settings— Important considerationsLink a chart to the information on a type or report

Choose the finest chart kind for your requirements — Pillar (with step-by-step video)— Line (with step-by-step video)— Bar (through step-by-step video)— Pie (via step-by-step video)— Combo (through step-by-action video)Best Practices for creating Access charts

Create a chart

The vital actions to creating a chart in Access are:

Binding the chart to a documents source (such as a table or query).

Mapping the fields to the chart dimensions, which are the main elements of a chart. The Axis (Category), Legend (Series), and also Values (Y Axis) dimensions are lassist out in different methods depending on the kind of chart.

Adding added chart facets (such as data labels and also trendlines) to boost and clarify the chart.

Formatting the chart and also its assorted aspects. You can likewise format individual data collection, which are a collection of values in a column, bar, line, or pie slice that correspond to the chart legend.

Top of Page

Beginning steps

Create or open a type or report in Design watch. To develop, select Create > Form Design or Report Design. To open, right click the form or report name in the navigation bar, and then select Form Design or Report Design.

Top of Page

Documents settings

Select the Data tab of the Chart Settings pane.

In the Axis (Category), Legfinish (Series), and Values (Y Axis) sections, pick at leastern two areas to produce a chart. Do the following:

Axis (Category) Under this area, pick one or more areas.

This chart dimension mirrors horizontal worths in an XY chart layout in a clustered column and line chart, and vertical worths in a clustered bar chart.

Clustered column chart axis

Line chart axis

Clustered bar chart axis

The default aggregation of a day area is Months. To change it, click the down arrowhead and select from the list, including None to rerelocate the aggregation.

When you select more than one Axis (Category) field, it creates a hierarchy of tick marks alengthy the measurement line (such as States within a Division).

Legend (Series) Under this section, select a field.

This chart dimension pivots area values right into column headings. For example, worths in a State field are transposed as column headings and also each becomes a sepaprice data series.

Values (Y axis) Under this area, pick one or more fields.

This chart dimension shows vertical values in an XY chart layout in a clustered column and line chart, and horizontal worths in a clustered bar chart.

Clustered column chart values

Line chart values

Clustered bar chart values

Each field you select coincides to a documents series. When you select 2 or even more Values (Y axis) fields, you can’t select a Legend (Series) area. The Values (Y axis) fields end up being the legfinish by default.

By default, each schosen field is aggregated. For numeric and also money fields, the default aggregation is Sum. For all various other areas, the default aggregation is Count. To readjust the aggregation, click the down-arrowhead, and choose from the list, including None to rerelocate the aggregation.

Note Text areas have to use the Count aggregation. All schosen Values (Y axis) fields should either be aggregated or nonaggregated.

Notes Different area combicountries are possible, however take into consideration the following:

At a minimum, select at least one Axis (Category) and one Values (Y axis) area.

You have the right to only choose one Legend (Series) field, but you have the right to pick even more than one area from the Values (Y axis) or Axis (Category) sections.

If you choose one Axis (Category) area and one Legfinish (Series) area, you deserve to just choose one Values (Y axis) area. To add an additional Values (Y axis) area, clear either the Axis (Category) or Legend (Series) field.

If you select a Legend (Series) area, select only one Values (Y axis) field and also it should be aggregated.

Top of Page

Format settings

Select the Format tab of the Chart Settings pane.

Select a File Series from the drop down list.

Each data collection has a unique collection of properties

For each data series, set one or more of the complying with properties:

Display Name The name of the File Series in the chart legend.

Chart Type This residential or commercial property just displays for a Combo chart. Use this residential or commercial property to add various chart kinds to the Combo Chart, one for each data series. The default Combo Chart combination is Clustered Obelisk for the first data series and also Line for the second data series. You can set a different chart type for each data collection. If the chart has actually just a single data series, it is Clustered Obelisk.

Note Avoid confutilizing this residential property via the Chart Type property in the chart home sheet.

Line Weight Select a line weight in increments of .25 points. This residential property only screens for a Line chart.

Dash Type Select a line type of Solid, Dash, Dot, Dash Dot, or Dash Dot Dot. This residential or commercial property just displays for a Line chart.

Plot Series On Select a primary or additional axis to plot a data series. Use this choice as soon as chart data collection vary extensively or are different procedures (such as price and also volume). A Combo chart of clustered column and line that also has actually axis titles often works finest.

Missing File Policy Select one of the following: Plot As Zero to reexisting lacking information as 0, Do Not Plot to disregard absent information, and Plot as Interpolated to calculate new data that fills in missing information. This property only display screens for a Line chart.

Series Fill Color Select a color to fill the data collection, such as a column or bar.

Series Border Color Select a color to add an outline to the data collection, such as a column or bar.

Display Data Label Select this option to screen a documents label that clarifies the data series.

Display Trendlines Select this alternative to screen a trendline, which is a way to show information tendencies.

Trendline Options Select among the complying with trendlines:

Linear This is a best-fit, right line for data sets that rise or decrease at a steady price.

Exponential This is a curved line of positive numbers climbing or falling at constantly enhancing prices.

Logarithmic This is a best-fit, curved line of rate-of-readjust data that quickly rises or decreases, and also then levels out.

Polynomial This is ideal supplied as soon as your information fluctuates, such as gains and losses over a big data collection.

Power This is a curved line of positive numbers that increase at a certain price, such as acceleration at 1-second intervals.

Moving Average This is a way to also out fluctuations in data and display a pattern or trfinish more plainly.

Trendline name Go into a name that is more coherent and that screens on the chart legfinish.

Marker Shape Select a form as a line marker. This residential or commercial property only displays for a Line chart.

Top of Page

Important considerations

Aggregation Although the data resource often begins as a set of nonaggregated data, as you create a chart, by default Access creates accumulation calculations, such as Sum, Count, and also Average, on fields to help simplify the variety of data collection. However before, you have the right to rerelocate the default aggregate calculations by selecting None in the drop-down list. This procedure of selecting areas and selecting aggregations creates a SELECT, SQL GROUP BY, or TRANSFORM statement that is stored in the Transcreated Row Source property. To check out the statement, right-click the residential property and choose Zoom. The adhering to is a review of the three primary possibilities:

If you select Axis (Category) and Values (Y Axis) areas yet rerelocate the aggregations, Access converts the row source to a simpler SELECT statement. For example:

SELECT , FROM If you select Axis (Category) and also Values (Y Axis) fields, Access converts the row resource to a GROUP BY statement. For example:

SELECT , Sum() AS GROUP BY ORDER BY If you also pick a Legfinish (Series) area, Access converts the row resource to a crosstab query (using the TRANSFORM SQL query statement). The area worths went back by the PIVOT clause of the TRANSFORM SQL query statement are provided as column headings, such as a State area, which can create many kind of headings -- each a sepaprice data collection. For example:

TRANSFORM Sum() AS SELECT FROM GROUP BY ORDER BY PIVOT For more information, about information aggregation, check out Make summary data much easier to read by using a crosstab query.

Properties To further customize the chart, pick Design > Property Sheet > , which displays all the chart-connected properties. Press F1 on each home to obtain help on that residential property. When you modify a building in the Property sheet, the corresponding worth transforms in the Chart Settings pane and vice versa.

There are many type of Format properties unique to charts. you deserve to usage these to format axes worths, titles, and also the chart. Tright here are likewise numerous Data properties distinct to charts, consisting of Pevaluation Live Data, Transdeveloped Row Source; Chart Axis, Chart Legend, and also Chart Value.

Adding a second vertical axis When you create a chart, tbelow is normally a primary vertical axis, however you deserve to include a secondary vertical axis when data varies widely or to plot different measures, such as price and volume. The range of the second vertical axis shows the worths for its connected data collection. To include a second vertical axis, usage the Plot Series On residential or commercial property on the Format tab of the Chart Settings pane.

Adding a trend line For numeric data, you may want to include a trfinish line to display information tendencies. You can usage the Trend Line and Trfinish Line Name choices on the Format tab of the Chart Settings pane.

Modify the chart To modify a chart, open up the develop or report in Design or Layout view, and also then pick the chart which opens up the Chart Settings pane. To switch to a various chart form, pick a different chart from the Chart Type residential or commercial property drop-dvery own list. You deserve to likewise readjust any type of single chart to a Combo chart by altering the Chart Type home on the residential property sheet (and also not the Format tab of the Chart Settings pane).

Refresh resource data To refresh chart data, switch to create or report see, pick the chart, and then choose Refresh All (or press F5).

Chart Settings If the Chart Settings pane is closed, make certain the chart is schosen, and also then select Design > Chart Settings.

Classic chart Avoid confusing the brand-new chart

, which is based upon modern-day innovation, with the classical chart
, which is an ActiveX Control. However before, you deserve to still usage the timeless chart and also also include it to a kind or report that has the new chart.

Top of Page

Link a chart to the information on a type or report

To make a chart communicate via the data on a form or report, bind the chart to the very same data resource as the create or report. Then set a matching field for the Link Child Fields and Link Master Fields data properties of the chart.

Make the Record Source property for the chart the exact same as the Record Source property for the form or report.

Click the chart, open up the chart Property Sheet by pushing F4, and then click the Data tab.

Click the Build switch

in either the Link Child Fields or Link Master Fields property box.

The Subcreate Field Linker dialog box shows up.

In the Link Master Fields and Link Child Fields , select the field that you desire to connect, and also then click OK. It’s frequently best to use a category area, such as a State, Segment, or Region.

If you are not sure which field to use, click Suggest for references.

Top of Page

Choose the ideal chart type for your needs

The complying with sections administer background information around charts and help you decide which chart to usage.

What is a chart?

A chart is a graphic that displays numeric data in a compact, visual layout and that reveals necessary information relationships. A chart has actually many facets. Some of these elements are shown by default, others can be included as required. You have the right to readjust the display of the chart elements by resizing them or by transforming the format. You can also remove chart facets that you perform not want to display screen. The following diagram mirrors the standard chart facets.

Top of Page

What charts have the right to you create?

In Access, you have the right to create column, line, bar, pie, and also combo charts. This section explains each chart and its best-use scenarios.

See more: How To See All The Tags On A Tumblr Post, How To See All Reblogged Tags On A Post


In a column chart, categories display alengthy the horizontal axis (Axis (Category) property) and also worths display along the vertical axis (Values (Y axis) property). Generally, you select one field for the Axis (Category) measurement and also one or even more areas for a Values (Y axis) dimension, each of which becomes a Data Series. If you pick more than one field for an Values (Y axis) measurement, take into consideration plotting along a separate Axis.