Excel: Switch the bars of the charts
Question Description
Hello
You will find sheets in the attached excel file, kindly go only to the following sheets:
Sheet: Comparison KPI#1
Change the bars of the charts to be: AVG of Wait time 2018 (bar), then beside it AVG of Wait time 2019(bar). Then in the other side in the same chart AVG of late time 2018 (bar), then beside AVG of Late Time 2019 (bar). Make Different color for 2018 and for 2019.
Sheet: Comparison KPI#2
Switch of the years of the bars in the chart for the No show patients in nutrition clinics; make first 2018 bar then beside it 2019 bar for each clinic. The bars for the total of No show change the red color to be different color for 2018 & 2019.
Sheet: Comparison KPI#3
Change the bars of the charts to be: 03rd Next Available Appt for New Pat. 2018 (bar), then beside it 03rd Next Available Appt for New Pat. 2019(bar). Then in the other side in the same chart 03rd Next Available Appt for Follow up Pat. 2018 (bar), then beside 03rd Next Available Appt for Follow up 2019 (bar). Make Different color for 2018 and for 2019.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."