How does Excel2003 data generate histograms? Use Excel 2003 to do data analysis histogram should be less, I Baidu did not have a lot of this aspect of the relevant introduction, so write here, for you to share.
1. First create a new Microsoft Excel worksheet, open and click "Tools"-"Add-ins"
2, pop-up dialog box in the "Analysis ToolPak" tick after the point to determine, (if your Excel does not have this option, you are using a streamlined version, recommended to download again)
3, I used Excel to do such a number of data for reference, this example for the test scores, the data range is determined to 0-100
4, select "Tool"-"Data Analysis"-"histogram", the dialog box appears, as shown in the picture set good
5, I set the time directly generated in the current page, such as the figure
6, the histogram can move freely, enlarge and shrink
7, then double-click any rectangle inside the Histogram, pop-up dialog box, point "options"-"classification spacing" set to 0, as shown in the picture
8, double-click other places can be related to its settings, change the font, color can be, very simple.