Formatting Comparison Data

How do I change comparison data from a horizontal bar on a cluster chart to a simpler display that displays the comparison data with a simple marker?

Before:

Comparison Data - Before

Steps:

  1. Select the data series you want to change. In this example I clicked on the horizontal red bars.
  2. Then right click and select: “Change Series Chart Type…”
  3. Change to a scatterplot.
  4. Select the data series again and right click “Format Data Series” to format the marker style of the scatterplot markers.

After:

Comparison Data - After

Leave a Reply