All articles with 'charting' Tag

Two most commonly asked or searched queries when it comes to charting are,

• How to combine two chart types in one chart, like a line chart combined with bar chart?
• How to add a secondary axis to the chart so that one or more data series are plotted on the secondary axis?

Watch this video tutorial to learn how to do both in less than 15 seconds.

Watch it on youtube: Creating combination charts and adding secondary axis – video tutorial

This column chart shows daily, weekly or monthly data depending on the user’s choice. In daily the columns are displayed properly, but in weekly & monthly mode the columns are a fraction of the width they should be – why, and how can this be avoided? Bonus points if you can describe how to use an INDIRECT formula on the x-axis labels which is another problem. Go fix it.

In this installment we take a look at Asset Allocation Chart that looks like it is hexed. Our reader DMurphy submitted this.

When you are making a chart next time, spend just 5 minutes (or even less) on the formatting and give more time (may be 20 minutes) to think about the story.

As mentioned earlier, I have met Garr Reynolds of presentation zen fame in Malmo, Sweden last Friday. What was to be a quick 15 minute interview became a 2 hour lengthy discussion on presentations, charting, excel, data, Japanese culture and of course our pointy haired dilbert blog. Read the entire interview in the post.

A very warm, cuddly and hugsy welcome to Pointy Haired Dilbert. I am happy to know that you are reading this. This is a blog about YOU becoming successful. It is all about understanding your data, making your charts better and improving the way you work using excel. Read this post to know more about this site.

Imagine having two annoying little bloggers looking over your shoulder and trying to mess up with the chart you are making…

I am still waiting, go ahead, imagine…

Now come back, that is exactly what “ChartBusters” is all about. Read more…

Ok, this is *totally* exciting. I am big fanboy of Garr Reynolds of Presentation Zen. His blog is one of the very first blogs I have started reading and I still read it whenever there is a new post. Few days back I saw on his blog that he is coming down to Malmo, Sweden for a keynote presentation at FBTB Conference. I am interviewing him on this friday. Please send me your questions by commenting or tweeting me on @r1c1.

Dot plots are a very popular and effective charts. According to wikipedia “Dot plots are one of the simplest plots available, and are suitable for small to moderate sized data sets. They are useful for highlighting clusters and gaps, as well as outliers.”

Today we will learn about creating in-cell dot plots using excel. We will see how we can create a dot plot using 3 data series of some fictitious data.

This post is a testament that readers of this blog are way cooler and enterprising than I am. Justin, who I must say, has some really amazing excel skills, contacted me in April with a VBA Script he made that can draw two circle venn diagrams in excel.

Gene asks me in an email, “I’m trying to graph candlestick charts in Excel for 10 minute candles. Excel seems to allow daily only with its stock templates. Can you point me to any resources for creating intraday candle charts?”. Of course, you can create intraday candlestick charts just the way you would create normal candlesticks, just change the axis options once you are done. Read the post to find more.

Do you know these excel 2007 productivity secrets? (1) How to turn on the clipboard pane so that you can do rapid copy pasting (2) How to lock a feature for repeated use (3) How to copy charts as pictures (4) How to features not on ribbon to the quick access tool bar (5) How to change the default file save settings so that excel always save files in earlier version and much more. Go ahead and read the secrets and become excel guru.

Here is a really fun and simple way to create dynamic charts in Excel. It uses data filters in an innovative way and creates the dynamic effect. To create the dynamic charts, just follow these 5 steps:

(1) Prepare your charts: Make as many charts as you want. Lets say 3.
(2) Set up the area where dynamic charts will be loaded: Just take 3 cells in a row and adjust the row height and column width such that the charts can be fit inside snugly. Also, type the chart names (1 for each cell) in the cell. Let us say, the charts you have are for Costs, Sales and Profits, just type these names in the cells.
Read more…

In today’s installment of “your week @ PHD” we will learn how to use array formulas to refine text search, a bunch of very useful keyboard shortcuts, and a very simple tip on how to get ready when you want to make a chart. All really juicy tips, so read on.

A good chart tells a story. Here is a fantastic example of what a good chart is. The chart itself is very simple and easy. But it brilliantly juxtaposes two interesting pieces of data : Obesity rates in countries and Time spent eating per day, to tell a story.