View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
client #9[_2_] client #9[_2_] is offline
external usenet poster
 
Posts: 1
Default Ratios as data points

Here's my trouble. I want my data points to be the results of a calculation
between an X point and an Y point. However, the range of data on the y and
the range of data on the x will not include the range of data points.

For example, if my X is 1200 and my Y is 600, I want the data point to be
X/Y, or 2. Obviously "2" isn't going to be on a range of data for X of 1000
to 1400 or for Y on a range of 400 to 600.

Any help would be appreciated. thanks.