Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

MS Access

Posted Aug 5, 2003

MS Access for the Business Environment: Create a PivotChart View in Access - Page 7

By William Pearson

Formatting and Organizing the PivotChart View

Next we will examine ways we can organize the new PivotTable view to make it easy to use. We will format and organize our view, then we will change the chart type; finally, we will examine general formatting and organization of the view.

  1. Right-click the chart we have created, in any blank area.

A context menu appears, as shown in Illustration 21.

Illustration 21: The Context Menu

  1. Click the Chart Type option that appears in the context menu.

The PivotChart Properties dialog appears, defaulted to the Type tab, as shown in Illustration 22.

Illustration 22: The Chart Properties Dialog, Type Tab

We note that the current chart is set to exhibit the Clustered Column style, according to the description at the bottom of the Type tab. We also note that we have numerous other choices, not only within the Columnar types (the options appear in the form of pictures in the right pane of the Type tab), but among other chart types that are different entirely (listed in the left pane of the Type tab).

  1. Select the 3D Column Clustered type (the second option in the middle row of columnar types).

The 3D Column Clustered type selection appears in Illustration 23.

Illustration 23: Select the 3D Column Clustered Type

Our PivotChart appears, after our Type change, as shown in Illustration 24.

Illustration 24: PivotChart Reflects 3D Column Clustered Type

NOTE: The exact appearance of results may vary, based upon the scale parameters that result from "compression" of the PivotChart display. The images that appear, for example, in my illustrations are often "squeezed" to accommodate the space available in the document.

MS Access Archives

Latest Forum Threads
MS Access Forum
Topic By Replies Updated
Help With Microsoft Access kasy 0 September 4th, 07:35 PM
Linked table not sorting or filtering - ODBC error Java 1 August 28th, 10:37 AM
Use Parameter in select statement (Sql in Microsoft Access) katty.jonh 1 July 25th, 06:45 AM
Query Issue algebroni 7 July 23rd, 04:22 PM