Archive for February, 2009
In How Many Links are Too Many Links, O’Reilly radar shows us this unfortunate bubble chart. Read the rest to see why the chart is unfortunate.Continue »
Ever since we made a switch to Microsoft Office 2007 at work, this has been bothering me.”How to change one shape to another?”
This is very useful feature, especially when you are using PowerPoint.Continue »
As promised earlier, here is our next interview. PHD will be interviewing John Walkenbach, prolific Excel author and MVP. Please suggest your questions and help me get a killer interview from John.Continue »
Pie charts are one of the most used charts in the world. And for obvious reasons: they are simple to create and easy to understand. When it comes to pie chart, I have no clear opinion. Part of me says use them, the other says avoid them.
What is your opinion on Pie charts ?Continue »
Remember Robert, he is the author of the popular KPI Dashboard Series of posts on this blog. Now there is good news, he started a blog and writes about information dashboards, data visualization.Continue »
Trust Peltier to come up with solutions for even the most impossible looking charts. Today he shares a marimekko chart tutorial. I couldn’t sit still after seeing his post. So here comes market segmentation charts or marimekko charts using,
Google Spreadsheets team has introduced another very useful feature to their online excel competitor: Data Validation.
Although the data validation is not as robust as that of Excel’s, it provides basic validations pretty neatly.
So you have built that excel report your boss wanted. And you were all eager to use the spreadsheet in your presentation. But in the last minute, your boss asked you to change average sales to total sales figures. You also want to grab an espresso before rushing to the meeting. Now what?Continue »
Learn how to create Table of Contents in Excel and other tricks to manage when you have too many worksheets.Continue »
Checkout this very neatly done “where did all the money go?” data visualization on Guardian, and share your opinion.Continue »
Reader Raja asks about “how he can reset the colors in his workbook”. Read more to find out how you can fix this problem.Continue »
As part of our spreadcheats series, we will learn how you can use data filters to create dynamic charts in Microsoft excelContinue »
Okay, time for totally shameless self promotion, call me a bragging blogger, but I don’t care, not today. Because I am very happy to receive this e-mail from one of our readers. Click to read more.Continue »
This week, check out the updated excel downloads page and 5 interesting excel articles from around the web. Read more to learn about a mouse trick to paste values, how you can tweet from excel using user forms, an intuitive charting principle and more.Continue »
My Friend and long time Microsoft Excel MVP, Jon Peltier has released a wonderful little excel charting utility called Cluster Stack Chart Utility. Out of curiosity I have mailed Jon and asked him if he could send me a copy of it so that I can review the product and recommend it to PHD reader community. He is kind enough to mail the add-in to me and here goes my review of the tool.Continue »