Dynamically Highlight data points in Excel charts using Form Controls
Charts and graphs and other visual means make information easier to understand and analyze. Excel gives plenty of options in this department as different types of graphs are possible.
But in some cases wrong chart types in...
Making Sales Dashboard using Excel Slicers – How To
So many reasons why not to hate Excel dashboards. They are beautiful, they are dynamic, they make everything super easy to understand. And not to mention it one cool way to grab attention at...
Making Horizontal Dot Plot or Dumbbell Charts in Excel – How To
Dumbbell charts also called connected dot plot or DNA chart or lollipop charts are not available as builtin charts in Excel by default. But they prove awesome visual aid in certain situations. A great...
Add a vertical line to Gantt Chart or Stacked Bar Chart in Excel –...
In last tutorial on gantt chart in Excel for project managers we learnt the simplest and fastest way to chart project activities/tasks. Today we are learning how to add a vertical line on the...
Making BCG Matrix in Excel – How To
BCG matrix is a strategic decision making technique that helps in resource allocation among different cost centers or cost objects by categorizing or ranking them based on their ability to generate cash inflows against...
Gantt Chart in Excel – How To + Free Template + Online Gantt Chart...
Gantt chart is the simplest-most effective visual for planners and project managers. The most favourite tool to make gantt charts is Excel for two reasons:
we curate data in Excel and;
Excel stacked bar...
ABC Inventory Analysis using Excel Charts
Earlier this month we learnt how to carry out ABC inventory analysis in Excel using conditional formatting technique. It was easy and we had loads of fun as we not only understood how to...
Create Waterfall Charts in Excel – Visualize Income Statements!
A waterfall chart in Excel is a great way to visualize running totals making it super easy to understand how addition and subtraction of values affected starting value and how we reached the final...
Highlight instances in Excel charts in different colors with shaded bars in background
Suppose you have a variance chart and want to highlight those that require inquiry. Further suppose that you have two levels of inquiry:
Variances that require moderate inquiry (highlighted by for example green color)
Variance...
Making Interactive Charts in Excel [How To]
Graphs and charts are amazing tools to understand the information in the blink of an eye. It not only saves you from reading at all levels. That is why charts and Excel is one...