• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to match and retrieve the entire row

Nisha Dhawan

New Member
Hello Everyone,

I have a list of column containing Countries (Duplicate) in Col A, Col B Containing Criteria of Yes/No and Col C has the value figure, & Col D is containing list of product

What I want a chart in the same sheet without using Slicer, If I Select X country and No as Criteria, then the chart should show the relevant products in X axis and Value in Y.
 
Since you're not using a slicer, what method do you want to use to "select" something. A macro, an Autofilter, a PivotTable,...?

PivotTable w/ a PivotChart would be the easiest method.
 
Back
Top