View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ammar Ammar is offline
external usenet poster
 
Posts: 1
Default 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