• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Collapsing charts

G

govi

Member
Hi,


I have a couple of charts on a dashboard which are displayed there with the use of the cameratool.


Every time I print the dashboard(paper and pdf) the source charts(which are on another sheet) collapse.


Links to the before and after pictures:

www.excelutions.nl/download/before.png

www.excelutions.nl/download/after.png


Does anyone know a solution?


Thanks,

govi
 
Govi

I've never seen that happen, but here's a few suggestions

1. Is the Camera Tool snapped to the cell it sits above, Use Alt and Drag corners to snap it to the underlying cell. It will change size as the cells are re-sized

2. Right Click the camera Tool and make sure Lock Aspect ratio is ticked

3. Maybe untick Relative to original picture size

4. Enable Move and Size with cells

5. Try Printing at 100%
 
Hui,


Thanks for your reply.


The charts are collapsing, not the picture taken with the camera tool.


I removed one picture and printed again, the chart with the picture removed didn't collapse, the others still did???
 
Govi

Same deal but with the charts

Right Click Chart

Format Chart Area

on Properties Tab, Tick Don't Move or Size with Cells

Untick Print Object

Tick Locked

and then Protect Sheet


Can you post a sample worksheet somewhere for us to see?
 
You must log in or register to reply here.
Back
Top