Results 1 to 3 of 3

Thread: How to use camera for dashboarding

  1. #1

    Lightbulb How to use camera for dashboarding



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Please Explain

  2. #2
    Acolyte Roger Govier's Avatar
    Join Date
    Mar 2011
    Location
    Located near Abergavenny, South Wales, UK
    Posts
    80
    Articles
    0
    Hi

    It is probably easiest to use if you first place the Camera tool on your QAT (Quick Access Toolbar).
    To do this go to File>Options>Quick Access Toolbar>select All command from the Choose Commands from dropdown.
    Scroll down till you reach the Camera and click the Add button then click OK to close the dialogue.
    There will now be a Camera icon at the end of your QAT>

    Select a range of cells (from any sheet) and then click the Camera icon.
    Select the sheet where you want the camera image to appear, and using the hairline cross, mark the area that the image will occupy, then click the left mouse button.
    You will now see the same information as the cells you originally selected, and any change in the values in the source cells will be reflected in the camera image.

    You can place as many images as you want on the sheet and size them to suit your purpose, independent of any row heights or column widths, as the image "sits above" the sheet and is independent of row or column sizing.

    So, with the camera you can have images form many different sheets all displayed as a single dashboard.
    Regards

    Roger Govier
    Microsoft Excel MVP
    http://www.technology4u.co.uk

  3. #3


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Very Informative Roger!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •