Excel Camera Tool - Print Preview different from display on screen

[MacGyver7640]

Good morning,

I'm completely out of ideas here and have searched everywhere online. I have place a camera-picture of a table on the right side of a chart. On the screen it looks great! (See below - with some redaction)

Problem Example.png

.... but when I print it the table expands off of the side of the chart. Scale is 100%, zoom is 100%, Excel 2010 (See below - with some redaction). Whether or not I have a print area does not seem to make a different in the problem. Also, it appears that this happens with any shape I put in that place, it's not specific to the camera tool.

Problem Example_Print Preview.png

I'm baffled, any ideas? I would truly appreciate it!

[Steve N.]

Can you send the file so we can tinker with it? (Personal, business sensitive data removed)

[MacGyver7640]

Cleaned the sensitive information. Here it is. I really appreciate it!!

Print Preview Problem.xlsx

[MacGyver7640]

No luck so far, but if you are reading this and having a similar problem the only workaround I found was selecting both the table and the chart and copy/pasting as an image.

Any ideas would be deeply appreciated!

[Steve N.]

Kicked my butt too, Mac. Sorry I couldn't be more help. Not the printer settings?

[MacGyver7640]

Shucks! Thanks for checking it out regardless! I'll come back and post if I ever find something.

Doesn't seem to matter if its printed to pdf or to printer, so it doesn't seem to be printer settings.

[abousetta]

I think I found your problem. It's not with the picture, it's with the chart.

1. Right click on chart
2. Format chart area
3. Properties
4. Click on "Move and size with Cells"

It resolved the issue on my computer. Let me know if it works for you also.

abousetta

[MacGyver7640]

YOU DID IT!

Thank you!

Works like a charm. This is huge, thanks!

[abousetta]

Sometimes it's the really small things that make or break our project.

Glad I could help.

Good luck.

abousetta

P.S. If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save