software

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
www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approachquot;J.Alex.quot; wrote:

gt; Hello,
gt;
gt; I have a table that has numerouse entries by day, and the date is set as
gt; dd-mm-yyyy hh:mm:ss.
gt;
gt; Is there any way to make a chart that groups data by day ignoring the time
gt; part of the date? I've tried this with a pivot chart, but I end up with
gt; several entries for each day.
gt;
gt; Thanks for any help!

Yes, I've used that workaround, I was looking for a more direct way of doing
it.

Thanks anyway!

quot;Tushar Mehtaquot; wrote:

gt; How about adding another column that contains only the date? The easiest way
gt; to get just the date would be =INT(A2), where A2 contains the date and time.
gt;
gt; --
gt; Regards,
gt;
gt; Tushar Mehta
gt; www.tushar-mehta.com
gt; Custom business solutions leveraging a multi-disciplinary approach
gt;
gt;
gt; quot;J.Alex.quot; wrote:
gt;
gt; gt; Hello,
gt; gt;
gt; gt; I have a table that has numerouse entries by day, and the date is set as
gt; gt; dd-mm-yyyy hh:mm:ss.
gt; gt;
gt; gt; Is there any way to make a chart that groups data by day ignoring the time
gt; gt; part of the date? I've tried this with a pivot chart, but I end up with
gt; gt; several entries for each day.
gt; gt;
gt; gt; Thanks for any help!