I need to create a graph of events over time, with "days between events" calculated. I think I've seen this done in a line graph.
My knowledge of Excel is very limited, so I am pretty much starting from scratch. Thanks!
Last edited by California55; 02-21-2009 at 08:00 PM. Reason: I can make it clearer.
Enter your data in a format similar to this. (attached)
Make sure you have a column that actually demonstrates the Days Between. I used a simple:
...copied down in the C column to get the days, format that column as General.Code:C4 =B4-B3
Now highlight the whole chart, and click on the Chart icon. Select Bar graph.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Thank you. I really only need two columns, after all.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks