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.

in Excel (2007 or newer) is there an easy way to apply any Excel formula on a set of datapoints before drawing a line/box/... on the chart, without using a helper column to do so?

(This is a generalization of the more specific question how to add a average line to the graph in excel 2007 or 2010. I actually also just want to show an average line, but I am interested in the general solution)

share|improve this question
    
General answer is probably yes. Consider using named ranges to perform your calculations and then plotting the named range directly. If you have some data or more specifics it would be easier to show a direct answer. –  dav Jun 3 '12 at 3:36
    
@David: AS I understand it, using named ranges is the same as using a helper column, which is exactly what i want to avoid. –  Rabarberski Jun 3 '12 at 8:43
    
That's not my understanding. I only know of three ways to apply a formula to data points: helper column, named ranges and VBA. Good luck with finding a solution. –  dav Jun 3 '12 at 12:41

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.