Explore BrainMass

XY Scattergraph using Microsoft Excel

I need an XY scatter graph using Microsoft Excel that has 30 for a maximum y axis and 4 for a maximum X axis. The numbers on the x-axis are offset with the numbers 0, 2, and 4 on the lines. The entire graph must have 36 individual cells. The graph needs to show all of the numbers 0-4, but only 0, 2, and 4 are directly on a line. The 1 and the 3 need to be between the lines. The chart needs to look like the one at the bottom of the atttached file named Number of setups including data. Can anyone help?


Solution Summary

The solution creates an XY scattergraph using Microsoft Excel.