The only reliable upload method I have used here is to click on reply to thread or go advanced.

I don't know what is up with the various uploader options on this site, but a lot of people have trouble. PS: couldn't attach the Excel file for some reason - so sent it via pictureĪ picture is usually harder to debug from. This is exactly what I want, but I want to stack all of the machine Types! frustrating stuff If I change those x axis ranges in the excel options, the y axis count changes accordingly. 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. It does not store any personal data.The x and y axis are still not correctly representing what I truly want. The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. The cookie is used to store the user consent for the cookies in the category 'Performance'. This cookie is set by GDPR Cookie Consent plugin.

The cookie is used to store the user consent for the cookies in the category 'Other. The cookies is used to store the user consent for the cookies in the category 'Necessary'. The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category 'Functional'. The cookie is used to store the user consent for the cookies in the category 'Analytics'. These cookies ensure basic functionalities and security features of the website, anonymously. Necessary cookies are absolutely essential for the website to function properly.

How to combine histograms in excel