How do I graph multiple y axis points with the same x value in Excel?
Definitely use the Scatter or XY (Scatter) chart type. Consider using the subtype that has no lines, only markers. Create your data table first, of course, The X values belong in the left column and the first set of Y values in the next column to the right. You can add as many sets of Y values as you like. The left (X value) column can contain repeated values to allow show multiple Y values in for one X value within one set of data or just o allow the entry of each of many sets of data within its own table area. For example, you could build a three column table (1 column of X values and two more columns for two separate sets of Y values) by copying the following data 1,2,3 2,3,4 2,4 3,5,6 4,,7 4,,8 5,8,9, 7,12,4 9,11,6 2,6,7 5,6,5 pasting it into an Excel worksheet, and using the text to columns wizard specifying comma (,) delimiters to put the data into three columns. If you then create a scatter chart from the table, being sure to select the entire table, you will see an accurate rep
