Excel Actual Vs Target Chart - Conditional Formatting & Dynamic Target | FREE Download

Thanks for this video, I want to know if I have many target point

Thanks so much for your video sir

This is the best explanation of this "issue" and how to plot some data, to compare them but with target (border) line, especially because of this dynamic part of it where you are using =COUNTA function, YET! With due to respect to other MVPs and other people with tricks, but this is like 100% what I was looking for. Crazy, and especially useful, you earned subscriber more.

How do I stack columns for only two values out of the 4, like for Profits column and Targeted Profits column? The other columns are Sales and Costs which I don’t want to stack. Thanks.