To create an instant micro-chart from your normal chart, use the camera tool

  1. Go to menu  then tools then customize
  2. In the dialog go to “Commands” tab and select “tools” in categories.
  3. Scroll down the commands until you see the camera tool
  4. Drag and drop this in your tool bar as shown below

How to use camera tool to create a micro-chart in excel.

  1. Make a normal chart.
  2. Select the cells surrounding the chart
  3. Click on camera tool
  4. Now click any where in the worksheet and excel places a snapshot of the range you have selected
  5. Resize it until you get the microchart effect.
  6. Excel adds a border to the camera tool output, you may remove it by using the drawing tool bar