No video :(

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

Подписаться 274 тыс.

Просмотров 27 тыс.

50% 1

#RAGAnalysisChart #LineChart
Hello Friends,
In this video you will learn how to create a RAG (Red, Amber and Green) analysis Chart. We have created a dynamic RAG background in the chart and then we have displayed a Line chart on it.
Click here to download the practice file-
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-m...

Опубликовано:

24 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 56

@adnanozkara3576 4 месяца назад

Excellent “ chart Master”

@PKAnExcelExpert 4 месяца назад

Thanks

@adnanozkara3576 4 месяца назад

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

@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!

@fernandoperes5164 4 года назад

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

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@info2satish 5 лет назад

I bet this video deserves tonnnns of likes!!😁

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback.

@cesarsaldana3429 4 года назад

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

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@abdelhadia8712 3 года назад

Thanks a lot Professor

@PKAnExcelExpert 3 года назад

Most welcome

@peternganga9371 5 лет назад

Thank you, PK. Very informative as always.

@PKAnExcelExpert 5 лет назад

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

@mk310174 3 года назад

This is incredibly useful. Thank you sir.

@PKAnExcelExpert 3 года назад

Most welcome

@aymenbaraket7144 Год назад

Very good one, thank you

@PKAnExcelExpert Год назад

Most welcome

@medkari 5 лет назад

THANK YOU MY BROTHER

@PKAnExcelExpert 5 лет назад

Thanks for your valuable comments

@angadsingh9318 5 лет назад

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

@PKAnExcelExpert 5 лет назад

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

@Saatt79 5 лет назад

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

@PKAnExcelExpert 5 лет назад

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

@ernestocornejo5338 5 лет назад

Great job, thanks for sharing

@PKAnExcelExpert 5 лет назад

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

@ca.lakshminarayanreddyjamb9087 5 лет назад

Awesome!!!!

@PKAnExcelExpert 5 лет назад

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

@hafiznaseer1988 5 лет назад

Sir, Thanks its really beautiful

@PKAnExcelExpert 5 лет назад

Thanks for your valuable comments.

@mohankumar-lc3pm 5 лет назад

Thank you.....

@PKAnExcelExpert 5 лет назад

Thanks for your valuable comments

@sunilkumar-jl7uf 5 лет назад

very impressive.

@PKAnExcelExpert 5 лет назад

Thanks for your compliment

@Luciano_mp 5 лет назад

Cool man, nice. Thank you.

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@dharmendrayadav-bw2gp 5 лет назад

Nice video

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@pandharinathjoshi6565 9 месяцев назад

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

@vimaltyagi6501 5 лет назад

Thanks sir it wonderful

@PKAnExcelExpert 5 лет назад

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

@vimaltyagi6501 5 лет назад

Definitely sir

@PKAnExcelExpert 5 лет назад

Thanks Vimal for your kind support

@khaledsaleh8604 5 лет назад

good job mr pk

@PKAnExcelExpert 5 лет назад

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

@rickyrock311 5 лет назад

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

@PKAnExcelExpert 5 лет назад

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

@naeemkubar4660 5 лет назад

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

@tebogotsimane6179 3 года назад

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 5 лет назад

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

@sharifmumu 4 года назад

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

@shaikhzahid2363 5 лет назад

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.

@hafiznaseer1988 5 лет назад

Kindly possible to make such P&L DASH BOARD REPORT

@PKAnExcelExpert 5 лет назад

Sure. I will try to make such video.