Issue while using J-Walk Chart Tools

[jessicara]

Background: Every week I have approximately 100 charts to update for a report. I have the data imported into excel via a query, and press the exclamation point button to update the data every week. The charts that are tied to this data are setup using named ranges. The named ranges use OFFSET/COUNT to capture all of the data so that I don't have to manually adjust the charts. That all works great.

I needed to include data labels on some data points that move as the data moves. I added the J-Walk Chart Tools add in in order to do these labels. I use an IF statement to populate the column that contains the labels (Specifically, =IF(J4="","",E4)). Some of the label cells are blank, and some actually contain labels. When NEW data is added, the blank labels show up as little empty boxes on the chart. Does anyone know how to keep this from happening?

 

[VoG]

Hello and welcome to MrExcel.

Try using =NA() instead of blank - does that fix the issue? If not please provide a link to the add-in.

Incidentally the annoying squares are probably unprintable characters like line feed (CHAR(010)).

 

[jessicara]

Unfortunately the little boxes still occur even after changing the formula and adding additional data.

The add in is found at http://spreadsheetpage.com/index.php/file/j_walk_chart_tools_add_in/