Less points in graph

  • Thread starter Thread starter nogarybko
  • Start date Start date
N

nogarybko

Hello,
Is there a way to lessen the number of data points on the graph?
I would like to pick the entire column for the function, but to see in
the plot only part of the point.
Is it possible?
Thanks,
Noga
 
If you put in an extra column such as =MOD(ROW(),10)=1, and then auto-filter
your data range (including the extra column) choosing the TRUE values in the
new column, then that will hide all but 1 in 10 of the rows. Change values
to suit your preferences.
 
Hi

Use a dynamic named range as source for graph. This covers most of possible
situations you were searching for advice for here. To be more specific, I
(and other people here too) need more detailed explanation.


Arvi Laanemets
 
You must log in or register to reply here.

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

Less points in graph 1
Excel Log Log Graph on Excel 0
Graphing Question: Blank Lines Problem ? 2
Graphs in Excel 2007 2
Excel Graph 2
Commulitive Distribution Function (CDF) Graphs 6
Get value equal to final point of chart trendline [=Trend( )] ? 1
Reference(s) to worksheets for building graphs 4

Back
Top