Yahoo Clever wird am 4. Mai 2021 (Eastern Time, Zeitzone US-Ostküste) eingestellt. Ab dem 20. April 2021 (Eastern Time) ist die Website von Yahoo Clever nur noch im reinen Lesemodus verfügbar. Andere Yahoo Produkte oder Dienste oder Ihr Yahoo Account sind von diesen Änderungen nicht betroffen. Auf dieser Hilfeseite finden Sie weitere Informationen zur Einstellung von Yahoo Clever und dazu, wie Sie Ihre Daten herunterladen.
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 Antworten
- shorte716Lv 6vor 1 JahrzehntBeste Antwort
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.
