I have created a chart in Excel which is more like a bar graph. Each element has a bar whose length corresponds to the value of the cell. I need to convert it to a line graph (I hope I'm using the right terminology.) By LINE GRAPH, I mean what we used to do back in match class, plotting a series of data points, then connecting each point with a line.
I tried going into CHANGE CHART TYPE, but the closest I can find is a scattered X, Y graph that contains the data points only. (Please see screenshot at the bottom of this post.)
Is there a choice that I'm overlooking that can generate the graph that I need?