LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
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...

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to DISPLAY all data values in Pivot Table...not count, sum, etc spot1234 Excel Discussion (Misc queries) 3 July 21st 06 09:29 PM
XY Scatter doesn't display correctly when data has numbers&empty c cacpanama Charts and Charting in Excel 2 March 17th 06 04:38 PM
Need 2 rows to display X axis data points for a line graph SusanG Charts and Charting in Excel 1 March 8th 06 05:34 PM
Excel should let you graph every n-th data point in a column warrenrob50 Charts and Charting in Excel 3 March 3rd 06 08:42 PM
joining data points on graph minihana Charts and Charting in Excel 2 February 12th 06 02:02 AM


All times are GMT +1. The time now is 11:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"