All Posts by Sumit Bansal

6 KPI Dashboard in Excel [Part 2 of 3] – Dynamic Interpretation from Scatter Chart

This tutorial is a part of a three part Excel KPI Dashboard tutorial series: KPI Dashboard in Excel – Part 1: Dynamic Scatter Chart. KPI Dashboard in Excel – Part 2: Dynamic Interpretation. KPI Dashboard in Excel – Part 3: Dynamic Data Extraction + Bullet Chart. In the previous article of this 3 part ‘KPI […]

Continue reading

22 KPI Dashboard in Excel [Part 1 of 3] – Dynamic Scatter Chart

Watch Video – Creating KPI Dashboard in Excel – Part 1/3 Learn the exact steps I take to create World Class Dashboards in Excel. Join the Excel Dashboard Course. A KPI dashboard is one of the most used dashboards in business. It’s primary objective is to show the performance of key KPIs and provide a comparative view […]

Continue reading

5 How to Create Dynamic Chart Titles in Excel

Do you suffer from Forgot-to-change-chart-titles syndrome? I do. Worry not. Today’s prescription include an article and a video on how to create dynamic chart titles in excel. Linking a Cell Value to the Chart Title Suppose you have the data as shown below and you have created a chart using it. If you want to […]

Continue reading

7 Dynamic Charting – Highlight Data Points in Excel with a Click of a Button

A chart gets difficult to read if it has a lot of data plotted on it. While it is a good practice to plot only the relevant data, there are situations where you need to show a lot of data points on a single chart. If you are stuck in such a situation, it is a good […]

Continue reading
1 2 3 19