Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have a table (as shown below) and I'd like to do a simple line plot. I'd
like to be able to plot this with linear x and y axes with the data points as shown in the table. Excel wants to evenly space the rows in my table along the x-axis. How can I get it to use the value in column A for the position of the data point on the x-axis? x-axis y-axis 128 1572.58 192 1178.92 256 785.25 360 465.15 480 324.03 512 303.30 600 257.99 750 211.37 960 146.10 1600 99.27 1920 75.86 2880 54.82 3840 43.98 |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
You need an XY not a Line chart. ( a very common error - Microsoft should
change the name!) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "tengel" wrote in message ... I have a table (as shown below) and I'd like to do a simple line plot. I'd like to be able to plot this with linear x and y axes with the data points as shown in the table. Excel wants to evenly space the rows in my table along the x-axis. How can I get it to use the value in column A for the position of the data point on the x-axis? x-axis y-axis 128 1572.58 192 1178.92 256 785.25 360 465.15 480 324.03 512 303.30 600 257.99 750 211.37 960 146.10 1600 99.27 1920 75.86 2880 54.82 3840 43.98 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need 2 rows to display X axis data points for a line graph | Charts and Charting in Excel | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
put data on x axis on the y axis | Charts and Charting in Excel | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
multiple x axis data | Charts and Charting in Excel |