I have the table of data listed below with column 2 as my x-axis and column 3 as my y-axis. I would like to have a macro that will only show the label for the 3rd row in the table (in this case it would only show the data label for the point that matches to Jane). What would the vba code be to make that happen? Thanks.
Please Login or Register to view this content.
Do you really need code? If you add another series that only displays required data labels you can control it all via worksheet.
Please Login or Register to view this content.
Thanks! I didn't even think of that. I put that in and ran it however it only labels the point with the y value and not the person's name which is what I want. How would I change that?
The only built in information displayed in the data label is Series Name, X and Y value.
So unless you have set each data point as a series you can not simply apply data labels. You would need to determine which cell contained the information and then set the text in the data label.
If it is only 1 label then the additional series approach allows you to use the Series Name in the data label.
So if I were to say that I would always like to label Point(3) with the person's name if I click a button only and with the person's name being stored in cell A20 on the active sheet how would I be able to do that? I can currently show all points using the code below but I need the option of only showing one when necessary.
Please Login or Register to view this content.
untested but something like
Please Login or Register to view this content.
Nice! Thanks Andy!. This is the first jump into working with charts in vba so lots to learn. I can tweak that now to what I need.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks