JWalk Chart Tools and hidden row problem

[guyroch]

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

 

[Andy Pope]

Hi,

The chart labeler addins only create a static link between the data
label and a cell. The 1st data label is linked to the 1st cell, 2nd to
2nd etc.

It is possible using a combination chart to label the top of each column
with a value that is not the actual value of the column. Add a second
series with the values the same as the original series. Change this to a
line chart and move it to the secondary axis. You can now use the salary
differences as the category labels for the secondary x axis. Now add
data labels to the line series displaying category. Set alignment to
above. Finally delete both secondary axes. Format the line to have no
border or marker.
Now the labels will update and remain in sync with you filtered data.

Given you have a 100 charts to change you might want to use VBA code to
update the charts.

Cheers
Andy