Don't Reveal Data Label On Graph When Hovering

[Hibbster]

Guys

Does anyone know how to switch off the data label reveal when you hover over a graph?

I don't want the user to be able to see the value of the data series.

Cheers

 

[Sal Paradise]

Guys

Does anyone know how to switch off the data label reveal when you hover over a graph?

I don't want the user to be able to see the value of the data series.

Cheers

One simple way is to make all your values percentages, that way the person can only see the relative values of each item rather than the absolute value, and it will just require making an extra column in your data.

Basically, just create a function to guesstimate the maximum value of the chart (using ceiling), then use that as your 100% value, and divide all the data values by that number to get a % of the chart height. Then chart the percentages and nobody will be able to see the values.

 

[Hibbster]

One simple way is to make all your values percentages, that way the person can only see the relative values of each item rather than the absolute value, and it will just require making an extra column in your data.

Basically, just create a function to guesstimate the maximum value of the chart (using ceiling), then use that as your 100% value, and divide all the data values by that number to get a % of the chart height. Then chart the percentages and nobody will be able to see the values.

Perfect. thanks

 

[Andy Pope]

In Excel 2003. Use Tools > Options > Chart > Chart Tips.
Deselect Show Names and or Show Values.

In xl2007. Use Office button > Excel Options > Advance. In the Display section Show data point values on hover.

In xl2010. Use File > Excel options > advance. In the Chart section show data point value on hover.

 

[Hibbster]

Thanks Andy