modify values in Graph
Hi!
This is what I have:
A
1 12
2 13
3 14
I need to plot a graph that would refer to the values above divided by
2.
I'm aware that I could make a reference table what would recalculate
the values and have it displayed, but I'm wondering if there is some
direct aproach to this issue.
something like setting the datarange to =(Table1!$A$1:$A$3)/2
TIA
|