#1
|
|||
|
|||
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] |
#2
|
||||
|
||||
Please post a sample sheet. A picture is nice but quite useless
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |