Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Someone please help me with Microsoft Excel...FAST!?
Here's my scenario:
My mom gave me all the statistics for when her subordinate doctors did and did not show up to work, how long they stayed, and how many patients she saw. In order to prove to her bosses that two of her doctors are lazy, she asked me to make her a productivity chart using that info. I already have the line graph set up, but I have a problem. I put every single day on the graph because on any given day, there was at least one doctor. The bad thing is that if a doctor didn't work that day and I just leave the space empty, the graph puts it down as a zero, making that doctor look bad. How can I make the line skip a date?
EXAMPLE:
If my X-axis goes, "1, 2, 3, 4, 5," I want the line to go straight from 1 to 3 without showing any info for the two.
(If you recognize this question, it's caused I asked it an hour ago but got no answers.)
Sorry for the confusion, here's some clarification:
My mom's a charge nurse, hence all the doctor talk. When I said, "every single day," I meant every day of the year. The thing is, not every doctor was there every day of the year. If I just put a zero into the slots for days certain doctors weren't there, then there average numbers would look real bad. Is there any way that I can make Excel ignore a day for a certain doctor?
Sorry for the confusion, here's some clarification:
My mom's a charge nurse, hence all the doctor talk. When I said, "every single day," I meant every day of the year. The thing is, not every doctor was there every day of the year. If I just put a zero into the slots for days certain doctors weren't there, then there average numbers would look real bad. Is there any way that I can make Excel ignore a day for a certain doctor?
Aaagh! Why'd it post twice!!!??? Sorry 'bout that!
=null didn't work, any other ideas!? Please, people, I need this done in half an hour!
2 Answers
- shorte716Lv 61 decade agoFavorite Answer
I read your question and I'm trying to follow what your asking to do. Little confused though. Is there any way you can put like an N/A in or maybe do a key code like 98 = N/A.
