Results 1 to 4 of 4

How to have a graph/chart represent whether or not a cell h as been filled

Threaded View

  1. #1
    Registered User
    Join Date
    05-12-2014
    MS-Off Ver
    Excel 2003
    Posts
    7

    How to have a graph/chart represent whether or not a cell h as been filled

    Hi everyone,

    I am making a spreadsheet that will be used to track employee time usage. I would like to be able to create a graph of the time throughout the day that shows only whether or not the employee has entered an activity during each particular time slot.

    EX: The graph shows the time from 8-10am in 30 minute increments. The employee has entered activities for the time slots from 8-9 and 9:30-10. When the graph is created, I would like to see times 8-9 and 9:30-10 filled (or, charted, or, however I should phrase it) and time 9-9:30 left blank (to represent that no work was done).

    I have attached the sheet that I am currently working with. Any help would be greatly appreciated, even if it's just pointing me in the direction of some tutorials!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 05-21-2013, 12:33 PM
  2. Replies: 0
    Last Post: 03-26-2013, 08:38 PM
  3. Create a line graph to represent Speed
    By doucie1 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-11-2012, 09:43 AM
  4. Replies: 12
    Last Post: 07-10-2012, 05:04 PM
  5. best way to represent data in Chart(graph)
    By maximpinto in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2010, 02:36 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1