Combination chart mouse-over values problem

[#1]

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 Yury,

We have encountered similar issues in our combination charts as well.

What we learned is this:

-> the Regional settings in Windows for number formatting sometimes influence this "factor 100" issue.

What I notice in your original screenprint is that I see that a decimal comma <,> is used as decimal character.

In your second screenprint (with the "factor 100" issue) I notice that a  decimal point <.> is used as decimal character.

So maybe you changed your settings in Windows (from Europe setting to UK/US setting).

What we experienced is that this could lead to a misinterpreation by the xcelsius component. The decimals behind the comma character are now seen as full numbers.

What we do to prevent this is to define the number format of the MOuse-over values as General.

By doing so the number format is inherited from the cell reference in the Excel sheet.

So there you make sure you have defined the right number format:

Also we noticed that to get it right again (solve the decimals issue) the only way is to delete and recreate the xcelsius component.

Hope this helps you.

Cheers,

Marc