CODEWITHSUNDEEP
excelvba
Physco11
Physco11

Reputation: 105

Suppress "Chart Area" tooltip in Excel

I don't mind the "Chart Area" tooltip showing when I hover my mouse over an actual chart, but the tooltip is displaying on sheets where there are no charts. It seems like Excel is showing tooltips for hidden sheets even when I am on a sheet with no charts.

How can I disable this in Excel or VBA? I have tried the following:

Excel: File -> Options -> Advanced -> Untick "Show chart element names on hover" VBA: Application.ShowToolTips = False

I also don't see any property of the chart that I could change that would suppress tooltips.

Upvotes: 1

Views: 2828

Answers (3)

Kash
Kash

Reputation: 53

You can turn of chart screen tips in the following way (with Excel 2019) File -> Options -> Advanced -> Chart then uncheck "Show chart element names on hover" and "Show data point values on hover"Screen Shot

Upvotes: 1

J.R. de Vries
J.R. de Vries

Reputation: 11

In Excel 365 (version 2005) I have found a solution (for charts and most other annoying recurring tooltips I came across at least): Go to Options -> Advanced -> Chart, untick 'Show chart element names on hover'

I couldn't find this anywhere else online, so I thought I'd share, even though this post is somewhat old now.

Might be different or not available for older Excel versions, I'm not sure...

Upvotes: 1

Physco11
Physco11

Reputation: 105

I re-installed Office and the problem disappeared.

I tried reproducing the problem in other workbooks, but I only ever got the problem in a particular workbook, and the problem persisted in that workbook even if I saved it with a new name. I re-installed Office a few days ago and have not experienced the problem since.

Upvotes: 0

Related Questions