Change text of chart tips?
I would like to change the text of a tool/hover tip for a datalabel in a chart
using Excel 2003. As it is, I can use the Application.ShowChartTipNames and Application.ShowChartTipValue to either turn on or off the names and values. If, say, I turn on names but not values, then the datalabels for the series named "Category 1" would read "Category 1" Data Labels. That's close, but I'd prefer that the tip simply read Category 1 or whatever else I choose. Is there a .caption property or some such that I can change somewhere? Can this be done? Thanks, Rob |
All times are GMT +1. The time now is 05:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com