charts

Episode 888 – WIIW – 2 Axes Chart

               

Rick asks how to set up a chart with two different orders of magnitude. This was a built-in chart type in Excel 2003, but it is harder in Excel 2007. In today’s Where Is it Wednesday edition, we will take a look at how to create a chart showing series with different orders of magnitude.(…)

Episode 821 – Dual Histogram

               

Erika from Arkansas asks how to create a dual histogram. These charts are great for comparing the skew of answers between two categories such as male vs female. Episode 821 shows you how to create this chart. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new(…)

Episode 801 – Stacked Chart Labels

               

How to add a the total of the stacked columns at the top of the chart. This is obscure but possible in Excel 2003, but as Episode 801 shows, it is maddeningly impossible to do in Excel 2007. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a(…)

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 683 – Chart >4%

               

Odelia is trying to create a pie chart with only the values greater than 4% of the total. Episode 683 shows one method for solving this problem. 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(…)

Learn Excel from MrExcel