cancel
Showing results for 
Search instead for 
Did you mean: 

WEBI report present different in exported excel file

Former Member
0 Kudos

Hello expert,

I create a line chart in webi, and I create a table block to cover the x axies label for the line chart. this presentation looks perfect in WEBI report, but when I export it into excel file, the x axies labels for the line chart showed up with that table block moved down a little bit. how can I present WEBI in the same way in the exported excel file?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Charting is an area of BO that isn't great in XI3.1 but has been greatly improved in BO4.0

That doesn't help you now, I know but at least you know it's not you!

When Webi saves to Excel it actually saves it as an Excel formatted file rather than as a pure Excel file so there will be a few features that are not replicated correctly.

Answers (1)

Answers (1)

amitrathi239
Active Contributor
0 Kudos

Hi,

If your requirement is to hide labels or X Axis values from the chart ..You can do this directly unchecked the check box for values or labels from the X Axis properties.

For to adjust the table block and line chart right click on the Cell go to Align ->Relative Position and in the bottom section adjust the height from the particular block.

Hope this helps you.

Thanks,

Amit