Display count of data points in a scatter graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

npa100 - 10 Oct 2006 16:17 GMT

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...

Reply to this Message

Andy Pope - 10 Oct 2006 16:31 GMT

Hi,

Put this formula in a cell, adjust range to suit. Assumes N/A is on the
X values only.

="n=" & COUNT(A1:A20)

To display the contents of the cell with the formula use a textbox or
chart text item such ax chart title or axis titles. See here how to link
textboxes to cells.
http://www.andypope.info/tips/tip001.htm

Cheers
Andy

> 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...

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

npa100 - 10 Oct 2006 17:46 GMT

Perfect! Thanks Andy

> Hi,
>
[quoted text clipped - 17 lines]
> > contain N/A (and therefore aren't plotted). I'd like to display "n=70"
> > somewhere on my chart. Can anyone help? Thanks...

Reply to this Message