Impress Your Boss with this Excel Actual v Target Chart Technique - Quick and Easy!

Показать описание

How to create Excel Actual vs Target or Actual vs Budget Charts as well as Actual vs multiple targets including Actual vs Forecast. These are sometimes called thermometer charts.

WHO AM I?
=========
If we haven't met yet, hi! 👋 I'm Mynda Treacy. I'm a CIMA qualified accountant turned Excel and Power BI trainer. In 2014, and every year since, I've received the Microsoft Most Valuable Professional award for my contribution to the Microsoft 365 community. I love sharing Excel and Power BI tips and techniques that will get you noticed and promoted. Follow me for a new video every week.

🎓LEARN MORE
==============

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

📢 Please leave me a COMMENT. I read them all!

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

Рекомендации по теме

Комментарии

CTRL + D! That's awesome. I was using CTRL + C, CTRl + V until yesterday. Thank you.

AjayAnandXLnCAD

Thank you Mynda, awesome job and nice video for actual vs target!!

leorc

Excellent tutorial Mynda. No idea this was possible in Excel. Thank you for taking the time to produce this plus your rest of your excellent tutorial videos. Really appreciate it!!

peterlambros

Thanks Mynda for these tips. CTRL+D - fabulous. No fill and outline colour is even better. I know how I am changing my budget chart today!

GrainneDuggan_Excel

This is great work. I was struggling getting the line you call "stretch target' here for ~30m - 1h... I started to think it was not possible... then I googled again you came up and my problem was solved. My graph now looks great, and I learned the CTRL +D trick... how have I lived so much of my life with out knowing CTRL +D?

Again, great work, thank you for putting your knowledge online! So helpful. Well done.

johnscallon

You are always delivering the best way to capture the whole idea

findthetruth

Every single tip you give is very fine and elegant ❤️....Thank you

felipe

Thanks Mynda you are just awesome you make Excel so easy.

awesh

Great tip! Any insights on how to produce something similar in PBI?

Iamjuanpabloespinosa

Thats a great visual solution! You make it look so easy to do! Thanks for sharing!

alm

Simple and very effective - Thank You for sharing such a great series of ideas with the rest of us. You are a great teacher!
Peter

RCTurbine

Awesome, cute, concise and simple to follow capsule!

amigoranjan

Mynda your content is always excellent. Thank you so much!

doxazo

I am so loving your channel! I am a huge fan of your job :)

Thaaaanks for everything you do ♥

ronelvargas

Hi Mynda.. thanks for these great tips.. especially CTRL+D to duplicate an object in one step.. excellent. Thanks for sharing. Thumbs up!

wayneedmondson