MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Plot every 10th data

Posted by Heru on June 24, 2001 7:38 PM

I try to plot more than 32,000 (excel max number) data between date (x-axis) and pressure (y-axis).
I wish I can reduce number of data by plotting only every 10th data so still can be plotted by excel.

Thanks for the help.

Posted by Damon Ostrander on June 25, 2001 9:16 AM

Hi Heru,

Just introduce a column next to your data columns,
enter '1, '2, '3, etc., and fill down to end of
your data. This puts text values 1,2,3,4,... in
column. Then do Data -> Autofilter on this column, pull down the autofilter dropdown at the
top of the column and select (Custom...), enter criteria to show rows that end with 1. This will filter every 10th point. You shouldn't have to change your chart, or the assigned data series ranges.

Happy plotting.