SpreadsheetLight for .NET Framework https://spreadsheetlight.com Open source developer-friendly spreadsheet library compatible with Microsoft Excel 2007/2010/2013 Wed, 06 Jun 2012 13:42:13 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.7 In-cell data bars vs bar charts https://spreadsheetlight.com/in-cell-data-bars-vs-bar-charts/ Wed, 06 Jun 2012 13:42:13 +0000 http://spreadsheetlight.com/?p=74 So you’ve a bunch of numbers ready to show the world (or at your weekly management meetings). The numbers are nice, but you also want to hit upper management over the head (subtly, of course) with how awesome those numbers are at a glance. Your first thought? “Bar charts.” After fiddling in Excel for half […]

The post In-cell data bars vs bar charts first appeared on SpreadsheetLight for .NET Framework.]]> So you’ve a bunch of numbers ready to show the world (or at your weekly management meetings). The numbers are nice, but you also want to hit upper management over the head (subtly, of course) with how awesome those numbers are at a glance.

Your first thought? “Bar charts.”

After fiddling in Excel for half an hour, you come up with a bar chart that looks moderately pleasing. But the bar chart looks a little, you know, crowded. (So many things in there!)

I introduce you to conditional formatting. Specifically, the data bar conditional format. Consider this:
In-cell data bar vs bar chart

Yes, I spent an inordinate amount of time matching the green colour in the bar chart to the preset green colour option Excel gave for data bars… Oh gradient fills…

Even after fiddling with chart options, I still find the chart very “busy”. The data bar version is “cleaner”.

Remember that the goal of a chart is to present the data without stylistic elements overpowering the actual data. Depending on your situation, the (conditionally formatted) data bar might be a better choice.

The post In-cell data bars vs bar charts first appeared on SpreadsheetLight for .NET Framework.]]>