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...
Excel Variance Charts: Making Awesome Actual vs Target Or Budget Graphs – How To
In this tutorial we are learning how to make an awesome variance chart in Excel that clearly plots actual and target (budgeted) figures using bars and variances (favourable and unfavourable) with arrows so beautifully that...
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 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...
Excel Actual Vs Target – Multi type charts with Subcategory axis and Broken line...
Last time when we learnt about multi-category axis we saw how meaningful chart can become. But today we are going to add in more flavours and ingredients to it and by the end of this...
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...
Excel chart of Top / Bottom “N” values using RANK() function and Form controls
Ever fancied that you have large set of data and from it you can have a chart of top or bottom N values and better yet you have the ability to switch between chart...
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...
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...
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...