My secondary axis value is say 10% and the mouse-over value displays .10
which is incorrect, can you advise how to fix this please

0.10 = 10%. Perhaps your data range has different formatting than the axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Gill" wrote in message
...
My secondary axis value is say 10% and the mouse-over value displays .10
which is incorrect, can you advise how to fix this please

Thank you Jon, I have other charts set up exactly the same and they display
the 10% on the mouse-over as well as on the axis. The data source is all
formatted as %.

"Jon Peltier" wrote:

0.10 = 10%. Perhaps your data range has different formatting than the axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Gill" wrote in message
...
My secondary axis value is say 10% and the mouse-over value displays .10
which is incorrect, can you advise how to fix this please

I seem to recall that format links between charts and their data ranges are
not reliable when the data is in a different workbook, maybe even in a
different worksheet than the chart is embedded within.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Gill" wrote in message
...
Thank you Jon, I have other charts set up exactly the same and they
display
the 10% on the mouse-over as well as on the axis. The data source is all
formatted as %.

"Jon Peltier" wrote:

0.10 = 10%. Perhaps your data range has different formatting than the
axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Gill" wrote in message
...
My secondary axis value is say 10% and the mouse-over value displays
.10
which is incorrect, can you advise how to fix this please