charts

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 666 – Clustered Columns

               

Rodney asks how Excel can make a clustered column chart. While it is not immediately obvious, it is relatively easy to do. Episode 666 shows 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(…)

Episode 656 – Negative Charts

               

Chris from Long Island asks how to conditionally format the negative items in a chart. Episode 656 shows two methods for handling this. 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(…)

Episode 648 – Changing Numbers Graphically

               

Steve asks if he can build an Excel worksheet where people can change numbers by dragging a graphical element. Episode 648 shows you how you can use a chart in previous versions of Excel to solve this problem. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new(…)

Episode 643 – Excluding Zero Values From Pie Charts

               

Patrick wrote in to address my answer from podcast 641. In that podcast, I used a SUMIF to create a pie chart of hours spent by department. Patrick notes that early in the month, many of the departments have 0 values and would like those excluded from the chart. In Episode 643, I set up(…)

Learn Excel from MrExcel