Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 29th 16, 02:39 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2016
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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Chart Time Series work around? David Charts and Charting in Excel 1 February 23rd 10 12:45 AM
Pivot Chart- 2 unrelated series on 1 chart toby131 Charts and Charting in Excel 4 October 23rd 09 05:05 AM
How can I make an Excel time series chart? MA Charts and Charting in Excel 1 January 29th 08 08:00 AM
Multiple chart series for Pivot Chart MJW[_2_] Charts and Charting in Excel 0 August 15th 07 08:16 PM
How can I chart a multi-year time series in Excel? Dave Nuttall Charts and Charting in Excel 0 November 28th 05 07:52 PM


All times are GMT +1. The time now is 05:59 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017