Analysis for Excel - Secondary axis settings disappear when refreshing

[bergbomb]

Hello,

I'm trying to create a dynamic graph with a secondary axis for certain key figures as a combination of Bar and Line

Once I refresh the workbook the secondary axis is gone and the formatting of the axis as well.

I have to format the data series to plot on secondary axis every time and also change the series chart type to Line

Is this a known error or is there any setting that I have missed ?

Greatful for any input

Thanks and regards

Bjorn

[daniel_halbauer]

Hey Björn,

take a look at this

Late but maybe helpful.

Regards,
Daniel

[TammyPowlas]

Sorry to ask the usual question - are you on the latest SP for Analysis Office - 1.4 SP2?

[bergbomb]

Hi Tammy,

Thanks for your reply,

Actually I don’t know how to find the version we use.

It was installed in the end of May

Btw , I also use SAP GUI 720 since I still have to use Query designer 3,5 every now and then…

Please guide me where to find the AO version

Thx

Bjorn

[TammyPowlas]

Please see this screen shot as to how to determine your version - go to Analysis > Help > About

Regards,

Tammy

[bergbomb]

Thanks, I thought I looked there already...

Version is 1.4.0.2526

[TammyPowlas]

Would you please apply SP2 and then try again?

You have the initial version of 1.4

Regards,

Tammy