Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COM Add-in Troubles | Excel Discussion (Misc queries) | |||
Chart troubles | Excel Worksheet Functions | |||
If, then statement troubles | Excel Worksheet Functions | |||
IF troubles | Excel Worksheet Functions | |||
Vlookup Troubles | Excel Worksheet Functions |