pkrzyzaniak10
New Member
- Joined
- Nov 4, 2014
- Messages
- 1
How do I shade in an area below the curve on a scatter plot? How do I calculate the area of this shaded in area?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Calculating the area below a curve on a scatter plot
- Thread starter pkrzyzaniak10
- Start date
RickXL
MrExcel MVP
- Joined
- Sep 9, 2013
- Messages
- 4,328
Hi and welcome to the MrExcel Message Board.
Shading under a scatter plot is not easy. John Peltier has a tutorial here: Fill Under or Between Series in an Excel XY Chart - Peltier Tech Blog
Can you make the x-axis points be evenly spaced - possibly by adding extra data points? If you can then an Area plot could be used.
As for area calculations, if you have the data in columns A and B with headings in row 1 then this formula in C3 and dragged down should produce a series of points that you can sum to get an approximation to the total area.
=(B2+B3)/2*(A3-A2)
Shading under a scatter plot is not easy. John Peltier has a tutorial here: Fill Under or Between Series in an Excel XY Chart - Peltier Tech Blog
Can you make the x-axis points be evenly spaced - possibly by adding extra data points? If you can then an Area plot could be used.
As for area calculations, if you have the data in columns A and B with headings in row 1 then this formula in C3 and dragged down should produce a series of points that you can sum to get an approximation to the total area.
=(B2+B3)/2*(A3-A2)
Upvote
0
