mouse-over value

  • Thread starter Thread starter Gill
  • Start date Start date
G

Gill

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 %.
 
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
 
Back
Top