Plotting functions

  • Thread starter Thread starter Jack Gillis
  • Start date Start date
J

Jack Gillis

I am brand new to using the charting feature of Exel and am having
trouble with what should be a simple operation.

I want to create a graph of y=f(x) -- say for simplicity's sake f(x) =
x^2.

I have in column A, for x, the numbers -10 through +10 and in column B
=A^2. Column B shows the correct values but have not been able to
create the pretty graph I know so well.

Would someone give me a bit of help here?

Thank you very much.
 
Where do you get stuck?

Select the data range, click the Chart Wizard. In step 1 select the XY
Scatter chart. That should give you what you want.

Alternatively, check out the Plot Manager add-in, available from my web
site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Thank you very much.

Tushar said:
Where do you get stuck?
Click to expand...

Using the XY scatter chart got me beyond the first sticking point but
left me with two remaining. First, I would like to show the curve
between the plotted points. And second, the x axis shows 0 at the far
left rather than -10 at the left and 0 in the center.
 
Double click the x axis on the chart. In the scale tab, adjust the
Min. / Max. values. Also, adjust the setting of Value (Y) axis crosses
at N. To make the Y-axis cross at zero, set the field to 0.

Similarly, check the scale settings of the y-axis. Adjust as desired.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top