Can someone please let me add 3 sigma to the attached spread sheet for both fire and release. I have no clue how to. confused:(
Can someone please let me add 3 sigma to the attached spread sheet for both fire and release. I have no clue how to. confused:(
Assuming that you want to add a vertical line at the point that you have calculated to be 3 Sigma, cell C12 on the 'Fire' sheet, the following will work:
1) Arrange a table as shown in B19:C21, note the the values of B20:B21 are linked to C12 and the value of C21 is linked to F6
2) Select and copy the table,
3) Select the graph and select paste special,
4) Select the New Series, Categories in First Column, and Series Names in First Row options
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks