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 · Accepted solution]

It seems I know the way..

Prepare spreadsheet with proper format:

Add combination chart. Insert first series, name it “Numbers”, set its values (select a range). Insert second series, name it “Percents”, set its values (select a range), plot it on Secondary Axis.

Go to Appearance, Text, set Secondary Vertical (Value) Axis Labels Number Format to General, uncheck  Secondary Vertical (Value) Axis Labels.

Refresh “Numbers” series: go to General tab, select this series and reselect its values (Y) (just click the select range button and OK in the dialog).

Go to Appearance tab, set cursor to “Mouse-over Values”, change number format to Percent with 2 decimal places.

Check Secondary Vertical (Value) Axis Labels, set  Number Format to Percent with 2 decimal places.

Refresh “Numbers” again.

And again go to Appearance tab, set cursor to “Mouse-over Values”, change number format to Percent with 2 decimal places.

Refresh “Numbers” again.

Click Preview.

How to simplify this process?