Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Up/down Bars - Line Chart | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
Can a combo chart plot 4 variables? (3 bars,1 line) | Charts and Charting in Excel | |||
Chart showing one line for several rows | Charts and Charting in Excel | |||
How to display chart with three bars and one line? | Charts and Charting in Excel |