User (Legacy) Posted October 24, 2006 Author Report Share Posted October 24, 2006 Hi, Have a chart that displays a percentage. Sometimes the percentage is 100% I really don't need the Y axis to show 0 - 100% 50 - 100% is ok. But, sometimes the value of 30%, so I would like the scale to be 0% to 50% Is there any way to do this in Reporting Services charts? Thanks, Chris Exley Link to comment Share on other sites More sharing options...
User (Legacy) Posted October 24, 2006 Report Share Posted October 24, 2006 Hi, Have a chart that displays a percentage. Sometimes the percentage is 100% I really don't need the Y axis to show 0 - 100% 50 - 100% is ok. But, sometimes the value of 30%, so I would like the scale to be 0% to 50% Is there any way to do this in Reporting Services charts? Thanks, Chris Exley Link to comment Share on other sites More sharing options...
Software FX Posted October 24, 2006 Report Share Posted October 24, 2006 Well the key word here is "sometimes". There is a property in the axis called ForceZero that you can turn off, this way if your values go from 50 to 100 the scale will go from 50 to 100, but if your values go from 0 to 30 the scale will go from 0 to 30. -- Francisco Padron www.chartfx.com Link to comment Share on other sites More sharing options...
Software FX Posted October 24, 2006 Report Share Posted October 24, 2006 Well the key word here is "sometimes". There is a property in the axis called ForceZero that you can turn off, this way if your values go from 50 to 100 the scale will go from 50 to 100, but if your values go from 0 to 30 the scale will go from 0 to 30. -- Francisco Padron www.chartfx.com Link to comment Share on other sites More sharing options...
User (Legacy) Posted October 24, 2006 Author Report Share Posted October 24, 2006 Hi Francisco, Thanks for the reply. I tried that. 5 data points in my series. All at 100%. Using an Olap Datasource (not that it should matter) AxisX labels are: Q4-05, Q1-06, Q2-06, Q3-06, Q4-06 Values for each are 100%. Chart show 0%, 20%, 40%, 60%, 80%, 100% on Y axis. AxisY.min = Auto AxisY.max = Auto LabelsFormat = Percentage Scale Unit =1 Step=0 Can you send me picture that shows it works for you? "SoftwareFX Support" <noreply@softwarefx.com> wrote in message news:CvUbSB69GHA.332@webserver3.softwarefx.com... > Well the key word here is "sometimes". > > There is a property in the axis called ForceZero that you can turn off, > this way if your values go from 50 to 100 the scale will go from 50 to > 100, but if your values go from 0 to 30 the scale will go from 0 to 30. > > -- > Francisco Padron > www.chartfx.com > Link to comment Share on other sites More sharing options...
User (Legacy) Posted October 24, 2006 Author Report Share Posted October 24, 2006 Hi Francisco, Thanks for the reply. I tried that. 5 data points in my series. All at 100%. Using an Olap Datasource (not that it should matter) AxisX labels are: Q4-05, Q1-06, Q2-06, Q3-06, Q4-06 Values for each are 100%. Chart show 0%, 20%, 40%, 60%, 80%, 100% on Y axis. AxisY.min = Auto AxisY.max = Auto LabelsFormat = Percentage Scale Unit =1 Step=0 Can you send me picture that shows it works for you? "SoftwareFX Support" <noreply@softwarefx.com> wrote in message news:CvUbSB69GHA.332@webserver3.softwarefx.com... > Well the key word here is "sometimes". > > There is a property in the axis called ForceZero that you can turn off, > this way if your values go from 50 to 100 the scale will go from 50 to > 100, but if your values go from 0 to 30 the scale will go from 0 to 30. > > -- > Francisco Padron > www.chartfx.com > Link to comment Share on other sites More sharing options...
Software FX Posted October 25, 2006 Report Share Posted October 25, 2006 This is normal. What are you expecting to see in the Y-Axis ? If you don't want the zero you need to set: ForceZero = false -- Francisco Padron www.chartfx.com Link to comment Share on other sites More sharing options...
Software FX Posted October 25, 2006 Report Share Posted October 25, 2006 This is normal. What are you expecting to see in the Y-Axis ? If you don't want the zero you need to set: ForceZero = false -- Francisco Padron www.chartfx.com Link to comment Share on other sites More sharing options...
User (Legacy) Posted October 25, 2006 Author Report Share Posted October 25, 2006 If I set ForceZero = False, and all values are at 100% I have seen both of these things happen. 1) All values are shown at the lowest x axis gridline with no context, there are no values shown on the Y axis. 2) 0, 20, 40, 60, 80, 100 are shown on the Y axis and the Lines are at the top. What I would love to be able to do is to set the AxisY.min = Lowest Value Returned (25%) and he AxisY.max = 100% Can I do that? "SoftwareFX Support" <noreply@softwarefx.com> wrote in message news:U9AZp3G%23GHA.1788@webserver3.softwarefx.com... > This is normal. What are you expecting to see in the Y-Axis ? > > If you don't want the zero you need to set: > > ForceZero = false > > -- > Francisco Padron > www.chartfx.com > Link to comment Share on other sites More sharing options...
User (Legacy) Posted October 25, 2006 Author Report Share Posted October 25, 2006 If I set ForceZero = False, and all values are at 100% I have seen both of these things happen. 1) All values are shown at the lowest x axis gridline with no context, there are no values shown on the Y axis. 2) 0, 20, 40, 60, 80, 100 are shown on the Y axis and the Lines are at the top. What I would love to be able to do is to set the AxisY.min = Lowest Value Returned (25%) and he AxisY.max = 100% Can I do that? "SoftwareFX Support" <noreply@softwarefx.com> wrote in message news:U9AZp3G%23GHA.1788@webserver3.softwarefx.com... > This is normal. What are you expecting to see in the Y-Axis ? > > If you don't want the zero you need to set: > > ForceZero = false > > -- > Francisco Padron > www.chartfx.com > Link to comment Share on other sites More sharing options...
Software FX Posted October 26, 2006 Report Share Posted October 26, 2006 > What I would love to be able to do is to set the AxisY.min = Lowest Value > Returned (25%) and he AxisY.max = 100% > Can I do that? I don't understand. You said tall values were 100% so where does 25% comes from ? -- Francisco Padron www.chartfx.com Link to comment Share on other sites More sharing options...
Software FX Posted October 26, 2006 Report Share Posted October 26, 2006 > What I would love to be able to do is to set the AxisY.min = Lowest Value > Returned (25%) and he AxisY.max = 100% > Can I do that? I don't understand. You said tall values were 100% so where does 25% comes from ? -- Francisco Padron www.chartfx.com Link to comment Share on other sites More sharing options...
User (Legacy) Posted October 27, 2006 Author Report Share Posted October 27, 2006 When I have a bubble chart and don't set the upper limit then the highest bubble get cut in half is there any possibility to fix that ..... Link to comment Share on other sites More sharing options...
User (Legacy) Posted October 27, 2006 Author Report Share Posted October 27, 2006 When I have a bubble chart and don't set the upper limit then the highest bubble get cut in half is there any possibility to fix that ..... Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.