Make a Dynamic Chart using Data Filters
As part of our spreadcheats series, we will learn how you can use data filters to create dynamic charts in Microsoft excel
Weekly Links – Even More Downloads Edition
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.
Colors in Chart Labels [Quick Tip]
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:
100 Excel Tips & Resources
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.
[Reader Poll] Stacked, Seperated or Mirrored ?
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
Why No One Likes Your Pie Charts (And What to Do About It)
9 charting tricks you can use to make your pie charts likable
What are the formulas you wish Excel had ?
Here is a list of formulas I wish MS Excel had. Alas, we need to build some work-arounds to solve them though.