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
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
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?
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
