Pivot Charts in queries

The UK's most regular instructor-led training courses.
Training information: access database microsoft training · Microsoft.access.courses · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2007

2 posts

ReplyWed 27 Jan 2010, 17:14Delegate Elvira said...

Elvira has attended:
Access Intermediate course
Access Advanced course

Pivot Charts in queries

Hi. After creating a pivot chart in a query is there an easy and quick way of putting the chart and data into a report? I currently have to create the report and add fields to calculate totals or averages on reports although it's so much easier to do in pivot view and am not very good at graphing data in reports. Thanks for any suggestions. Elvira

Version	Date	Location	Places available	Book	Next place rate (£)
Access VBA 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Wed 24 + Thu 25 Mar 2010	Southwark	8		£445	£450
2003	Wed 5 + Thu 6 May 2010	Bloomsbury	10		£275	£280
2003	Mon 28 + Tue 29 Jun 2010	Bloomsbury	10		£275	£280
2003	Wed 4 + Thu 5 Aug 2010	Bloomsbury	10		£275	£280
2003	Thu 9 + Fri 10 Sep 2010	Bloomsbury	10		£275	£280
2003	Wed 27 + Thu 28 Oct 2010	Bloomsbury	10		£275	£280
Full Schedule: See all 7 Access VBA course dates. Bookings currently available until 6th December 2010.

748 posts

ReplyMon 1 Feb 2010, 15:56Trainer Stephen said...

RE: Pivot Charts in queries

Hi Elvira

Thanks for your question

Can you clarify one thing for me?

1. Are you building your pivot chart in Access or are you exporting the basic query to Excel and building it there?

Thanks

Stephen

2 posts

ReplyMon 1 Feb 2010, 16:04Delegate Elvira said...

RE: Pivot Charts in queries

Hi. I'm building the pivot charts in access and I have weekly reports I'm running for the team but it's hard to share the pivot charts with them in a nice format. That's why I'm looking into creating reports from those pivot queries but it seems rather labour intensive. Any suggestions for an easy solution or should I just do it in Excel?

648 posts

ReplyFri 5 Mar 2010, 11:09Trainer Simon said...

RE: Pivot Charts in queries

Hi Elvira,

I am sorry about the delay in responding.

I have always found when creating Charts or Pivot Charts, Excel is a lot easier to create effective charts.

Creating charts in Access has always been labour intensive.

I would suggest exporting the data to Excel and create your charts using this application.

Regards

Simon

· Easy Updating With Microsoft Access
· Interested In The Golden Rules For Building Access Databases?
· MS Access: Access your Personal Information with Ease
· Access Corruption Avoidance Tip #3: Stay Connected
· Access Corruption Avoidance Tip #2: Avoid Dangerous Data

Please browse our web site to find out more about
access database microsoft training and other Microsoft training courses.

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips