Hello,
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?
Thanks,
Steve
Also, please see the following link:
http://spreadsheets.about.com/od/excelcharts/ss/90209linegraph.htm
LineChart.jpg