Making a Slope Chart or Bump Chart in Excel – How To

Excel has many different styles of charts and graphs inbuilt and one can make them with a single click. A great convenience to have. But for charts and graphs convenience is required, merited and...

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

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

Creating and Working with Dynamic Charts in Excel

Title should be "making charts dance to your command in Excel" but lets keep it technical :) OK let me be very quick at it as I learnt about this almost by chance. I used...

Custom Data Labels with Colors and Symbols in Excel Charts – [How To]

Is it possible to have colored data labels like red for negatives and blue or green for positive values inside excel chart? This question was asked by some when I posted Variance Analysis in Excel – Making better...

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

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

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

Moving X-axis labels at the bottom of the chart below negative values in Excel

By default if you insert a bar chart or line chart, the x-axis labels are stuck at 0 position of the axis. This usual behaviour gets in the way especially if you have negative values...