asked on

Charts determine interval for Major Grid lines

What is the calculation used when charts determined the interval for the y axix major grid lines? I'm creating SSRS report which includes a chart. I want more Major grid lines than what is displayed by the auto generated. So I want to write an expression in the Major grid line interval. I can't use a set value because my data ranges will change. Example: Base on user selection values can range from -3000 to 4000 or 0 to 600. Wont know til run time. But with those two examples, I should have interval of 1000 for the first example and 100 for the other. What the auto generated lines are at 2000 for the first example.
So If I knew the calculation used, I figure I could write an expression. Thanks in advance

ASKER CERTIFIED SOLUTION

patrickab

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

byundt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

MadIce

ASKER

Thanks for the replys. I'm using BIDs to create these reports which I'm new at using and just found where I can use code on my reports. I thought I could only use an expression. I need to read up on using the code tab and then I will try the suggestions. It will be a few days...Thanks

MadIce

ASKER

I think I can use both of your suggestions to come up with what I'm looking for