mouse-over value

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
 
J

Jon Peltier

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

- Jon
 
G

Gill

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 %.
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make scroll bar permanently visible, Word 365 0
Missing address Book 0
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
Primary X axis to Secondary X axis 1
Finding the proper style field and the numbered paragraph value within the style 0
Hover values in chart 1
Avoiding cells being included in a chart 4
can't click on series, close to Y-Axis 1

Top