Scatter chart with columns instead of points
 

I need to create a chart showing the number of students who received each
numerical grade on test. The spacing between grades is not equidistant (ex:
65, 70, 90, etc.) and I need to show the true spacing on the x-axis. So I
chose a scatter chart because the other charts make the points of equal
distance on the x-axis. The trouble is I need to represent the data as
columns so if two students scored a 65 and eight scored a 90, the 90 column
would much higher. Is there a way to add vertical columns to a scatter chart?

Put your grades in a column, and include the grades which had none. Make your column
chart, and the grades with none serve as spacers.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Bill_S wrote:

I need to create a chart showing the number of students who received each
numerical grade on test. The spacing between grades is not equidistant (ex:
65, 70, 90, etc.) and I need to show the true spacing on the x-axis. So I
chose a scatter chart because the other charts make the points of equal
distance on the x-axis. The trouble is I need to represent the data as
columns so if two students scored a 65 and eight scored a 90, the 90 column
would much higher. Is there a way to add vertical columns to a scatter chart?