Combination chart mouse-over values problem

[Former Member]

Hi!

I have a combination chart with 2 axis (primary - percents, secondary - numbers). My goal is to show correct mouse-over values (for series on secondry axis - numbers, on the primary - percents). Moreover I want to show percents with 2 decimal places.

In spreadsheet I have formated data (the real data for percents is 0.8206, 0.7638, etc.). So, I have percents (1st and 3rd columns) and general numbers (2nd) like this:

Indeed I have more data but this doesn't matter I think.

I found a strange way to show percents on percent data and numbers on general numbers (magic order of actions). My problem is that I can't figure out how to set 2 decimal places for mouse-over values. I got strange and incorrect results if I just set this property on the appearance tab:

The real data is around 99%, but tooltip shows 0.99% (if I set 1 decimal place in the appearance, it will show 9.9%). Really strange.

How to solve this???

I believe that it is possible because I did it once. Here is my other chart:

Now I can't figure out how I did it.

Suggestions?

[Former Member]

Hi,

Here is a trick you can use to fix the percentage issue in Charts/Scorecards etc.

In the spreadsheet format your data to Numbers, then in the Mouse over settings choose Number format to currency. Check the box next to Suffix and put % and set 1 or 2 in Decimal places based on your requirement and that s it.

Thanks

Ahtasham