Hi Team,
I have a data where in i have five main heads (qtr, dates, cadre, SLA & actual days), Now i want to prepare a chart in which the X-axis shows either the QTR or dates and the Y-axis shows the actual days. Also i want a straight line for both Regular and FTC SLA's ( 60 and 45 each) on the Y-axis. I prefer to show the actual days as a separate line charts for Qtr-2016 and Qtr-2017 Attached please find the sample data.
PS: i am not good in VBA or writing codes.
Thanks in advance,
Nija
I have a data where in i have five main heads (qtr, dates, cadre, SLA & actual days), Now i want to prepare a chart in which the X-axis shows either the QTR or dates and the Y-axis shows the actual days. Also i want a straight line for both Regular and FTC SLA's ( 60 and 45 each) on the Y-axis. I prefer to show the actual days as a separate line charts for Qtr-2016 and Qtr-2017 Attached please find the sample data.
PS: i am not good in VBA or writing codes.
Thanks in advance,
Nija