As I create my graph, clustered column chart, I want my graph bars to just show the # of incidents and the data table below the graph bars to show # of incidents and # procedures.
I'm finding that the Axis is focusing on the # of procedures, so it goes from 0 to 60....
But I want my bars to only represent # of incidents with an Axis that goes to, let's say 5, but also show a data table below the bars, that shows # of incidents and # of procedures?
How do I manipulate the chart to give me this? I'm questioning if I should a different chart all together? Need some guidance :-|
Below is my sample data for the chart...
I'm finding that the Axis is focusing on the # of procedures, so it goes from 0 to 60....
But I want my bars to only represent # of incidents with an Axis that goes to, let's say 5, but also show a data table below the bars, that shows # of incidents and # of procedures?
How do I manipulate the chart to give me this? I'm questioning if I should a different chart all together? Need some guidance :-|
Below is my sample data for the chart...
CY20 | CY21 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct. | Nov | Dec | YTD | |
# of Incidents | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 |
# of procedures | 50 | 40 | 0 | 1 | 3 | 12 | 8 | 2 | 5 | 3 | 4 | 6 | 1 | 0 | 45 |