Hi all,

I have an oil tank that's of an irregular shape and I need to know the volume of oil within the tank. The company was kind enough to provide a fill table that shows the depth of the fill for certain volumes and I'm trying to use this table to figure out the volume of oil in the tank in relation to the depth. I can do this on paper by making a graph based on the fill table, plotting a line from the X axis depending on the depth reading to the graph line and plotting a line to the Y axis and there's the volume. I'm not sure how to do this in a spreadsheet, I'd really appreciate any help please?

Many thanks!