You need to format the x-axis of the graph. Double click on the x-axis and a
pop up wil appear. Select Scale tab. Then change Major and Minor Units to
Days and change the numbers from 1 to 30.
It is not a formula. It is sometimes hard to get the Format window to pop up
for the x and y axis. Try to double clicking the X-Axis and then the Y-Axis
and then the X-Axis again until the window pops up.
Joel,
I got the information wrong from my boss. She want to know how many
corrective actions are still open after 30, 60, 90 days. I have a
spreadsheet that counts the number of days a corrective action in open. Now
I need to know how many of these corrective actions are 30,60,90 days old.
Is there a formula that will do this?
Joel,
After all this time my boss just got back to me on the age chart. What I
have isn't what she wanted. I'll try to explain again and see if I get it
right.
I need a formula to calculate the number of open corrective actions based on
the date the corrective action was entered. The formula needs to calculate
the number of open corrective actions as follows:
1 to 30 days
31 to 60 days
61 to 90 days
and over 90 days
Please help the formula you gave me did not work the way my boss wanted it.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
