Thread: Excel Graphs
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
gauss1976 gauss1976 is offline
external usenet poster
 
Posts: 1
Default Excel Graphs


Hi Tom,

I think I have the solution. I have copied your values in excel

x 0.25 2 5 10
y 9.6325 10.4165 10.979 11.658


Highlight your y-data range 9.6325-11.658

Now click on the chart icon and select Chart type: line and click
next.
This will produce a single line with the correct y values but incorrect
x values.

To get the correct x-values click on the series button at the top of
the chart display window.

You will see a title: Category (X) axis labels. Click with the mouse on
the icon to the right of the blank box on the same row as the title. The
chart window now gets very small. highlight your x-values data in the
excel chart and press return. You now have your desired
single graph.

You can now edit the properties of the graph as you see fit.

Hope this helps

Gauss1976.


--
gauss1976
------------------------------------------------------------------------
gauss1976's Profile: http://www.excelforum.com/member.php...o&userid=36586
View this thread: http://www.excelforum.com/showthread...hreadid=565496