fanolz.blogg.se

How to do a histogram on excel
How to do a histogram on excel













how to do a histogram on excel

However, even with all data selected, it only graphs one column of data - the other columns are hidden behind it. PS: couldn't attach the Excel file for some reason - so sent it via picture example.JPGĬonversely, a histogram gives the correct x and y axis. Thanks, I don't think I've ever spent this long trying to make a silly graph. The importance of the stacking is that I can see how each specific machine contributes to the total number of screws made within that range. "10 screws were made within 20-22mm, 7 within 22-24mm etc etc". Ultimately, I would be able to make a claim saying. The x-axis should contain that range (20-22mm or whatever it is). Y-axis should contain whole integers representative of a claim saying "10 screws were made that were within this range". I am giving Excel a lot less information than I should be. The x and y axis are still not correctly representing what I truly want.















How to do a histogram on excel