Looking at your pictures, I must not be understanding what you want to do. See if that will allow you to upload a sample. Below the post editor is a "manage attachments" link that opens up the file uploader in another window/tab. 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. The x and y axis are still not correctly representing what I truly want.
0 Comments
Leave a Reply. |