Excel data and charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gjohnson15 - 11 Oct 2006 01:05 GMT

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?

Reply to this Message

Jon Peltier - 13 Oct 2006 03:56 GMT

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
_______

>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?

Reply to this Message