Cropped chart: when some values are too big to fit
We know that column charts are excellent for presenting information. But what if some of the columns are too tall and hijacking the rest. In a previous article, we discussed few of the approaches. Today let’s learn how to build a cropped chart (broken y-axis chart) using Excel, something like above.
Looks interesting? Read on.
Make a quick funnel chart in Excel to track sales performance [video]
Funnel charts are useful to visualize sales & marketing performance. In this brief video, let’s understand how to make a quick funnel chart in Excel.
Read on to learn how to make funnel charts & to download a template for your funnel analysis needs.
Give descriptive titles to your charts for best results
Here is a simple & effective tip on charting.
Give your charts descriptive & bold titles.
How to set up title that are smart & descriptive?
Simple, follow below steps.
- Create the title you want in a cell
- Select the chart title
- Go to formula bar, press = and point to the cell with title
- Press enter.
A simple trick to make your dashboards user friendly [video]
Whenever you have a dashboard that is quite long or spans across multiple worksheet tabs, it can be hard to use. Here is a simple trick to make your dashboards user friendly. If your dashboard has form controls, create duplicate sets of them and place them in locations where users are looking. For example, If your […]
In-cell 5 star chart – tutorial & template
Whenever we talk about product ratings & customer satisfaction, 5 star ratings come to our mind. Today, let’s learn how to create a simple & elegant 5 star in-cell chart in Excel. Something like above.
Read on to learn how to create the above chart.
Work with charts faster using selection pane & select object tools [quick video tip]
Working with multiple charts (or drawing shapes / images) can be a very slow process. But here is a secret to boost your productivity.
Use selection pane & select object tools
Selection Pane & Select Objects?
If you have never heard of these, don’t worry. These are 2 very powerful features hidden in Excel. Once you know how to unlock them, you will never look back.
How to use selection pane & select object tools to work with charts faster – Video
In this video, understand how to use these powerful features to work with charts faster.
Make bar charts in original order of data for improved readability [charting tip]
To make friends in a new town hit the bars – Old saying.
To make sense of a new data-set, make bar charts – New saying.
Bar charts (or column charts if you like your data straight up) are vital in data analysis. They are easy to make. But one problem. By default, a bar chart show the original data in reverse order.
See the above example.
Unfortunately, we humans read from top to bottom, not the other way around.