BI WAD Chart Overlay

[Former Member]

Hi,

Is there a option in BI WAD to overlay muliple charts on each other. I want to display stacked columns chart with total line connecting stacked columns. Since my stacked columns are dynamic, I'm not able to determine the series for the line display. One option I thought of is having 2 charts, one showing stacked columns and other showing total line. Then make the line chart transparent and overlay charts on each other.

Is it possible in WAD? Has anyone worked on this. Any example would be helpful.

Thanks,

Milind

[Former Member]

Hi,

Each Key figure column will be acting as a series and you can do the necessary changes to the requirement by going for the refine option and from there series you can do the changes there.

Regards,

Suresh

[Former Member]

Thanks. I can't use Refine option as my no of columns are dynamic and is driven by Fiscal period entered by the user. Total is last column but can be any column. How to decide which series to define as line.

Thanks,

Milind