Filtering two columns of data to chart in future

[jcalvacca]

Hello all!

Thanks for the help. I have attached a file for reference with some comments...

Few things to note....

-Filtering is done so that it can be charted as two separate data blocks....
-Needs to be able to take more data than is posted, so the "blank data" on the end of the copied columns need to not throw the chart off as a " " would.

Please help me with logic understanding of macro with comments as this will be used on a couple of different sheets on my project file.

Thanks for the help!!

 

[Chihiro]

After quick look. I'd suggest setting up Advanced Filter to do your operation.

See links for guide and tutorials.
http://chandoo.org/wp/2012/11/27/extract-subset-of-data/
http://analysistabs.com/vba-code/range/m/advancedfilter/
http://excelsemipro.com/2011/03/copy-data-to-another-worksheet-with-advanced-filter/

 

[Luke M]

Hi jcalvacca,

It looks like the end goal is to create charts for each named area. My suggestion would be to utilize some of the power within XL, and create a PivotChart. Then, you don't need top copy/move your data, you can leave it where it is. The PivotTable will organize the data how we need it, and we can quickly change our groups.

 

[Luke M]

Same file as before, but with a slicer for greater speed