Note that the y axis is counting the number of times a value (in this case of type 1) falls between the ranges on the x axis. ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |