Jump to content

excel help? quantitative chemistry

Featured Replies

is there any way in which i can make a graph in excel and count by "x.yz" like 1.20?

I did a titration in my quantitative analysis lab and we are suppose to make a graph and we had to titrate by 0.05 mLs near equivalence point. So my graph instead of being, "1,1.50,2.00,2.50" is made in excel as "1,2,3,4" for each value. Does this make sense?

 

Also, is anyone familiar with potentiometric titrations? I'm a little unsure what to do with my calculations.

If you right click on the axis you should have an option to format, then need to adjust the interval between tick marks.

 

Hard to be sure this is what you want without looking over your shoulder.

  • Author

Basically, is there any way I can have my x axis count by 0.10? And if so where do I edit that?

First, you need to plot as a scatter plot, not as a line plot. Did you do this?

 

Secondly, as Edny said, right click precisely on the axis. Select Format Axis from the drop down menu that appears. (It should be the last option on the menu.)

Axis Options allows you to define major and minor units.

 

If this does not give you what you are looking for then, as I requested before, you need to provide a clearer explanation of what the problem is.

Archived

This topic is now archived and is closed to further replies.

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.