VehiclesFashionRecipesBlogsHuntTravelsSportFunHandmadeITEducation
Mini-Games
x

x
zakruti.com » IT - Software » IT, programs, coding
Excel Actual v Target Charts - My Online Training Hub

Excel Actual v Target Charts - My Online Training Hub

FBTwitterReddit

video description

Rating: 4.0; Vote: 1
Excel Actual v Target Charts - My Online Training Hub 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. Download the Excel file here: https://www.myonlinetraininghub.com/excel-actual-vs-target-chart
Date: 2022-04-08

Comments and reviews: 8


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.

reply

Hello! Love this video, thank you for sharing. Is it possible to create an actual v target for two separate years inside the same chart. For example, let's say I wanted to compare how I did in 2020 to how I am currently doing in 2021?
reply

My question is not with this video but one of your previous videos where you represented events on same chart as data, please I tried it in power bi but didn't get it right can you please help me out ??
reply

can you get one bar to be smaller in width than the other bar when you overlap them? If you target bar is 2'' wide, can you make your actual 1'' wide? i can not get them to have different bar widths
reply

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

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

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

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

reply
Add a review, comment






Other channel videos