• Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • More  
    • Blog
    • Download Area
    • Excel Video Tutorials
You are here: Home / Blog / Create A Micro Chart From A Normal Excel Chart

Create A Micro Chart From A Normal Excel Chart

March 22, 2016 by Barbara

Here is a really great way of displaying a micro (or easily resizeable) chart in Excel. It makes use of the Camera Tool. Sometimes hidden, Camera is a tool that is really useful but not that many Excel users either exists or see how they could use it productively.

The Excel Camera tool lets you take a live picture of a range cells (a chart for example) and everytime that range of cells change the picture updates dynamically as well to reflect these exact changes. That could be useful right?.

The Camera tool is not in the usual default Excel Ribbon set up, but it is easily added to the Quick Access Toolbar (QAT) in Excel with a few clicks like this-

add camera to QAT Pin it! Share on Facebook

  • Click on the Customise Quick Access Toolbar
  • Select More Commands
  • Select All Commands Or Commands Not In The Ribbon
  • Search for and select Camera
  • Click Add to add to the QAT
  • Your Camera Tool is added to your QAT and ready to start snapping those images!

add camera to QAT2

add camera to QAT3 Pin it! Share on Facebook

 

 

 

 

 

 

 

 

 

 

 

 

So we have out Camera Tool, let’s start creating some dynamic micro pictures. In my example below I have a simple Pivot Table, and want to take a picture of it to put on an Excel dashboard with limited space, so I want a smaller version of the chart. ie. a micro chart.

Here is my standard Pivot Table. Let’s use Camera Tool to take its picture then reduce its size to put on our dashboard.

camera tool chart Pin it! Share on Facebook

 

 

 

 

 

 

 

 

 

Select the cells that you want in the picture. In this case I highlight the chart itself.

  • Go the Camera Tool and click.
  • Excel takes a picture of the area.
  • Click where you the picture to reside, in this case I have put it on the same worksheet as the original to compare the new image and the original.

camera tool chart1 Pin it! Share on Facebook

 

 

 

 

 

 

 

 

 

 

 

 

  • You can go ahead and resize to a micro chart at this stage.
  • If you click on the new picture and use the Drawing Tools options, you can edit this image more by adding or removing the border for example.

camera tool chart2 Pin it! Share on Facebook

Want To Watch The Excel Tip On Video?

More Excel Tips

  • Hide all of your Excel formulas from prying eyes!
  • Undertand and debug Excel formula errors
  • How To Display a Plus + Sign On Positive Numbers With Custom Formatting In Excel

MR Xl 40 formulas

excel-formulas-ad-5

 

Filed Under: Blog, Excel Charting Tagged With: Excel Charting, Excel Tips

SHARE

Tweet

Additional Info

Need Answers To Excel Questions Like These?

*How Do I Create A Timestamp In Excel?
*I Want To Change The Width Of The bars On My Excel Chart
*How Can I Find Out The Length Of My Text in Excel? Click the link below to receive more Excel tips' and my Free Ebook

Sign Up For My FREE Excel Tips Newsletter and receive your own E-book of my Top 50 Excel Tips.

New To Excel? This Is A Great Place To Start!!

excel-formulas-ad-5 Excel Basics
Scrollbars
Colour of Sheet Tabs
Conditional Formatting
Calculations Introduction

Advanced Excel

Power BI Webinar Excel Expert Course Excel Dashboard Course
Data Validation Lists
Create A Timestamp
Create Table Of Contents

Excel Charting

Self Expanding Charts
One Click Charts
Create Quick Dynamic Charts
Easy Combination Charts

Video Tutorials-If You Like To Learn By Watching

Subscribe to YouTube to get notified of of new Excel videos.


Self Expanding Chart
Delete Obsolete Items From A Pivot Table-Excel 2007
What Are Pivot Tables- Create Your First One
Enable The DeveloperTab In Excel

Some Fun Stuff

Pivot Table Song

Tags

Blog Cells Excel Excel Charting Excel Formulas excel tip Excel Tip Category Excel Tips Excel Tips& Tricks excel tutorials Excel Videos Excel Video Tutorials formatting Formula formula friday Formulas macro Macro Mondays Macros Pivot Tables Power BI Power Query Tutorials vb VBA Worksheets

Recommended Excel Resources

Free Excel Dashboard Webinar

Copyright © 2019 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in

privacy policy