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?
- Select the data series you want to change. In this example I clicked on the horizontal red bars.
- Then right click and select: “Change Series Chart Type…”
- Change to a scatterplot.
- Select the data series again and right click “Format Data Series” to format the marker style of the scatterplot markers.