Excluding rows from an Excel file

[Anonymous]

Hello,

I have this chart in Excel, that has the columns that I want but in the first column I found some values that are purely strings (as shown in the image). Now how can avoid including those in a QV chart?

and in QV with a chart it gets like this without any filter:

But then I select something in "EMPRESA" and look:

I want to have the chart without selection as if it has selection.

Thabk you very much.

Message was edited by: juan.escobar

[#2]

Who knows if you'll read this 4 years on Jason... but this was very useful to me, thanks a lot.

[Jason_Michaelides]

Pleasure Ricky