Phsa asks how to plot every 100th row in Excel. Episode 1919 uses a quick Formula-Based Criteria and an Advanced Filter to solve the problem.
Transcript of the video:
The MrExcel podcast is sponsored by Easy-XL.
Learn Excel from MrExcel podcast, episode 1919.
Chart Every 100th Data Point.
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
See, we have 100,001 rows in Excel.
Today's question sent in in YouTube: say I have a 100,000 rows of data and I want to plot it.
Naturally I only want every 100th row to show on that chart.
How the hell do I do that?!
Well, I'm going over to a blank section, =MOD(ROW(A2) -the first cell in my database- ,100)=2.
Go back and select a cell in the data, go to DATA, Filter, Advanced, the Criteria range is the blank cell and the formula cell that we created, click OK.
We now see every 100th row, select that data (Ctrl+Shift+Down arrow), Ctrl+., Ctrl+. and INSERT, Line Chart, and you're done.
Hey, I want to thank you for stopping by, I will see you next time for another netcast – MrExcel.
Learn Excel from MrExcel podcast, episode 1919.
Chart Every 100th Data Point.
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
See, we have 100,001 rows in Excel.
Today's question sent in in YouTube: say I have a 100,000 rows of data and I want to plot it.
Naturally I only want every 100th row to show on that chart.
How the hell do I do that?!
Well, I'm going over to a blank section, =MOD(ROW(A2) -the first cell in my database- ,100)=2.
Go back and select a cell in the data, go to DATA, Filter, Advanced, the Criteria range is the blank cell and the formula cell that we created, click OK.
We now see every 100th row, select that data (Ctrl+Shift+Down arrow), Ctrl+., Ctrl+. and INSERT, Line Chart, and you're done.
Hey, I want to thank you for stopping by, I will see you next time for another netcast – MrExcel.
