Can I Chart Every 10th Point?

**toddlarson5** · 03-15-2008, 04:07 PM

I am currently designing a reactor and due to the integration I need to keep the time step very low (0.01 s) this gives me way over 32000 points, the most allowed in a excel chart.

Is there any way I can chart every 5th, 10th or 20th value?

The key is I need to keep every point in the excel file but I only need to graph enough points to see the general trend.

**oldchippy** · 03-15-2008, 04:37 PM

Hi toddlarson5,

Welcome to the forum!

I’m not sure what’s involved in designing a reactor, but may be this might help. I’ve put some values in columns A and B, then in column C and D extracted every fifth value.

I then copied C and D and Paste Special > Values into L and M, then selected L and M and sorted A-Z.

Chart 1 – original data, Chart 2 – every 5th value

**toddlarson5** · 03-15-2008, 05:08 PM

Thanks worked perfectly, just curious, when selecting data while making a graph is it possible to have it only take every 5th point or is the ROW method the best way to do that (with almost 100 000 points it seems resource demanding to repeat the values in another column)

**oldchippy** · 03-16-2008, 06:37 AM

Hi,

I don't think Excel will allow you to pick non-adjacent cells for the series. You may find it with an Add-In like this one from tushar-mehta called "PLOT Manager"

http://www.tushar-mehta.com/excel/

You can read what it does here

http://www.tushar-mehta.com/excel/so...elp/index.html

I've also had another look at it and now you can miss out the copying and pasting by using another formula, in L2 - see attached

=INDEX(A$1:A$1000,ROWS(A$1:A1)*5-4) copy down the column

Then in M3

=VLOOKUP(L3,$A$2:$B$1000,2,FALSE) again copy down

Can I Chart Every 10th Point?

LinkBack

Thread Tools

Rate This Thread

Display

Can I Chart Every 10th Point?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions