Display count of data points in a scatter graph

N

npa100

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

Andy Pope

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
 
N

npa100

Perfect! Thanks Andy


Andy said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

xy scatter graph 0
problem with scatter diagram excel 2007 2
XY Scatter graph: x-axis picking up row numbers instead of values 3
Charting scientific data - Excel 2003 5
XY Scatter Chart Markers 3
How can i see if two points share a coordiante in a scatter graph? 1
XY Scatter Chart with X-axis displays the Category Name 2
Scatter Plot and Axes labels 1

Top