#1
|
|||
|
|||
Graph occurences over full range of time?
I have a set of dates that are records of registrations for an event. Each date represents a single registration as reported by event software.
I'd like to graph the registrations over the full range of time in which they ocurred. So in the attached dataset, I'd like to graph the number of registrations on the indivdual days but have the full date range of 5/12-7/8 on the H axis. I've been using a pivot chart, which is useful, but it has even spacing between the days. I've also built a regular line chart using the data from the pivot chart, but I get more or less the same result (see attached). Any suggestions? Thanks. |
#2
|
|||
|
|||
Let me see if I have this straight. You want a graph, but for the x-axis you'd like all the dates displayed regardless of whether or not they have data?
|
Tags |
count occurrences, graph occurrences, graph time |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Run-time error '5904' Cannot edit range. | frustrated teacher | Word VBA | 1 | 06-05-2015 06:09 PM |
Most active time range | 1N82I | Excel | 3 | 02-08-2015 12:39 PM |
column clustered bar graph with a line graph as secondary axis | Alaska1 | Excel | 2 | 06-09-2014 07:13 PM |
Priority of line graph vs bar graph in terms of front to back positioning on a chart | DavePPointuser | PowerPoint | 1 | 04-30-2014 10:57 AM |
counting occurences of a value in a range but not including 0's nor blanks | virsojour | Excel | 0 | 07-05-2010 01:34 AM |