Learn Excel - Plot Every 100th Row - Podcast 1919

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Aug 28, 2014.
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.
maxresdefault.jpg


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.
 

Forum statistics

Threads
1,213,557
Messages
6,114,287
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top