PDA

View Full Version : Solved: Charting with labels



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

Andy Pope
04-07-2009, 02:42 AM
Maybe this will help explain the problem
http://www.andypope.info/ngs/ng57.htm

JKwan
04-07-2009, 12:21 PM
Thank you for the help, I was able to use your link on your web page to get a new version of XY Labeler to fix my problem.