I have a chart web part that I am using an Excel file as the datasource. I can connect to the data just fine, but want to filter the rows with an "or" condition. The filter in Step 3 of Data and Appearance acts strictly like an "and" filter.

e.g. filter on column 1 string default value: Hello

filter on column 1 string default value: World

Would only return rows that had Hello and World in the cell.

I want to grab rows that have Hello OR World in the cell.

Your Answer


By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.