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

how to i create a graph in excel from a table with 1 set of dependent
variables and 1 set of independent variable (ie, x axis and y axis)
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,722
Default graphing troubles

Go to Insert-Chart. Select the chart you want. On next screen, select the
series tab, and in the appropriate boxes, select the cells containing your X
and Y data, respectively. Format chart as desired.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"trouble.." wrote:

how to i create a graph in excel from a table with 1 set of dependent
variables and 1 set of independent variable (ie, x axis and y axis)

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default graphing troubles

If you set up the data properly, Excel will select the X and Y values. Put
the X values in a column, and the Y values in the adjacent column to the
right. Leave a blank cell above the column of X values, and put a label
above the column of Y values. Now run the chart wizard. You probably want an
XY chart in the first step, then in the second step, the data will have been
allocated to X and Y.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Luke M" wrote in message
...
Go to Insert-Chart. Select the chart you want. On next screen, select the
series tab, and in the appropriate boxes, select the cells containing your
X
and Y data, respectively. Format chart as desired.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"trouble.." wrote:

how to i create a graph in excel from a table with 1 set of dependent
variables and 1 set of independent variable (ie, x axis and y axis)



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
COM Add-in Troubles Howard Excel Discussion (Misc queries) 0 May 22nd 07 01:59 PM
Chart troubles [email protected] Excel Worksheet Functions 2 May 12th 07 02:36 PM
If, then statement troubles beez Excel Worksheet Functions 1 January 16th 07 11:31 PM
IF troubles JG Excel Worksheet Functions 6 December 24th 06 04:58 AM
Vlookup Troubles GaGirl Excel Worksheet Functions 3 May 25th 06 04:29 PM


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

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

About Us

"It's about Microsoft Excel"