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.
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.
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
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.
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)
Also, see all my Excel products. on my Contextures website.
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!
That's it for this week! If there are topics that you'd like to see covered in future emails,
please let me know.
ddalgleish @ contextures.com
Note: I am an affiliate for some of the products mentioned in this email, and earn a commission on the sales.
Last updated: March 15, 2017 11:55 AM