How does Excel2003 data generate histograms?

Source: Internet
Author: User

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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.