RAG (Red-Amber-Green) Analysis Chart in Excel || Line Chart with RAG Background

[@francescopugno4681]

Thank you very much...WOW LOOKS FANTASTIC, just added to my first dashboard, together whit the "speedometer" quality graphic made whit your tutorial

[@PKAnExcelExpert]

Glad it helped!

[@adnanozkara3576]

Excellent “ chart Master”

[@PKAnExcelExpert]

Thanks

[@adnanozkara3576]

Dear PK, I have a task to manage. There is a restaurant with 3 shifts ( Breakfast, Lunch, Dinner) and it is producing sales in the different departments in different days ( Monday to Sunday), I would like show in PP , for every day of the week sales of each department adding and at the end of Sunday dinner reaching to weekly sales figures. It needs to be annimated. Monday Breakfast, Monday Lunch, Monday Dinner, addiing on Monday Column, than passing on Tuesday and so on. Also one colunm showing all the days total to give total weekly sales. From that point on i would like show how this sales is spent on Cost of Goods, Labour, Building Expenses, Operating expenses. I would like show. For example net sales is 20K ( starting point), 5K spent on cost of goods ( left 15K), thand 6K spent on Labour, 9K let, than 8K spent Building Expenses 1K left, than 6K spent on OE and -5K left. I am trying to teach some young people the concept of Ebitda. I have learnt a lot from you, I wonder if you could take on this challenge. Best

[@fernandoperes5164]

Tks My Master!!! It is wonderful ...Very impressive!!! Great work!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@aymenbaraket7144]

Very good one, thank you

[@PKAnExcelExpert]

Most welcome

[@info2satish]

I bet this video deserves tonnnns of likes!!😁

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@abdelhadia8712]

Thanks a lot Professor

[@PKAnExcelExpert]

Most welcome

[@mk310174]

This is incredibly useful. Thank you sir.

[@PKAnExcelExpert]

Most welcome

[@cesarsaldana3429]

Thanks Master, It is wonderful, its very easy, Best Regards From Mexico.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Saatt79]

Stunning Chart....as usual awesome sir 👏 👏 👏 👏 👏

[@PKAnExcelExpert]

Thanks for your comments. Request you please share this with your friends and colleagues.

[@rickyrock311]

Thank you, its great.. How we add the text good, average and poor in the chart (is it done manually)

[@PKAnExcelExpert]

Thanks for your valuable feedback. You add data label then link data label with the text

[@ernestocornejo5338]

Great job, thanks for sharing

[@PKAnExcelExpert]

Thanks for your valuable feedback. Please share this with your friends and colleagues.

[@angadsingh9318]

Awesome sir thanks it will very very helpful for me🙏🙏🙏

[@PKAnExcelExpert]

Thanks Angad for your valuable feedback. Please share it with your friends and colleagues.

[@peternganga9371]

Thank you, PK. Very informative as always.

[@PKAnExcelExpert]

Thanks for your compliment. A humble request to share it with your friends and colleagues.

[@medkari]

THANK YOU MY BROTHER

[@PKAnExcelExpert]

Thanks for your valuable comments

[@Luciano_mp]

Cool man, nice. Thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@hafiznaseer1988]

Sir, Thanks its really beautiful

[@PKAnExcelExpert]

Thanks for your valuable comments.

[@sunilkumar-jl7uf]

very impressive.

[@PKAnExcelExpert]

Thanks for your compliment

[@khaledsaleh8604]

good job mr pk

[@PKAnExcelExpert]

Thanks for your valuable feedback. A humble request to share it with your friends and colleagues.

[@mohankumar-lc3pm]

Thank you.....

[@PKAnExcelExpert]

Thanks for your valuable comments

[@sharifmumu]

Great! How can I put legend for Poor Average and good color

[@shaikhzahid2363]

Hi PK, I hope you are doing awesome, I have questions that, I am making a line chart where I have a data in % form but I don't know why my charts axis going beyond the 100%. My axis going going upto 400% however my data has maximum value as 100%. Please help asap if possible.

[@ca.lakshminarayanreddyjamb9087]

Awesome!!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback. Please share it with your friends and colleagues.

[@vimaltyagi6501]

Thanks sir it wonderful

[@PKAnExcelExpert]

Thanks Vimal for your comments. Please share it with your friends and colleagues.

[@vimaltyagi6501]

Definitely sir

[@PKAnExcelExpert]

Thanks Vimal for your kind support

[@dharmendrayadav-bw2gp]

Nice video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pandharinathjoshi6565]

Excellent sir Sir in ur video explanation left side Poor Average Good Not shows sir How can we add sir

[@naeemkubar4660]

Hello Dear Teacher, Please Teach us how to make Matrix correlation Bubble graph. thanks in advance

[@tebogotsimane6179]

My example is not working. For example, my values are from 3 to 12 and with Red being from 9 to 12 and Amber from 6 to 9 and Green from 3 to 6. I don't seem to get the correct maximum and minimum bounds in the Y-axis. I want the minimum to be 1 and the maximum to be 15. When I set the bound to these values, I end up with one colour instead of three.

[@pamulurianu4504]

Can u pls upload about data extraction nd data cleansing tools in excel

[@hafiznaseer1988]

Kindly possible to make such P&L DASH BOARD REPORT

[@PKAnExcelExpert]

Sure. I will try to make such video.