Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have two columns with numbers and I am trying to make a very easy chart but
I don't know how. I want the numbers from column A to be on the X axis and the numbers from column B to be on the Y axis and to create a line between theese points. |
#2
![]() |
|||
|
|||
![]()
http://peltiertech.com/Excel/ChartsHowTo/index.html
should help you. "Ivan" <Ivan @discussions.microsoft.com wrote in message ... I have two columns with numbers and I am trying to make a very easy chart but I don't know how. I want the numbers from column A to be on the X axis and the numbers from column B to be on the Y axis and to create a line between theese points. |
#3
![]() |
|||
|
|||
![]()
Ivan,
I would use an X-Y Scatter chart. As an example, go to cell A1 and add your data for column A. After adding your column A data, go to cell B1 and add your data for column B. When you've completed adding both columns, go back to cell A1. Go to the Chart Wizard icon in the Standard Toolbar. Click on it and select "X-Y (Scatter)" as the chart type. The chart sub-type should be the type at the very top of the dialog box that shows points only. Hit the Finish button and you should see your basic chart. You can connect the lines between the points by clicking once on any of the points in the plot area. Then right-click on your mouse, hit "Selected Object", go to the patterns tab of the dialog box, and select "Line = Automatic". All of the points should now be connected with a line. To put a single line through the middle of those points, again click on any one of the points. Right-click on your mouse and go to "Add Trendline". Under the "Type" tab of the dialog box click on "Linear". You should get a best-fit linear trend running through the chart. Hope this helps. ---- Regards, John Mansfield http://www.pdbook.com "Ivan" wrote: I have two columns with numbers and I am trying to make a very easy chart but I don't know how. I want the numbers from column A to be on the X axis and the numbers from column B to be on the Y axis and to create a line between theese points. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a dynamic chart | Charts and Charting in Excel | |||
Creating an x,y coordinate chart | Charts and Charting in Excel | |||
Ignoring characters in excel sheets when creating a chart | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
HOW TO: Plot a Team Name on a chart based on two values | Charts and Charting in Excel |