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.