How do I set the range for the PrimaryYAxis? The max value on the Y axis varies depending on the total cost value.
If total cost value is something like $1 million, I want the Y Axis range to be like $0, $200,000.00, $400,000.00, $600,000.00, $800,000.00 and $1 million.
If the total cost value is $10 million, I want the Y axis range to be $0, $2million, $4million, $6million, $8million ad $10 million.
If the total cost value is $500,000.00, I want the Y axis range to be $0, $100,000.00, $200,000.00,$300,000.00,$400,000.00 and $500,000.00 and so forth.
I always want it to start from $0 (minimum).
What properties do I need to use to achieve this output? Please help.
Thanks!