Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-09-2015, 03:55 AM
pixeldroid pixeldroid is offline Graph occurences over full range of time? Windows 7 64bit Graph occurences over full range of time? Office 2010 32bit
Novice
Graph occurences over full range of time?
 
Join Date: Feb 2014
Posts: 5
pixeldroid is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Occurence_v_TimeGraph01.xlsx (19.6 KB, 9 views)
Reply With Quote
  #2  
Old 07-13-2015, 09:30 AM
gebobs gebobs is offline Graph occurences over full range of time? Windows 7 64bit Graph occurences over full range of time? Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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?
Reply With Quote
Reply

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
Graph occurences over full range of time? Most active time range 1N82I Excel 3 02-08-2015 12:39 PM
Graph occurences over full range of time? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:17 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft