JKwan
04-06-2009, 01:33 PM
I created a chart in Excel, then I use some VBA codes that I found to create its own lables on the chart (rather than just using the default of X or Y values). The code works good.... However, what I found is that if I use AutoFilter on my data, the labels get mucked up. Then I look deeper into the code and I discovered that it is checking on how many points are on the chart and then it will pick off the label index - well, this does not work for me. So, if there are 1 point (after I filtered it), it will return the label 1 - because there is only 1 point. I know what is wrong but I don't work Charts enough to fix it.
Thanks
Thanks