![]() You must organize the data in two columns on the worksheet. It would be also nice to add 2 vertical lines, to separate the three histograms. To create a histogram in Excel, you provide two types of data the data that you want to analyze, and the bin numbers that represent the intervals by which you want to measure the frequency. The problem is that i can't fit the first and the second histogram into the figure, possibly by reducing the gap between each histogram, as well as the their respective x labels. Excel has plotted age groups ( 7 to 17 years, 18 to 28 years, and so on) on the x-axis. And here comes a histogram for your data. Click on Histogram and choose the first chart type. ![]() As you can se in the picture, there are three different Histograms, each for a specific Survey. Go to the Insert Tab > Charts > Recommended Charts. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |