Target Charts in Excel – Video Tutorial

With the Indian financial year end approaching, there could not be a better time to talk about target charts.

Although, I can’t help you much with your business targets but I can help you create stunning target charts. I promise they’ll look stunning even if  your targets are not met. And that was a Joke! 😆

Let’s begin with 2 different types of target charts

Target Chart Type 1 : A common target for all values

Links and Resources

1. How to write an IF Statement in Excel
2. Charting Basics – Part 1
3. Charting Basics – Part 2
4. Charting Basics – Part 3
5. How to pick up a right color for your chart
6. How to make a chart in 1 key stroke

Target Chart Type 2  – unique targets for all values

Links and Resources

1. How to customize markers in a chart
2. How to add totals to a stacked chart

More Advanced Charts for You

1. Highlighting parts of a stacked chart – for making it more meaningful and readable
2. Indian Republic Day Visualization
3. Dynamic Bubble Chart Matrix with Scroll Bars
4. World’s Biggest Economies – Economist Chart Reworked
5. Advanced Stock Ticker Chart in Excel 

Would love to read your comments..