Introduction to Panel Charts using Excel – Tutorial & Template
In this article we will learn what a Panel Chart is and how you can construct a panel chart in Excel.
What is a Panel Chart?
A panel chart is a set of similar charts neatly aligned in panels to help us understand some data which has multiple variables in it. Panel charts are also called by names “trellis displays” or “small multiples”. They are an effective way to display multi-variable data.
Here is an example panel chart showing the total defects per module over the last 4 weeks.
How to hide “0” in chart axis [quick tip]
Have you ever wondered how you can hide that 0 (zero) at axis bottom? Like shown beside. You can use custom cell formatting codes (or custom number formatting codes) to do just that. Just go to axis formatting and from the number tab set the axis number format to something like #,##0;-#,##0;; Read the rest of the post to learn more.
What is the most embarrassing charting mistake you made? [weekend poll]
This week’s poll is very simple. What is the the most embarrassing charting mistake your made?
For me it has to be that one time when I made a sports dashboard using excel. I have adjusted the axis scale of a bar chart so that my favorite cricket player (Sachin Tendulkar, who else?)’s records are emphasized. In a matter of minutes I have received several comments from all over world pointing out the mistake. Even though, the intention was to highlight the achievements of master blaster, the axis adjustment was obviously a mistake.
Switch Rows and Columns in Charts [Quick Charting Tip]
Let us say you have built a nice chart showing your sales and profits for the top 5 products (learn how to highlight top 5 products in a list), with products on X axis. Suddenly your boss wants to switch the rows to columns (or transpose the chart) so that she can see metric level grouping instead of product level grouping. No need to freak out and rush to Espresso machine, You can do it very easily with Excel Charting features.
In today’s quick tip you will learn how to swap chart rows and columns in excel.
Make a Bubble Chart in Excel [15 second tutorial]
A Bubble chart displays circles (or bubbles) at given X and Y co-ordinates. Bubble chart is a very good way to show 3 dimensional data (for eg. Region-wise product sales) without confusing users. In this tutorial, we will learn how to create a bubble chart using excel.
Pareto Charts – How to do pareto analysis using Excel?
A Pareto chart or pareto graph displays the importance of various factors in decreasing order in columns along with cumulative importance in a line. Pareto charts are often used in quality control to display most common reasons for failure, customer complaints or product defects. The pareto chart is a great way to do the pareto analysis. Today, we will learn how to use excel to make a pareto chart.
Using Combo Charts to Group Related Time Events [Charting Goodness]
In his latest book, Now You See It, on pages 165 and 166 of the book, Stephen Few discusses how grouping related time intervals can facilitate analysis of data. As an illustration he explains that when viewing data of daily website visits, it helps in separating weekdays and weekends to differentiate expected traffic during these periods. The use of this technique would make it easier for the analyst to identify any anomalous movement in ether the weekend or the week day.
Fortunately excel combo charts can help you do that. In this guest post, Paresh explains to us how to do this.