Category Archives: Chart

Add Data Labels for Total to Stacked Columns in #Excel

Posted on September 14, 2019 by MF

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?

Posted on July 6, 2019 by MF

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

Posted on May 18, 2019 by MF

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…

Posted on February 17, 2019 by MF

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

Posted on July 26, 2017 by MF

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

Posted on July 22, 2017 by MF

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

Posted on July 15, 2017 by MF

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]

Posted on March 4, 2017 by MF

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?

Posted on February 25, 2017 by MF

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”?

Posted on October 2, 2016 by MF

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