asked on

Access Pivot Chart - Can Not Copy

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

ASKER CERTIFIED SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Alia111

ASKER

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

Jeffrey Coachman

"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

Alia111

ASKER

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

Jeffrey Coachman

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

Alia111

ASKER

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