Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Less points in graph
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Less points in graph
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. -- David Biddulph wrote in message oups.com... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Less points in graph
Thanks a lot!
Noga |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Less points in graph
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 wrote in message oups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
missing data points causes my line graph not to connect | Charts and Charting in Excel | |||
hiding data points on a line graph | Excel Discussion (Misc queries) | |||
connect two broken points of a graph | Charts and Charting in Excel | |||
Connecting Points In An XY-Scatter Plot Graph | Charts and Charting in Excel | |||
joining data points on graph | Charts and Charting in Excel |