Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Grouping by day
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! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Grouping by day
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 "J.Alex." wrote: 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! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Grouping by day
Yes, I've used that workaround, I was looking for a more direct way of doing
it. Thanks anyway! "Tushar Mehta" wrote: 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 "J.Alex." wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protected cells and grouping | Excel Discussion (Misc queries) | |||
worksheet tabs do not respond to grouping | Excel Discussion (Misc queries) | |||
How to unprotect Grouping controls | Excel Worksheet Functions | |||
grouping of cells in protected sheets | Excel Worksheet Functions | |||
Date Format Pivot Grouping | Excel Discussion (Misc queries) |