Target Charts

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

 

DOWNLOAD BOTH CHARTS

 

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..

 



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI