Hi
I have an excel document where
A = time
B = items bought
I want a graph (any graph) that says between the hours of 11AM-11:59 there were 9 items bought for example.
HELP!
Hi
I have an excel document where
A = time
B = items bought
I want a graph (any graph) that says between the hours of 11AM-11:59 there were 9 items bought for example.
HELP!
C = HOUR(A) and copy down
Select B:C, Insert -> Pivot Chart
Column C = Rows
Column B = Value
Last edited by daffodil11; 04-28-2014 at 02:09 PM.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Ok I have to add a 3rd colum? I was wondering if it could read the first two numbers for example 10 out of ther 10:34 or 22 out of the 22:41. I dont really want to go through adding what time it was (It is a pretty big log). Also I am thinking that I may need to add date.
My bad I understand what you did, I appreciate it!!
No problem, glad I could help out.
If that answers your questions, please be sure to mark the thread as solved, under Thread Options at the top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks