Showing posts with label office tips. Show all posts
Showing posts with label office tips. Show all posts

How to Create Histogram in Excel and Word 2007

histogram exampleHistogram is a simple column chart but there are no gaps between columns. In Excel and Word it's quite uneasy to find how to make a histogram. In Help there is only 3 results which show something related to histograms and not really helpfull.
  1. To start making histogram fill all cells with needed data in excel worksheet.
  2. Highlight all data and select insert->colum->clustered column as shown in the screenshot.
  3. A simple clustered column charts appears. You can make it look like a histogram by going to design tab and Chart Layouts. Select layout style no. 8 and see how diagram changes into histogram looking chart. The same procedure goes with Word. You can copy diagram in Word from Excel.