Contextures

Contextures News

Make a Marimekko Chart in Excel

December 13, 2016

Marimekko charts, and more, in this week's Excel news. This will be the last newsletter for 2016, and I'll see you again in January. My Excel website will be open during the holidays though, so you can still find Excel tips, tutorials and videos.

Marimekko Chart

Excel has added some fancy new chart types recently, but it still doesn't have a Marimekko chart. That chart type shows one set of percentages in its column widths, and another set of percentages in the block heights.

To build one in Excel, you can use a special layout for your data, and add a list of percentages at the left. Then, build a Stacked Area chart, and change the X-axis to the Date format. You can see the detailed instructions on my website. I tried to keep it as simple as possible!

And if you have a copy of Jon Peltier's Excel chart utility, it has a command to build a Marimekko chart.

marimekko chart 01

Column Header Letters

Why do the Excel column headers show numbers sometimes, instead of letters? And, if you click on a formula cell the references look strange too. For example, you'll see RC[-1] instead of D2.

When you open the first workbook in an Excel session, that workbook's reference style is used for all the other workbooks that you open, later in that session. You can go into Options > Formulas, and change the setting, to go back to the A1 style, instead of R1C1. See the details in my blog post.

If you need to change the reference style very often, follow my instructions for recording a macro, and add that to the Quick Access Toolbar. Or, use the Toggle Ref Style command in my PPP or Excel Tools add-ins

column header numbers

Your Feedback

WEEKNUM Function: Thanks to Scott H. who reminded me that you can use its second argument to control which day the week starts. I added a new WEEKNUM section on my Date Functions page, to show how that works.

Organizing Excel Files: Thanks again for sending your tips, and you can click this link to read the article on my blog.

Excel Articles

Here are a couple of Excel articles I read recently, that you might find useful.

Spreadsheet History - Watch Dan Bricklin give a 12-minute talk about the creation of VisiCalc for the TEDxBeaconST event. (Level - All)

Excel Song - Here is the latest Excel song from Clint Tuttle, to add a bit of fun to your day. It's a parody of Justin Timberlake's "Can't Stop the Feeling", and has cameos from Mr. Excel, Mynda Treacy, and several other Excel fans. (Level - All)

Excel Dashboards - Registration for Mynda Treacy's Excel dashboard course closes this Thursday, Dec 15th, at 8pm (Pacific time zone). You can also watch a replay of her free Excel Dashboard webinars.

Also, see all my Excel products. on my Contextures website.

Christmas Village Update

My grandson came to visit, and he helped make some final adjustments to my Christmas village. The finishing touch was a night sky backdrop, complete with the Big Dipper. We put up the tree too, so now we're officially ready for the holidays. Well, except for all the cooking, baking and wrapping, but how long could those small tasks take?

If you're celebrating, I hope you have a wonderful holiday season with family and friends!

weekly photo

That's it for this week! If there are topics that you'd like to see covered in future emails, please let me know.

Debra
ddalgleish @ contextures.com

P.S. You can choose to get the full Contextures news package (news and occasional special announcements), or the basic news package (news only). Click either link to change your news option.

Note: I am an affiliate for some of the products mentioned in this email, and earn a commission on the sales.

 

Search Contextures Sites

Excel Data Entry Popup List

 

 

 

 

Last updated: March 15, 2017 11:55 AM