charts

Episode 555 – Thousands Display

               

Need to convert a report or a chart to display in thousands or millions? Episode 555 shows two different methods to achieve this result. 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(…)

Episode 538 – Overlapping 2007 Charts

               

Peter sends in a question that relates back to Episode 444. In that podcast, I showed how to change the gap width in Excel 2003 to have two columns stacked on top of each other. Peter wonders how to do this in Excel 2007. This is a great opportunity to show off a change in(…)

Episode 492 – Chart to PowerPoint

               

Bob from Dallas writes in with a question. Bob has created a chart in Excel and needs to copy the chart to a slide in PowerPoint. For those of you who never leave Excel, PowerPoint is a tiny little Add-In that Microsoft created to help Excellers when they need to make presentations. Although there are(…)

Episode 448 – Cone Chart Lies

               

Another popular way for people to lie with charts is to use a cone or pyramid chart. Episode 448 shows why your radar should go up anytime you see someone presenting data using these chart types. This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy and Charts and(…)

Episode 446 – PieChart Lies

               

Watch out when someone tips a pie chart backwards to show a 3-D perspective. They are either unintentionally or intentionally trying to misrepresent the data. Episode 446 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel and Charts and Graphs for Microsoft Office Excel 2007. Download a(…)

Learn Excel from MrExcel