charts

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!

Episode 388 – Org Charts

               

Create an Org Chart in Excel. The org chart tool is hidden behind an obscure icon on the drawing toolbar. The details of using the tool are a bit complicated. Episode 388 shows you how to create an org chart. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download(…)

Episode 385 – Target Diagrams

               

Create a target diagram in Excel, using the business diagramming tools on the Drawing Toolbar. Episode 385 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 of the 277 tips from the book!

Episode 374 – Logarithmic Scale

               

If you need to create a chart where each series contains both small and large numbers, it will be difficult to see the detail for the smaller numbers. Allow the chart to show detail of both the small and large numbers by using a logarithmic scale. Episode 374 shows you how. This blog is the(…)

Learn Excel from MrExcel