Microsoft Office Forums Graph displaying chronologically the amount of calls we get

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-29-2013, 10:58 AM
sceneitguitar sceneitguitar is offline Graph displaying chronologically the amount of calls we get Windows 7 64bit Graph displaying chronologically the amount of calls we get Office 2010 32bit
Novice
Graph displaying chronologically the amount of calls we get
 
Join Date: Sep 2013
Posts: 3
sceneitguitar is on a distinguished road
Default Graph displaying chronologically the amount of calls we get

I need to make a simple graph. I have a huge excel sheet documenting when we get calls from the media. The spreadsheet has the date for each call we get. I simply want to make a graph displaying chronologically when we get a lot of calls.

The X axis would just be a timeline.
The Y axis would be the frequency of calls.
If we got three calls on 9/16/13 I would like that point on the Y axis to be three times higher than on a day we had no calls. Does this make sense

I'm having trouble doing this because I only have one set of data to use; a bunch of dates.

Can someone please tell me how to do this.

Here is an example of the spreadsheet I'm working with.



[IMG][/IMG]
Reply With Quote
  #2  
Old 09-29-2013, 11:28 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Graph displaying chronologically the amount of calls we get Windows 7 64bit Graph displaying chronologically the amount of calls we get Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Please post a sample sheet. A picture is nice but quite useless
__________________
Please note I am not active on this forum anymore
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Graph displaying chronologically the amount of calls we get column clustered bar graph with a line graph as secondary axis Alaska1 Excel 2 06-09-2014 07:13 PM
Adding an amount to a min-max range Nibbles Excel 4 06-13-2013 08:05 AM
amount of work ketanco Project 3 04-06-2012 08:13 AM
How to know the outstanding balance amount of a Loan? PRADEEPB270 Excel 1 01-07-2012 04:45 AM
Sum required without consider the negative amount PRADEEPB270 Excel 2 08-22-2011 04:23 AM


All times are GMT -7. The time now is 08:18 AM.


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