Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.