See this in action: Micro-charts using camera tool. Then resize the picture so that it fits in to a small area. You can make a regular chart and take a picture link of that.
Then, embed picture links to these portions in final dashboard. First create the individual portions of dashboard in separate worksheets. When the size of these are not uniform, aligning them on output sheet could be a huge pain. In dashboards & reports: Usually in dashboards, we need to combine charts, tables of data, conditional formatting etc., all in one sheet.Here are few sample uses for picture links: What is the use of Picture Links or Camera Snapshots?Īt the outset picture links may seem like a useless feature. So that you can move the image, resize it, position it wherever you want and when the source cells change, the picture gets updated, immediately. They provide a live snapshot of a range of cells to you in an image.
Well, picture links are not really new, they are called as camera snapshots in earlier versions.
Today I want to introduce a new excel feature to you, called as Picture link.
0 kommentar(er)
