We help IT Professionals succeed at work.

Charts determine interval for Major Grid lines

2,183 Views
Last Modified: 2012-05-05
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
Comment
Watch Question

This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
byundtMechanical Engineer
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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

Author

Commented:
I think I can use both of your suggestions to come up with what I'm looking for
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.