Change Pivot Chart Layout

Fix Pivot Chart Column Colors http://blog.contextures.com/

Recently, someone asked me why all the columns in their pivot chart were the same colour. The chart showed several months of data, for multiple regions, and every column was blue.

In the screen shot below, I've created a similar pivot chart, from fake sales data.

Continue reading Change Pivot Chart Layout

Excel Roundup 20160104

Excel Roundup http://blog.contextures.com/

Welcome back, and I hope you enjoyed your holiday break! It's taking most of my brain power to type 2016, instead of 2015, so this will be a short roundup, to get things rolling again. If you subscribe to my newsletter, the next issue will be sent on January 12, 2016.

Continue reading Excel Roundup 20160104

Excel Christmas Tree 2015

Excel Christmas Tree – no macros http://blog.contextures.com/

It's only a week until Christmas Eve, and to help you celebrate the holidays, I have updated my Scroll Bar Christmas tree. No macros are needed, but this version uses customizable icon sets that are available in Excel 2010 and later versions.

This will be my last blog post until the new year, so happy holidays, and remember to cell-ebrate safely!

Continue reading Excel Christmas Tree 2015

Excel Roundup 20151214

Excel Roundup http://blog.contextures.com/

In this week's roundup, bad dashboards, new Workday function, calculation speed and much more.

Continue reading Excel Roundup 20151214

Customize Weekends With Excel WORKDAY Function

Project End Date with Excel WORKDAY.INTL http://blog.contextures.com/

If you're trying to figure out when a project will be completed, you can use the WORKDAY.INTL function (Excel 2010 or later). It's more flexible than the older WORKDAY function – it doesn't assume that you work Monday to Friday any more!

Continue reading Customize Weekends With Excel WORKDAY Function

Excel Roundup 20151207

Excel Roundup http://blog.contextures.com/

In this week's roundup, KPI dashboards, pricing lookups, autofit for merged cell rows, and more.

Continue reading Excel Roundup 20151207

AutoFit Merged Cells Row Height Update 20151203

AutoFit Merged Cells in Excel http://blog.contextures.com/

Way back in June 2012, I posted some sample code for adjusting the row height in merged cells. It's been 3-1/2 years, and people are still commenting on that article!

Apparently it is a common problem, and even though I don't like merged cells, sometimes we just have to deal with them.

Continue reading AutoFit Merged Cells Row Height Update 20151203

Excel Roundup 20151130

Excel Roundup http://blog.contextures.com/

In this week's roundup, prevent errors, break links, register for an Excel summit, download an Advent calendar, and more.

And it's Cyber Monday, so my Pivot Power Premium add-in is 20% off, until the end of the day. There are a few other Excel sales too, so check them out on my What's New page.

Continue reading Excel Roundup 20151130

Excel Roundup 20151123

Excel Roundup http://blog.contextures.com/

In this week's roundup, get file creation dates, plan for Thanksgiving, create icons with number formatting, and much more.

Continue reading Excel Roundup 20151123

15 Years of Excel Tips

15 Years of Excel Tips – How Old Are Your Files? http://blog.contextures.com/

The Internet says that 15 years ago this month, I started my Contextures Excel Tips website. And since the Internet is never wrong, it must be true! The dates are a little hazy, because that was a loooong time ago, but it was definitely 2000 that I got the website up and running.

This week, I took a look back, and figured out how to get an Excel list that shows the original creation date of all my sample files. You can download a workbook with the sample code, below.

Continue reading 15 Years of Excel Tips