Need help with charts in BEx

[Former Member]

I am having some problems with charts. when I refresh, all my formatting for the x axis and source data is lost. I need to have the x axis display month and plant but when i hit refresh it goes back to just showing month. Any ideas??

[Former Member]

I discovered that i you right click on the whole graph, not just the inner portion it will save the data.

Thanks

[Former Member]

Hello,

Unfortunately we can not solve it that way.

I have a worksheet with a table and a connected chart.

After swapping the axis, saving and refreshing, I still have the same effect that the axis were switched back.

Can you please describe how you achieved it?

Are there any other ideas?

We have tried several sequences for saving and switching - without success.

Thanks in advance for response

[Former Member]

Hi Mick,

Once you make teh changes save the workbook. Try refreshign wht workbook after saving it.

Hope it helps...

[Former Member]

I did that ans saved as workbook but when I hit refresh all is lost again