View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Joe Dunbar Joe Dunbar is offline
external usenet poster
 
Posts: 1
Default XY Chart - Vertical Axis Crosses - Cell reference vs. Value

I would like to have the Axis Value refer to the result of a formula. My XY
chart is a 4 quadrant view of data points. I want the vertical axis to cross
at the median value for the range. I can enter the number by hand but I
can't use the cell reference.

Thanks,
Joe