?
Solved

Access Pivot Chart - Can Not Copy

Posted on 2009-02-12
6
Medium Priority
?
361 Views
Last Modified: 2013-11-28
Hello Experts,
I've created a pivot chart, within Access.
When I go to Edit>Copy.... the copy option is greyed out.
It will not allow me to copy the graph.
I need to paste it into a Microsoft word document.

Does anyone know why?
Alia
0
Comment
Question by:Alia111
  • 3
  • 3
6 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 23629770
Alia111,

"Does anyone know why?"
Why? I don't know.

But if you need to paste it in word then press the "PrntScrn" (Print Screen) key while viewing the Pivot Chart, then open Word and click: Edit -->Paste.

This will paste the screenshot of the Pivot Chart into the Word Document.

:-)

JeffCoachman
0
 

Author Comment

by:Alia111
ID: 23629805
Thanks Jeff,

I can't understand why Access doesn't allow me to perform such a basic function.
I did try the approach that you've suggested, but the picture quality wasn't very good.
In part, this was due to the amount of small text within the graph.

I'll keep this question open for a bit longer.  If I receive no other suggestions, then I'll
go ahead allocate the points to you.

Good Night,
Alia
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 23630286
"the picture quality wasn't very good.
In part, this was due to the amount of small text within the graph"

Then use the "Crop" tool in Word to trim off anything that you don't need, then resize the image to make it larger.

Jeff
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 

Author Closing Comment

by:Alia111
ID: 31546232
Hi Jeff,
Your solution did solve the problem. I just wish I could figure out why Access torments users, by graying out the "copy" option.  Oh well, I've been tormented by Access in a number of ways. This is just one more to add to the (long)  list...Ha!
Alia
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 23657173
OK,  To make this easier, there are some great "Screen Capture" programs that will let you grab just the area of the screen you want.

http://www.techsmith.com/screen-capture.asp

Jeff
0
 

Author Comment

by:Alia111
ID: 23658717
Hi Jeff,

Thanks for the link!

The screen capture program will come in handy for a number of other projects.

It's inexpensive.
Therefore, it can't hurt to try it.
Alia
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question