Intermediate Excel Chart Skills

Intermediate Excel Chart Skills

  • 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 create a donut chart. The second video extends this to add conditional formatting to… Continue reading Conditional formatting for donut chart

  • “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 in the dataviz world… Continue reading “Torn paper” look for non-zero axis; Issue #436 April 2 2019

  • 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 goal.… Continue reading Comparing only one value to a standard; Issue #432 February 5 2019