Enable or Disable Excel Data Labels at the click of a button – How...
Data labels in Excel charts can help users to get the information right at that spot without referring to any other source of information....
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....
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...
10+ ways to make Excel Variance Reports and Charts – How To
Whether it is daily life thing or any day at work, we are always comparing to see whats good and what is not so...
Make Waffle Charts in Excel using Conditional Formatting – How To
To get the inspiration for better charts and Excel dashboards one must be observant of such pieces of information that are often found in...
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...
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...
Budget vs Actual Variance Reports with “In the Cell Charts” in Excel
In life we all want to be in control. And usually we measure or judge whether things under control by comparing whats happening with what should be...
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...
How to show data of hidden rows/columns in Excel Charts
By default if you hide a certain row or column of a data on which a chart is based, Excel will automatically hide that...