First time poster here. I am trying to complete a graph for my first year Chemistry class relating Volume & Mass of a liquid to plot a Density line. I have not used the excel graph function in years as I was out of University for about a decade but I am now back to start a new career. Long story short I am finding it difficult to make the necessary small adjustments to my graph in order to make it perfect. Currently my graph's horizontal axis displays each one of my nine data points with equal spacing, which I don't want since the value between each point is not equal. I was hoping to scale my horizontal axis to be similar to my vertical axis where each labeled interval increases by a regular amount, let's say 5 mL, this would give me a more accurate density line from which I could then plot a best fit line to calculate the average density of all my data points. I hope this question makes sense to whomever is reading, I have attached a copy of my workbook. Also if someone could tell me how to add a best fit line and the value of the slope of that line to my graph it would be greatly appreciated.
Thanks for the help, Al Density Plot.xlsx
Bookmarks