98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Pivot Charts in queries
Pivot Charts in queries
Resolved · Low Priority · Version 2007
Wed 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
Mon 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
Mon 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?
Fri 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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Insert The Current TimeTo insert the current time into a Table field or Form textbox use: |
