Category Archives: Chart

Add Data Labels for Total to Stacked Columns in #Excel

When we create stacked columns in Excel, we exclude Total from the data as it may give an extra stack that we don’t want.¬† However, we may want a data label for Total on the stacked columns, like the one … Continue reading

Rate this:

Posted in Chart | Tagged | Leave a comment

How to sort bar chart in descending order?

Sound like a silly question, but it is a bit confusing indeed. One day, a friend asked me how to sort a bar chart in descending order.  I told her to sort the data. She replied: “I did.  The data … Continue reading

Rate this:

Posted in Chart | Tagged , | Leave a comment

Waterfall chart is just a few clicks away with #Excel 2016

Did you know, you can plot a Waterfall chart in #Excel in less than a minute…Provided that you are using Excel 2016 or later! ūüôā No Kidding! You may download a¬†Sample File to follow along.

Rate this:

Posted in Chart | Tagged , , | 1 Comment

A compelling chart in three minutes…

In business world, we often compare actual sales to various benchmarks such as budget, target, and last year. In this post, I am going to show you step-by-step how to make a compelling chart for this purpose. This is basically a simplified version of bullet chart, and is super-easy to create. I hope you find it useful and relevant. Continue reading

Rate this:

Posted in Chart | Tagged | Leave a comment

Interactive Chart is not difficult to make ‚Äď Part 3/3

Using Option Button to display different items on chart So far, we have made an interactive chart with check box to highlight items with negative growth; with scroll bar to see more items in a confined space.¬† In this post, … Continue reading

Rate this:

Posted in Chart, Excel Tips | Tagged , , | 1 Comment

Interactive Chart is not difficult to make ‚Äď Part 2/3

Using Scroll Bar to show more This is an extension of the previous post – Using Checkbox to highlight negative growth in a bar chart.¬† In that post, we had created a chart showing top 10 items, which allowed user … Continue reading

Rate this:

Posted in Chart, Excel Tips | Tagged , , | Leave a comment

Interactive Chart is not difficult to make – Part 1/3

Using Checkbox to highlight negative growth in a bar chart In previous post, we talked about the basic of Form Controls. ¬†I hope you had time to practice it and found useful way of building interactivity to your spreadsheet. In … Continue reading

Rate this:

Posted in Chart, Excel Tips | Tagged , , , | Leave a comment

Interactive Chart with navigation panel [NO VBA]

Isn’t it nice? ¬†Don’t think that this is difficult. ¬†No VBA is required. ¬†Indeed you only need to know a few Excel skills in order to create an interactive chart ¬†with navigation panel like this. The skills required: Conditional formatting … Continue reading

Rate this:

Posted in Chart | Tagged , , , , , | 3 Comments

Want some pies?

First of all, this blogpost is about Pie Chart, but not about how to make a Pie Chart. ¬†Indeed, I am not going to show the steps of making Pie Chart here. ¬† Also¬†I am not intended to discuss whether … Continue reading

Rate this:

Posted in Chart | Tagged , , | 2 Comments

What is a “Container Chart”?

First of all, I would like to thank¬†Chandoo for suggesting this name for the chart I submitted to him for a charting contest a few months ago. ¬†What’s more surprising to me is I was one of the winners of … Continue reading

Rate this:

Posted in Chart | Tagged , | Leave a comment