Grouping by day

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a table that has numerouse entries by day, and the date is set as
dd-mm-yyyy hh:mm:ss.

Is there any way to make a chart that groups data by day ignoring the time
part of the date? I've tried this with a pivot chart, but I end up with
several entries for each day.

Thanks for any help!
 
How about adding another column that contains only the date? The easiest way
to get just the date would be =INT(A2), where A2 contains the date and time.

--
Regards,

Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
 
Yes, I've used that workaround, I was looking for a more direct way of doing
it.

Thanks anyway!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

refreshing charts 3
Charts: How can I get a date axis to include hours and minutes 2
graph by month/year a count of a list of dates 1
Changing the date format on the date table in a chart 2
How can I update my charts x axis (dates) automatically with new d 1
Category Axis Date Labels 1
Missing Axis Category Labels 1
Pivot Chart Data Table 1

Back
Top