Need Microsoft Excel help, 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.

2 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    I answered your other question, I'm thinking about how you can go about doing this. Can you do a line graph separate for each dr, and then only putt in the days she worked? So then you won't necessary be skipping a day just not putting it in. Sorry I was really trying to help.

  • 4 years ago

    A wek isn't sufficient time. maximum experienced Excel shoppers basically be conscious of 5 - 10% of this methodology. And, maximum businesses basically choose that time of information, yet they continuously ask for ninety% skillability. So, learn the basics and you may %. up something once you get the activity. to earnings the basics, look on line for loose basic tutorials, there are a lot of them. initiate right here: Or %. up books on the library. And, right this is the loose Excel BIBLE: For each and everything else, memorize this internet site tackle:

Still have questions? Get your answers by asking now.