Hi there,
I've recently built a dynamic chart.
How it works is that there's a table with 20 columns of sales of different products, and a column for month.
In cognos, I added 1 more field which is a calculated field. Based on a dropdown, it chooses the value of the correct column.
The Y-Axis is already dynamic, from 0 to the max potential value. My analyst would like me to change the minimum value to 10% below the lowest y value.
Is there a way to dynamically change the min value on the Y-axis?
Thanks,
Eric
I'm not sure that there's any way to set the Y-axis range to a user-defined dynamic range, but if you click on the Y-axis line (the thin black vertical line next to the Y-axis label), there's an Axis Range parameter in the Properties window. If you un-check "Include zero", it will dynamically determine the minimum Y value.
I guess my suggestion worked then...?
Worked perfectly.
Without the zero value, gives me a starting point a bit below my lowest value. Dunno if it's 10%, but it'll do.
Thanks!