2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How can I more effectively set up my table to display an x-axis of concentration values (in scientific notation) vs. absorbance values (in nm) on my y-axis without having my data suddenly fall way out of range?

[Excel-Microsoft 365, Version 2604 (Build 19929.20090)] To preface, I am a current student + novice at excel, and I'm trying to avoid using AI to guess what I'm trying to describe here.

I am making a scatter plot of absorbance vs concentration values for a chromatography experiment. My x-axis is my sample's molarity (in scientific notation ranging from 0.00E0 to 6.00E-5) which were a blank solution, 1E-5, 2E-5, and 4E-5. For each of those I measured absorbance in triplicate. So for each molarity (including the blank) there are 3 absorbance values that were recorded.

I have set my table up in so many different styles and I can't get ahold of my professor nor any classmates right now to help me figure out why my scatterplot keeps looking 'wrong'.

Here is a copy paste of the current table format I'm messing with for my graph:

Concentration Red Abs1 Red Abs2 Red Abs3
0.00E+00 0.068 0.062 0.076
1.00E-05 0.145 0.146 0.145
2.00E-05 0.293 0.317 0.302
4.00E-05 0.642 0.660 0.634

My goal is to show the concentration vs. absorbance and I should see a positive slope with my trendline, instead everything keeps turning out flat or has a negative slope or doesn't appear on my graph/is out of range.

(Will update with images if anyone requests - not sure how I could easily share them in my post if anyone wants to help tell me how)

submitted by /u/Wabbstarful
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#rows.com
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#absorbance
#concentration
#Excel
#scatter plot