How Scatter Plots Work A scatter plot, or scatter chart, is a useful tool when you have data that you want to analyze in multiple dimensions.

One workaround for this shortcoming is to swap the X and Y axes of several pseudo data series to yield a chart with multiple Y axes. Use Excel's Select Data command to plot your actual data series ...