Intermediate Excel Chart Skills

Featured Articles

All Articles

Conditional formatting for donut chart

Jon Acampora of Excel Campus has created two videos on creating a donut chart that has conditional formatting so that the segment that represents progress changes color based on the percentage value.The first video goes over the basic steps to...

“Torn paper” look for non-zero axis; Issue #436 April 2 2019

In my Twitter feed I saw a number of well respected data visualization experts liking a recent article by RJ Andrews for the Data Visualization Society. In it he talks about the issue of starting the axis of a graph at a value other than zero. This is a common topic...

Comparing only one value to a standard; Issue #432 February 5 2019

When you want to compare values to a standard, such as comparing output in various production plants to the goal, a dashed line on a column graph is a good visual to use. The dashed line runs across the graph and it is easy to see if each column is above or below the...