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?


Comparison Data - Before


  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.


Comparison Data - After

Leave a Reply