Skip to Content

Dynamic Charts in Analysis for office

Hi Floks

I have a requirement where user requires dynamic charts based on the selection(Prompts which are coming from bex) provided by the user that to on different level 1) on level 3 nodes line charts and 2) on level 4 nodes pia charts.

Workbook is build on bex query.

I have created the excel chart which is cell based chart, But when user changes the category then chart is also chaining.

Hope i am clear please let me know if you need more information from my end.



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Aug 30, 2018 at 01:39 PM

    Hi Mohammed,

    You may want to use chart UI elements from Analysis tab instead of using excel chart option that references specific excel cells. Also, you can convert a default crosstab into chart. It appears that you have two separate charts for the same report, in that case you can add the same report twice and display the report results using Analysis Charts.

    Hope this helps.


    Add comment
    10|10000 characters needed characters exceeded