Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Chart Time Series work around? | Charts and Charting in Excel | |||
Pivot Chart- 2 unrelated series on 1 chart | Charts and Charting in Excel | |||
How can I make an Excel time series chart? | Charts and Charting in Excel | |||
Multiple chart series for Pivot Chart | Charts and Charting in Excel | |||
How can I chart a multi-year time series in Excel? | Charts and Charting in Excel |