I am trying to make a column and line graph with 2 Y-axis. I am using the incident count on Primary axis and want to use the compliance percentage on the secondary. The graph shows up however the percentages do not show as co-related to the columns. e.g. if the ticket count for august is 600 incidents and compliance is 97%.Is there a way that the line shows as 97% of the incidents listed in columns. As of now it is showing as 97% in relation to the axis and that goes out of the column area.
Action January February March April May
Total incidents 1361 699 700 856 873
Handling % 2.94% 21.89% 38.71% 52.10% 48.45%
Bookmarks