SSRS chart Y axis

I want to update this y axis so that it makes sense for my data ... probable 0 through 100% instead of 0 -> 80000 as it is showing noe
vbnetcoderAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nico BontenbalCommented:
What y-axis?
You can use this expression for the value to calculate the percentage of the maximum value in the dataset:
=Fields!nr.Value/max(Fields!nr.Value,"dset")

Open in new window

nr is the field name "dset" the name of the dataset. But you can also divide by 80000 to use that value as the 100% always. This will give you values from 0 to 1. Set the format of the y axis to Percentage to show this value as a percentage. You can set the minimum and maximum properties of the axis to 0 and 1 to always have 0 to 100% on the axis.
0
vbnetcoderAuthor Commented:
Where do i put these expressions?
0
Nico BontenbalCommented:
When the chart is selected in design you see a 'Chart Data' box next to the chart. In the values box click the bottom down arrow and select Expression. There you can enter the expression to use for the value.
You can also right click the series (line, bar or whatever) in the chart and choose 'Series Properties'. Click the expression button behind the Value field box.
If you want the 100% to be the maximum value in your recordset use the expression from my previous answer. If you want the percentage of 80000 then use this expression:
=Fields!nr.Value/80000

Open in new window


Right click the y-axis and select 'Vertical Axis Properties' to change the properies of the axis. In the Axis Options section you can set the minimum and maximum. In the Number section you can set the Percentage.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vbnetcoderAuthor Commented:
ty
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.