Microsoft KB Archive/304114

= HOW TO: Use a PivotChart View to Create a Combination Chart in Access 2002 =

Article ID: 304114

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q304114



Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

IN THIS TASK
SUMMARY
 * Example Steps



SUMMARY
This article shows you how to create a combination chart. A combination chart is a chart on which different series have a different chart type. For example, one series might be a bar chart. Another series might be a line chart. You can create a combination chart in Access 2002 by using PivotChart views.

back to the top

Example Steps

 * 1) Start Access.
 * 2) On the Help menu, point to Sample Databases, and then click Northwind Sample Database.
 * 3) Open the Invoices query.
 * 4) On the View menu, click PivotChart View.
 * 5) Drag the OrderDate by Month field to the Drop Category Fields Here area. This will display the years in the Category fields area.
 * 6) Drag the Salesperson field to the Drop Series Fields Here area.
 * 7) Drag the ExtendedPrice field to Drop Data Fields Here area. This will display the sum of extended price per employee per year.
 * 8) On the View menu, click Properties.
 * 9) In the Select box on the General tab, select one of the data series, for example, Laura Callahan or Margaret Peacock.
 * 10) On the Type tab, click the type of chart that you want in the smaller box on the left, and then click the chart subtype that you want in the larger box on the right. Note that this changes the data series, depending on your selections.
 * 11) Repeat steps 9 and 10 for all the data series that you want to display as a different type of chart.

back to the top

Additional query words: inf

Keywords: kbhowto kbhowtomaster KB304114

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.