Macro for Scatter Chart

[msharma864512]

I want to create a dynamic scatter chart, it will only includes the data which matches any certain condition.

If a macro button can be added so that, whenever I apply any condition, and whatever the data appears, then with a single click a chart can be created

 

[Chihiro]

No. Code can't really accommodate for some arbitrary condition. You'll at least have to give us some parameter to work on... after all, we are not mind readers.

Alternately, just build Advanced Filter set up yourself and add as many condition as you need to extract matching data. Then use dynamic named range to define chart series off of returned data.

See link on how to use Advanced filter.
http://www.contextures.com/exceladvancedfiltervba.html

 

[msharma864512]

Thank You, Chihiro, it really worked using your advise.

 

[vletm]

msharma864512
It could be even this ... use filter.
Ps. and You opened almost same case after this
https://chandoo.org/forum/threads/color-code-for-scatter-plot.38781/
... why?

 

[msharma864512]

thank You Vletm,

but the request i opened is a bit different than this one

 

[vletm]

msharma864512
... smooth variations.