View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
npa100 npa100 is offline
external usenet poster
 
Posts: 2
Default Display count of data points in a scatter graph

I've been banging my head on what must be a simple problem (yet one
that I apparently can't solve). How can I display a count of the
number of data points actually plotted on an XY graph? I have a range
of, let's say, 100 cells. 70 of these cells contain a number and 30
contain N/A (and therefore aren't plotted). I'd like to display "n=70"
somewhere on my chart. Can anyone help? Thanks...