Results 1 to 3 of 3

Simple Count Chart

Threaded View

  1. #1
    Registered User
    Join Date
    10-26-2005
    Posts
    31

    Simple Count Chart

    Hello Everyone,

    I am composing a spreadsheet to chart the number of visitors to our counseling office. The chart records time via two timestamps, (one for when visitors arrive, and one for when they are finally served), and there are fields for area of interest.

    I would like to produce an automatically updating chart (using "OFFSET" and "COUNT" perhaps?), which notes how many visitors came through our office on a given day, reading data from the timestamps. If possible, the chart would display how many visitors met with each of our counselors, and include a total tally series.

    I'm pretty new to chart making and troubleshooting, but I'm a quick learner. I wonder what to set for a data range, and how best to assign Name, Value, and X-Axis Labels. I've tried a bit already, but without much luck; I can't seem to get more than one value on the x-axis, and no data is reading.

    A Thousand Thanks for any help, in advance!

    (image of sheet attached)
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

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