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 to visualize a trend and I was wondering if it is possible to show a red line over a range of data for the mean value(data range) and the variance(data range).

Example:

Data: a,b,c,d,...

Histogram:

         | 
|     |  |  |
|  |  |  |  |
a  b  c  d ...

Histogram with trend lines for mean value and variance:

 --------|-- 
|-----|--|--|
|--|--|--|--|
a  b  c  d ...
share|improve this question
    
I found the menu entry: Add Trendline. If I add a linear trendline and the line goes from the left lower corner to the right upper corner then the trend is increasing? What about the other trend lines: exponential, logarithmic, ... ? – user48604 Nov 10 '11 at 12:43
    
A trendline attempts to show a pattern in your data. The different types simply apply different algorithms to fit your data to a linear, logarithmic, polynomial or exponential curve. If you want to show mean/median/variance, you'd need to calculate that separately and add it to the chart manually as a text box or another data series, depending on how you want to display it. – Rhys Gibson Nov 10 '11 at 19:53
    
Ok. These are two separate things. I will use the trendline for forecast and make a separate display with lines for data, mean, var+ and var-. Thx. – user48604 Nov 11 '11 at 9:34

OP decided to "use the trendline for forecast and make a separate display with lines for data, mean, var+ and var-" because it was explained that a "trendline attempts to show a pattern in your data. The different types simply apply different algorithms to fit your data to a linear, logarithmic, polynomial or exponential curve. If you want to show mean/median/variance, you'd need to calculate that separately and add it to the chart manually as a text box or another data series, depending on how you want to display it."

In short, they had to add a new series.

share|improve this answer

Your Answer

 
discard

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.