Linked Picture - Distorted

[Caravishah]

Hi,

So I have a dashboard that I update every month and use linked picture for the ultimate output. I just opened the last month's file and found all my linked pictures (charts) distorted.

The picture refers to correct cells but the actual picture shows a much wider range. Pls refer the attached file for eg. I have not updated anything compared to the last update.

The other issue is distortion of an area type chart. Refer sheet 2. That is not a linked picture though.

Probable reason(s) why it got distorted? and how do I fix it once and for all.

Thanks.

 

[Caravishah]

Hi,

So I have a dashboard that I update every month and use linked picture for the ultimate output. I just opened the last month's file and found all my linked pictures (charts) distorted.

The picture refers to correct cells but the actual picture shows a much wider range. Pls refer the attached file for eg. I have not updated anything compared to the last update.

The other issue is distortion of an area type chart. Refer sheet 2. That is not a linked picture though.

Probable reason(s) why it got distorted? and how do I fix it once and for all.

Thanks.

I think I figured out the issue with the Area type chart. It was the hidden row and col setting. Fixed it to "Gaps" from "zero" and it was ok. Dont know how it worked for the last update with "zero" setting.