Today we’re revisiting one of our more popular guides, Creating rounded corners in Excel Tables, and have updated it for v7.1. When Igor Asselbergs was contemplating the value of round corners in design, he came to the conclusion that in many cases they added real value to the user experience.
The effect can be explained by the Gestalt Law of Continuity. Gestalt is a set of rules based on research into perception psychology, and a very powerful tool for Excel table design. In table design this effect can help us to see the table columns as a unit.
The previous process to create rounded corners in Excel tables required quite a bit of persistence and patience. In Version 7.1, we’ve introduced a feature to enable adding rounded corners in a few seconds rather than several minutes, so while the theory is identical the implementation is much improved. Take this report showing sales KPIs, where we would like to add rounded corners to the header row in the table.
To do this we first highlight the required area:
Then we go to Extras -> Add/Edit Round Corners:
The Colours and Border thickness will be picked up from the selected cells. Select the corners to be made round (in this case the Top Left and Top Right corners):
Click OK to apply the borders
To edit existing corners which were created by XLCubed then you can just highlight the cell or range and Go to Extras -> Add/Edit Round Corners. The changes will be applied to the existing corners (or the corners can be removed by unselecting them).
It’s a simple addition to the product which would have saved us quite a bit of time in customer implementations over the years, and hopefully now does the same for our users.
Today’s blog is going to show you how to use XLCubed’s custom calculation functionality to create column breaks in a grid. Imagine that you have a report that shows you Reseller Sales across Product Model Categories over a 12-month time period.
There’s nothing wrong with this report but don’t you think it would be nicer if there was a way to separate out each quarter block ie put in a divider column between March and April, June and July, September and October. That would make it much easier to read and show clearly where each quarter period started and ended.
So let’s start by creating a custom calculation. Click the highlighted icon and give your custom calculation a name – let’s call it ColBreak. It’s connected to the Date.Calendar hierarchy.
Now in the Expression area enter a blank string starting and ending with ” (double-quote). Click OK.
To insert this into our report we now go to the Hierarchy Editor for Calendar Date – expand the All member and you will see ColBreak.
Drag this across and insert it into the report. We will insert it after March, June and September and click OK.
The report now looks like this:
Now let’s format this column break so that the we don’t see ColBreak appearing as a column heading. You need to right-click to get XLCubed’s right-click menu and then choose Format This Member.
We will choose white for the Font colour before clicking OK.
The report now looks like this with clear demarcations between each quarter: