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.)

Update:

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?

Update 2:

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?

Update 3:

Aaagh! Why'd it post twice!!!??? Sorry 'bout that!

Update 4:

=null didn't work, any other ideas!? Please, people, I need this done in half an hour!

2 Answers

Relevance
  • 1 decade ago
    Favorite 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.

  • 1 decade ago

    Try =null

Still have questions? Get your answers by asking now.