| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel data and charts
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel spreadsheets with data, Powerpoint charts... and VBA! | Excel Discussion (Misc queries) | |||
| Why do OWC charts aggregate data when Excel doesn't? | Charts and Charting in Excel | |||
| Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
| Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
| Excel Charts - Data being Plotted beyond Primary X-Axis Scale | Charts and Charting in Excel | |||
Linear Mode
