LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default How to group bars showing counts and overlay line compliance chart

Using data similar to what's below (month, ticket count type, customer, SLA
compliance %), I'd like to be able to have the bars with the # of tickets
opened and closed for each month grouped so the bars touch each other while
still having space inbetween each months' bars (using the 1st axis). I only
can seem to find an option that determines the space between all bars...not
allowing me to group the bars for a given month.

As a second issue, the SLA compliance % data for closed tickets won't show
up as a line chart overlaying the bar chart described above. I can get
milestones to show, but not the line itself (using the 2nd axis).

Any help in accomplishing either or both items would be greatly appreciated.

Ticket Volume & SLA Compliance
Month Ticket Count Types Customer #1 Customer #2 Customer
#3 Resolution SLA
Jul Opened 349 53 426
Closed 340 60 430 68%
Aug Opened 405 69 477
Closed 390 75 460 73%
Sep Opened 430 90 732
Closed 450 90 715 78%
Oct Opened 408 79 621
Closed 400 70 600 69%

 
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
Up/down Bars - Line Chart ajvasel Charts and Charting in Excel 2 April 10th 07 09:28 PM
Make a line in a bar chart, and change color of any bars that exceed the line MarkM Excel Discussion (Misc queries) 4 July 5th 06 04:06 PM
Can a combo chart plot 4 variables? (3 bars,1 line) [email protected] Charts and Charting in Excel 1 June 20th 06 01:41 PM
Chart showing one line for several rows PEA Charts and Charting in Excel 0 August 30th 05 07:48 AM
How to display chart with three bars and one line? KB Charts and Charting in Excel 1 March 16th 05 08:09 PM


All times are GMT +1. The time now is 02:20 AM.

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"