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(…)
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!
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(…)
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!
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(…)