For business users of Microsoft Excel Free guides and templates

Windows & Mac Excel

Charley's Swipe File #2

Although Excel charts have been able to have rounded corners for at least ten years, that's not how the corners of this chart were formatted


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

Charley's Swipe File #2(Many of my swipe files use Greeking, which is fake Latin. It helps you ignore the textual content and focus on the actual charts and tables.)

Charts can have rounded corners in both versions of Excel.

(To round the corners, select a chart and press Ctrl+1. In New Excel, choose Border Styles, Rounded Corners. In Classic Excel, choose Patterns, Rounded Corners.)

In this figure, however, the corners of the area around the chart are rounded, not the chart itself.

I can think of two ways to set up a figure with rounded corners.

Briefly, one way is to create four white shapes that you can park in the four corners of a cell. If the cell has a red interior, as in this case, the four white shapes make the corners of the cell appear to be rounded. Similarly, the interior white area could use red shapes to make its corners seem rounded.

However, this figure uses an easier approach.

(Continued in the documentation.)

Order Details

Excel Versions:

Excel 2007 and after, for either Windows or Mac

Availability:

Instant download of zipped Excel and PDF files. If you ever need another download, you can get it at any time.

Guarantee:

One full year, unconditional.

Currency:

All prices are in US Dollar currency.

Licensing:

Two copies: One for work plus one for home.

Credit Cards:

Credit Cards
 

Only $9.95 USD

New Excel