Forum Discussion

aelmehelmi's avatar
aelmehelmi
New Contributor II
2 years ago

Use minimum and maximum range value on waterfall chart

When using the minimum range value in  a waterfall chart, e.g. (10) that excludes all series values that are lower than 10. Is there a way to keep those values under (10) while using the minimum and max ranges to make the chart show the small value variations with a decent scale for the eye?

thanks!

  • aelmehelmi's avatar
    aelmehelmi
    New Contributor II

    I tried the scale break option for Y-axis and I am getting the results I was hoping for. 

  • BenThompson's avatar
    BenThompson
    New Contributor III

    Aelmehelmi,

    I don't have enough detail as to what you are trying to accomplish.  Are you trying to do this through OneStream charts for a dashboard, or just in excel?  If the output you desire can be in excel, I would design the chart in excel and use XFGetCell to pull in the data from OneStream you need.  If you have to do it in OneStream charts for a dashboard, then I am not sure on a solution for you.  I hope this helps.

    Thank you,

    Ben