Pivot Charts in queries

Resolved · Low Priority · Version 2007

Wed 27 Jan 2010, 17:14 Delegate 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

Mon 1 Feb 2010, 15:56 Trainer 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

Mon 1 Feb 2010, 16:04 Delegate 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?

Fri 5 Mar 2010, 11:09 Trainer 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