ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Actual graphs (https://www.excelbanter.com/charts-charting-excel/77350-actual-graphs.html)

Mattyrealboy

Actual graphs
 
How do I plot a graph from an excel spreadsheet that shows the values of one
variable versus the values of a different variable, ie. along the X-axis
weight in kg , then along the Y-axis the % body fat ?

Bernard Liengme

Actual graphs
 
You make an XY chart not a Line chart.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mattyrealboy" wrote in message
...
How do I plot a graph from an excel spreadsheet that shows the values of
one
variable versus the values of a different variable, ie. along the X-axis
weight in kg , then along the Y-axis the % body fat ?




Nicky

Actual graphs
 

Hi
try using and XY (scatter) chart


--
Nicky


------------------------------------------------------------------------
Nicky's Profile: http://www.excelforum.com/member.php...nfo&userid=312
View this thread: http://www.excelforum.com/showthread...hreadid=522357



All times are GMT +1. The time now is 06:57 AM.

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