Forum Discussion
anupambit1797
Sep 03, 2025Iron Contributor
Time-Axis doubt
Dear Experts, I have a data as attached and below, I want to have the Time-diff in Y-Axis, but seems none is plotted:- Could you please share what wrong I am doing here. T...
- Sep 03, 2025
Yes, we can't sum datetime. We could find, for example, min or max for it. Use source as numbers, sum and apply datetime format to resulting field.
Detlef_Lewin
Sep 03, 2025Silver Contributor
The values in your pivot table are all 0. It seems that a regular pivot table cannot deal with that small numbers.
Try a data model pivot table instead. It works for me.
- anupambit1797Sep 03, 2025Iron Contributor
Thanks Detlef_Lewin​ for your response, could you please share the steps along with the attached worksheet .
Thanks & Regards
Anupam
- Detlef_LewinSep 03, 2025Silver Contributor
Go to Insert > PivotTable. In the "Create PivotTable" dialog box, select your table range and be sure to check the box that says "Add this data to the Data Model" before clicking OK.
(Copied from a chatbot answer)