How to create an instant micro-chart from your normal chart in Excel

Home - Excel - How to create an instant micro-chart from your normal chart in Excel
in

How to create an instant micro-chart from your normal chart in Excel

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

Leave A Comment

Recent News

Clients Reviews

Flickr Photos

Contact Us

177 queries in 3.436 seconds.