ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   can excel draw a chart in a coordinate plane (https://www.excelbanter.com/charts-charting-excel/20159-can-excel-draw-chart-coordinate-plane.html)

larry S

can excel draw a chart in a coordinate plane
 
i have an excel worksheet that calculates the values of an equation like
y=x^2+2x+3. the worksheet produces the x an y values. is there a way to get a
chart that produces a parabola?

Bernard Liengme

In A1 type X, in B1 type Y
In A2:A21 (or more) enter x-values such as 1,2,3,4...
IN B2 enter =A2^2+3*A2+3. Copy down to the last A column value
Select A1:B21 (or more); click the Chart Wizard; select XY chart (NOT Line)
Complete the chart.
Now you have the bare bones, visit a library and take out an Excel book.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"larry S" <larry wrote in message
...
i have an excel worksheet that calculates the values of an equation like
y=x^2+2x+3. the worksheet produces the x an y values. is there a way to
get a
chart that produces a parabola?




Ken Wright

And just in case this is where you were heading:-

http://www.tushar-mehta.com/excel/ch..._distribution/

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"larry S" <larry wrote in message
...
i have an excel worksheet that calculates the values of an equation like
y=x^2+2x+3. the worksheet produces the x an y values. is there a way to

get a
chart that produces a parabola?





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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com