View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Ilengaiarasan V Ilengaiarasan V is offline
external usenet poster
 
Posts: 1
Default Excel Pivot Chart with Time Series


Using the table appended below I can get a pivot chart. However, the time series viz. Wt_Time & Serv_Time I am getting the value of the field option as count. I want the exact value of time against each date.

How this is possible.? Please help.

Regards.!

-via135

The table is as under

Date Total Tickets Wt_Time Serv_Time
02-04-16 208 0:11:45 0:02:51
04-04-16 338 0:38:18 0:02:42
05-04-16 291 0:14:25 0:02:34
06-04-16 278 0:13:52 0:02:39
07-04-16 273 0:16:56 0:02:50
11-04-16 358 0:15:52 0:02:41
12-04-16 266 0:21:58 0:03:07
13-04-16 270 0:28:36 0:03:03
15-04-16 206 0:09:01 0:03:23
16-04-16 159 0:06:52 0:02:26
18-04-16 247 0:23:47 0:03:13
20-04-16 306 0:20:15 0:03:01
21-04-16 188 0:08:03 0:03:07
22-04-16 183 0:05:14 0:02:43
25-04-16 254 0:16:58 0:03:01
26-04-16 251 0:10:16 0:02:35
27-04-16 289 0:21:37 0:02:52
28-04-16 179 0:04:04 0:02:27
29-04-16 196 0:09:23 0:03:06