View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
JaWeek JaWeek is offline
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%