Thanks Velouria, not seen (or used) autofilter before so will have a look at that, thanks.
Thanks Riny, I have tried it before but when you have a lot of charts it would be so much easier if it could be done automatically. I was pleased to f...
Thanks Riny, I couldn't use the 'real' pivot table as it includes confidential data, but hoped it could be followed. I will have a look at your opt...
Thanks Mynda, that's a shame, guess i'll have to edit them manually (unless i can persuade my boss otherwise!). Sadly our tables in html reports look ...
Thanks for your reply Riny, unfortunately i'm not currently using power pivot, just pivot tables from data in access. Will look into pp though as it a...
Thanks Mynda, it was getting frustrating! I don't know VBA at all, but I have found that selecting the chart and changing the font colour to black w...
Hi Alan and Anders, and many thanks for your replies; I gave up trying to get the number right and as it appeared to be the only incorrect number, i h...
Hi Anders, thanks for your reply, but unfortunately it doesn't seem to work (not for me anyway). Deirdre
Thanks Mynda, i agree that the squares are fine, only the hover tooltip that's different (in that it appears correct in 3 charts but not in the 2 I wa...