charts

Episode 641 – Conditionally Summing

               

Patrick asks how he can summarize his monthly time sheet to create a pie chart by department. Using the SUMIF function provides the step to make this relatively easy. Episode 641 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every(…)

Episode 634 – Dragging Chart Points

               

Did you know that you can change numbers in the underlying worksheet by dragging points on a chart? This might be an interesting trick to allow someone to adjust their forecast projections. Episode 634 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two(…)

Episode 609 – Hiding Chart Rows

               

When you hide a row, Excel will remove that series from a chart. In Episode 609, I create a hideous chart, but then use an AutoFilter to create a cool ad-hoc charting tool that allows a sales manager to see results for any one sales rep. This blog is the video podcast companion to the(…)

Episode 606 – Histogram

               

To create a true histogram from frequency information, you need to make the columns in the chart touch each other. This was difficult to do in Excel 2003 but much easier in Excel 2007. Episode 606 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a(…)

Episode 604 – Breaking Charts

               

Do you have a chart which is too confusing? Try replacing the one chart with four smaller charts, each chart focusing on one particular statistic. Episode 604 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one(…)

Learn Excel from MrExcel