Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have the following chart in Excel:


I want to calculate the area under the graph line.

Any idea?

share|improve this question
Odd. What reason could there be to downvote this question? – pnuts Dec 5 '12 at 10:08
up vote 1 down vote accepted

For each adjacent pair of points, take average of y-coordinates, then multiply by difference of x-coordinates, and accumulate for all pairs.

share|improve this answer
thanks, how to calculate +/- from average line(2.8)? – Amir Nov 25 '12 at 9:28

For your related post (How to paint area under graph line with average line?) I suggested using a column chart. The area chart overemphasizes some points more than the values should allow. Since the points are discrete measurements, the sloping lines between measurements are meaningless, and calculating areas is going to be misleading.

So the "area" above the values is the sum of (value - average) for value > average, and the "area" below the values is the sum of (average - value) for value < average.

Very simple to calculate with two simple formulas.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.