Hi,

I user JWalk Chart Tools to add lables to my bar chart that are
different than the actual values. By bars represent salaries whereas
the lables in each bars represent the salary increase since last year.

JWalk work fine... at least it does if you do not have hidden rows in
your data series.

I have about 100 charts that points to the same data series. The
issue I have is that I have to filter my list based on a different
criteria for each of the 100 charts. When you use a filter, Excel
simply hides rows and the excel chart is smart enough not to include
the hidden rows in the chart

However, I can't say the same thing for JWalk Chart Tools, IT DOES NOT
take into account the hidden row and as a result it uses the label
values of both visible and hidden rows. This of course is not
acceptable.

Any ideas on how to have JWalk (or other tools) to take into account
hidden rows?

HELP

- GuyRoch