Is it possible to plot data in excel without having to define the function of the data in an extra column?
Think of this simplified example:
There are two columns with numbers A and B. Is it possible to plot A, B and Sum(A+B) without having to create a column to pre-calculate the last one (eg:
Plot using extra column
What I want to achieve
I want to avoid extra columns (only one in this example) and have this logic directly in the graph.
The above illustration is not valid, excel displays an error similar to "this function is not valid for this context" (I use Greek Excel, cannot tell you the exact English error msg)
*Note: I am aware that I can use extra/hidden columns, extra Sheets or even Sheets from external files. I don't want such thing. I want to somehow include this info directly into the graph. Also, I cannot use VbScript.