View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Excel data and charts

Make sure it's an XY chart, not a line chart (you can format it to show
lines if you want).

Chart menu Source Data Series tab. Click in Y Values box and select the
data in column C. Click in X Values box and select the data in column A.

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


"gjohnson15" wrote in message
...
I needed to know the values of Column C using the y hat equation, so I put
in
{value of a}+{value of B}*A#(data in the a columns). When I inserted a
scatterplot there was only one value plotted. I do I get Excel to
calculate
the function in Column C and graph the data?