#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel Graphs


Hi,

Having a problem trying to produce a graph in excel. The data I am
trying to produce a graph with is shown below. To produce the graph I
highlight the range containing 0.25 to 11.658, the x and y are there to
show you guys what data I want on each axis, and then follow the wizard
through, the graph I want is a line graph with x row on the x axis, and
y row on the y axis.

x 0.25 2 5 10
y 9.6325 10.4165 10.979 11.658

The problem I have is I get two data series for each row, What am I
doing wrong?

Thanks

Tom


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

  #2   Report Post  
Posted to microsoft.public.excel.misc
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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel Graphs


Yep thats the one, thats gona be great help thanks.

T


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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default Excel Graphs

Do you really want a line chart? Did you notice that the points are equally
spaced, even though the gap between 5 and 10 should be much wider than
between 0.25 and 2?

If you select the entire data range, then choose an XY chart type in the
chart wizard, you get exactly what you want, faster than how you were told
to do it with a Line chart. (The trick with a Line chart is to clear the top
left cell, so Excel knows the top row and left column are special, and
indicate categories and series labels.)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Tomski" wrote in
message ...

Hi,

Having a problem trying to produce a graph in excel. The data I am
trying to produce a graph with is shown below. To produce the graph I
highlight the range containing 0.25 to 11.658, the x and y are there to
show you guys what data I want on each axis, and then follow the wizard
through, the graph I want is a line graph with x row on the x axis, and
y row on the y axis.

x 0.25 2 5 10
y 9.6325 10.4165 10.979 11.658

The problem I have is I get two data series for each row, What am I
doing wrong?

Thanks

Tom


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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 12:46 PM
interpolating non-linear curves in excel graphs chris Charts and Charting in Excel 9 June 20th 06 04:11 AM
Resizing graphs in excel to fit portlet. donalor Excel Discussion (Misc queries) 0 June 12th 06 10:30 AM
Excel - conditional formating on graphs. Change colour on a value Peter Shore Charts and Charting in Excel 5 June 9th 06 07:10 AM
Excel 2003 plotting graphs in inverse order jsking Charts and Charting in Excel 1 June 8th 06 04:11 AM


All times are GMT +1. The time now is 07:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"