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...
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 newspapers and the internet. For that matter, Pinterest and The...
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...
Conditional Charts in Excel – Workaround + How To
Last time we learnt how to make simple dial charts. There is so much to be discussed as basics to Excel charting but without little fun and doing out of ordinary is what everyone...
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...
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 data too. I must confess that I was quite annoyed...
Creating Excel charts with Subcategory axis – [Quick Tip]
This is definitely a neat trick. Usually we have single X-axis chart element. But you can have multi-category axis to show the information in a much more arranged manner. Following is what we are after....
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...
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...