All articles with 'MS' Tag

In this weeks edition, learn how to compare multiple items in a range using match, know how you can add more than one legend to a chart, include images in comments.

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.

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 ?

Learn how to create Table of Contents in Excel and other tricks to manage when you have too many worksheets.

Reader Raja asks about “how he can reset the colors in his workbook”. Read more to find out how you can fix this problem.

As part of our spreadcheats series, we will learn how you can use data filters to create dynamic charts in Microsoft excel

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.

A simple label formatting hack can improve the effectiveness of YoY change charts by adding color to differentiate positive vs. negative growth (or mediocre vs. sky rocketing growth rates). See this example:

Hurray, PHD blog crossed 2000 RSS Subscriber base. This is a very significant milestone for me.

To celebrate this occasion we have a mega post: 100 Excel & Charting Tips, Tricks and Resources for you.

Stacked bar charts are a popular way to depict 2 more series of related data, like sales of 2 products.But there are several ways to stack the bars in a bar chart. Here is a list of 6 ways to stack them

9 charting tricks you can use to make your pie charts likable

Here is a list of formulas I wish MS Excel had. Alas, we need to build some work-arounds to solve them though.

Sales funnel is a very common business chart. Here is a simple bar chart based trick you can use to generate a good funnel chart to be included in that project report.

Often when you use excel to track a particular item (like expenses, exercise schedules, investments) you usually enter the current date (and time). This is nothing but timestamping. Once the item is time stamped, it is much more easier to analyze it. Here is an excel formula trick to generate timestamps.

A combination chart is when you combine two different charts to make one. A popular example for combination chart is a line & bar graph combination.