charting

Episode 770 – Moving Average

               

Chart a moving average in Excel. Episode 770 will show you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 737 – Excel 2007 Charts

               

Lorin asks if there is anything new in Excel 2007 charts. While Microsoft rewrote the charting engine in Office 2007, you still have the same basic chart types. However, there are new data visualization tools in conditional formatting that allow you to add bar charts to every cell. Episode 737 discusses these new features. This(…)

Episode 684 – Bar of Pie

               

In a second attempt to solve Odelia’s question from yesterday, I use a bar of pie chart to automatically move all of the pie wedges less than 4% to a secondary chart. Episode 684 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new(…)

Episode 674 – Negative Invert

               

Ute from Germany sends in a better way to show negative points in a column chart in a red color. His cool trick works for Excel 97-2003. Episode 674 will show you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every(…)

Episode 591 – Missing Dates

               

When you create a chart from data that might have missing dates, you might want Excel to plot the missing dates along the horizontal axis. In Episode 591, we take a look at why Excel sometimes chooses to use a time scale and sometimes does not. This blog is the video podcast companion to the(…)

Learn Excel from MrExcel