charting

Episode 590 – Rolling Charts

               

Say that you need to show a rolling 6 month chart. Usually, I show how to drag the blue outline around the source data. However, in today’s podcast, Kirk offers an alternative tip – include all of the columns in your chart and hide/unhide the columns that you want to appear in your chart. Episode(…)

Episode 469 – Organizing Chart Data

               

Our guest host today is Jon Peltier. Jon maintains an excellent set of charting examples at http://peltiertech.com/. In today’s podcast, Jon discusses the best way to organize your data for charting. Episode 469 shows you how.

Episode 456 – Chart Resizing Problems

               

Dan from Akron notes that when he inserts new columns in Excel, Excel is automatically extending the size of any charts that happen to span the new column. With most objects, you can right-click and indicate that you don’t want to move or size with cells. However, charts don’t seem to have the ability to(…)

Episode 444 – Overlay Charts

               

In a recent charting challenge, Jerome Sullivan sent in an interesting chart where the budget and actual numbers were actually plotted on top of each other. Episode 444 shows the non-intuitive steps required to create this type of chart. This blog is the video podcast companion to the book, Learn Excel from MrExcel and Charts(…)

Episode 442 – Combo Chart

               

How to create a combination chart that includes both stacked columns and a line chart. Episode 442 shows you how. This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Learn Excel from MrExcel