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?
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?
