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

Variance Analysis in Excel – Making better Budget Vs Actual charts

Either it is about daily life or business, we almost all the time in our minds comparing the actual results with our plans. Though we can talk numbers and percentages but the way charts...

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

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

Use Conditional Formatting to make Charts for Excel dashboards

To get the inspiration of better charts and Excel dashboards one must be observant of such pieces of information that are often found in newspapers and internet. For that matter Pinterest and The Economist...

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

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

Conditionally Format Chart’s Background in Excel – How To

Excel charting is in the air for last few weeks and we are learning some really cool tricks on making charts better looking and also fulfilling the purpose. Today we will learn how to...

Create Simple Dial Charts in Excel – How To

Charting or graphing is one of the biggest punch Excel has. Visual presentation of data greatly improves user's ability to comprehend the information and significantly cuts down the time to take decisions. That is...