charting

Episode 815 – 801 Chart Redux

               

I was pretty happy with my tricky chart back in Episode 801, but couldn’t find a way to be tricky in Excel 2007. Today, both Eddie and Ricardo send in brilliant ideas to get the sum of three stacked columns to appear on top of the stack of columns. Episode 815 shows you how. This(…)

Episode 800 – Chart Conditional Formatting

               

Johann from Mexico City sends in a cool tip for creating charts that seem like they use conditional formatting to color the columns. Episode 800 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 workday to learn one(…)

Episode 783 – Hide Zeroes

               

Back in Episode 767, the pod dealt with the problem of using =IF(ISBLANK(A2),””,A2) to hide zero values in the results table. Today, Rene and Denis both write in with a far simpler solution. Episode 783 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a(…)

Episode 778 – Interative TextBox

               

One of my favorite tricks is to fill a textbox with the result of a formula in the worksheet. When you try this as the title in an embedded chart, you need to change the formula to point back to the original worksheet. Episode 778 shows you how. This blog is the video podcast companion(…)

Episode 776 – Interactive Chart

               

Lucy asks how to make a chart interactively change from red to yellow to green based on an external selection. In today’s Episode 776, we take a look at the basics of setting up such a chart. Tomorrow’s episode will take a look at the Options button on the Form toolbar to enhance the chart.(…)

Learn Excel from MrExcel