Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
SteveJ
 
Posts: n/a
Default Help with Pivot Chart

I have a sheet that tracks tickets.

Col - A = Ticket Number
Col - B = Date Open
Col - C = Date Closed


I need to create a line chart that shows 1 colored line for tickets
open for each month


and another colored line showing tickets closed for each month


There are tickets that remain open from more than aa single month.


I can create a chart for 1 but I don't know how to do it to show both.


Any ideas?
Steve



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 formatting Renato Charts and Charting in Excel 1 January 19th 05 01:19 PM
Pivot Chart: cannot apply the default chart type... doco Charts and Charting in Excel 1 January 17th 05 04:55 PM
pivot chart format Valeria Charts and Charting in Excel 1 January 14th 05 01:19 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM
using the PIVOT TABLE and CHART Big Red Excel Discussion (Misc queries) 1 November 29th 04 08:42 PM


All times are GMT +1. The time now is 06:56 PM.

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

About Us

"It's about Microsoft Excel"