peltier tech utilities
Learn how to create Excel dashboards.

Categories

30 Excel Functions in 30 Days

Archives

The Perfect Month for a Polar Chart

Have you ever made a Polar Chart in Excel? Or are you like me, and only have a vague idea of what a Polar Chart is (or no idea at all)? I've made thousands of Excel charts over the years, but never made a Polar Chart.

Excel MVP, Andy Pope, has just released a new version of his free Polar Chart add-in, and here's an example of the charts it can create.

Andy's add-in looks intriguing, and he carefully explains how it works, and describes all the option settings.

You can download the add-in for Excel 2007 or Excel 2003, and there's also a sample workbook with data.

However, Andy has created this add-in for people who already know what a Polar Chart is, and what it's used for. The only clue as to what a Polar Chart does is in Andy's description of the data, "The data

Continue reading The Perfect Month for a Polar Chart

December 7th, 2009 | Category: Excel charts | 6 comments

Excel VBA: Switch Column Headings to Numbers

It's Friday, and your brain is almost full, but let's try to cram a little bit of Excel VBA in there before the weekend.

We've talked about the Excel Column Headings before, and seen how to change the Reference Style setting from R1C1 (Numbers) to A1 (Letters). That setting is pretty well hidden, and it's a bit of a pain to switch on and off.

We'll create a macro that will let us quickly switch from A1 to R1C1, or from R1C1 to A1.

Step 1: Record a Macro

To see the Excel VBA code that changes the setting, we can use the Excel Macro Recorder.

Turn on the Macro Recorder Name the macro, ToggleR1C1, and store it in the Personal Macro Workbook With the Macro Recorder on, turn the R1C1 reference style on, then turn it off Turn off the Macro Recorder Step 2: View the Recorded Excel VBA

Continue reading Excel VBA: Switch Column Headings to Numbers

December 4th, 2009 | Category: Excel VBA | 7 comments

Excel Advent Calendar

[Note: There is a newer version of the Advent calender published Dec 1, 2010]

Okay, it's a day late, but here's an Advent calendar that I built in Excel.

Click on one of the numbered shapes, to reveal the Christmas picture behind it.

You can cover the shape again, by clicking on the border of the numbered shape.

And since you probably can't be trusted, there's built in cheat protection, so you can't uncover the days ahead of time. ;-)

Download the Advent Calendar

If you'd like some help in counting down the days till Christmas, you can download the Excel Advent calendar. It's created in Excel 2007, and you can open it in Excel 2003 if you have the file converter installed.

If you're planning your Christmas activities, you can download the Excel Christmas planner too.

The Return of Excel Twitters

In other exciting news, the

Continue reading Excel Advent Calendar

Related Posts Plugin for WordPress, Blogger...
December 2nd, 2009 | Category: Excel Formulas | 4 comments
« Newer Entries