X-Axis Scale Issue on Chart?

[Rohini Suryawanshi]

Hi,

Could please help me to change the Axis range scale value of X-axis? When I click on X-axis, it doesnt show me the properties. As we can change the properties for Y-axis but for X-axis Scale issue on chart it doesnt help. Please suggest for the same.


Regards,
Hermoine Granger.

[MFGF]

Hi,

Could please help me to change the Axis range scale value of X-axis? When I click on X-axis, it doesnt show me the properties. As we can change the properties for Y-axis but for X-axis Scale issue on chart it doesnt help. Please suggest for the same.


Regards,
Rohini Suryawanshi

Hi,

Doesn't it depend on the chart type whether or not it makes sense to have an axis range on the X axis? For example, there would be no point in a column chart, since the measures are displayed in the vertical plane. It would make sense in a bar chart, where the measures are displayed in a horizontal plane, and indeed you can define the axis range for one of these.

MF.

[Rohini Suryawanshi]

Sorry,

But didnt understand, what you are trying to say. But as we can change the scale of Y-axis in Column Chart and cannot change of X-axis. In Bar graph also, for one axis we can change but if I want to change the scale of both the axis i.e X and Y in same graph how to achieve it. Please suggest.


Regards,
Hermoine Granger

[MFGF]

Sorry,

But didnt understand, what you are trying to say. But as we can change the scale of Y-axis in Column Chart and cannot change of X-axis. In Bar graph also, for one axis we can change but if I want to change the scale of both the axis i.e X and Y in same graph how to achieve it. Please suggest.


Regards,
Rohini Suryawanshi.

Hi,

In a column chart, the height of the columns is based on the measure value(s), but the width of the columns is not. Since the width is not based on measure values, how can it make any sense to change the scale of the X axis? Can you explain?

MF.

[Rohini Suryawanshi]

Yes.. what you are saying is right. But if we want to create a graph in this way like I have attached a file as sample. How to create it or Is there another way please suggest me.


Regards,
Hermoine Granger

[BigChris]

This looks remarkably similar to a topic posted the other day...are you known by any other name Hermione??

[MFGF]

Yes.. what you are saying is right. But if we want to create a graph in this way like I have attached a file as sample. How to create it or Is there another way please suggest me.


Regards,
Hermoine Granger

Hi,

There is no facility to do this in a single chart - for the reasons mentioned above (that you agree are right) :)

Did you change your user name? Hermoine or Hermione? Made me smile :)

Dumbleodre.

[Lynn]

You've created a couple other posts that seem to be related to the same problem, so I'm making some assumptions here based on all those posts and not just this one.

Your issue is that you want to use a measure as an X-Axis category and then have a different measure on the Y-Axis. Since it appears you only what whole number percentages as categories along the X-Axis, you can cast that figure to varchar and use it as your X-axis categories. Of course there is still no changing of the scale in this case, it will simply present the figures that get computed by your calculation based on the data coming into the query.

Attached is a report spec created off the great outdoors GO Sales (query) package to illustrate the concept. Not sure if this will get you exactly where you need to be but there might be some ideas that point you into the right direction.

[MFGF]

You've created a couple other posts that seem to be related to the same problem, so I'm making some assumptions here based on all those posts and not just this one.

Your issue is that you want to use a measure as an X-Axis category and then have a different measure on the Y-Axis. Since it appears you only what whole number percentages as categories along the X-Axis, you can cast that figure to varchar and use it as your X-axis categories. Of course there is still no changing of the scale in this case, it will simply present the figures that get computed by your calculation based on the data coming into the query.

Attached is a report spec created off the great outdoors GO Sales (query) package to illustrate the concept. Not sure if this will get you exactly where you need to be but there might be some ideas that point you into the right direction.

Marvellous!

By the way, is that you, Professor McGonaglal? :)

MF.

[Rohini Suryawanshi]

Hi Lynn,

Thanks for replying.. But what have you attached is difficult for me to understand because I am in learning stage of using Report studio. It would be greatful if you will please elaborate it.

[Lynn]

Hi Lynn,

Thanks for replying.. But what have you attached is difficult for me to understand because I am in learning stage of using Report studio. It would be greatful if you will please elaborate it.

The XML I attached can be opened in Report Studio. You may need to point the report to wherever your sample models are installed. Even if you don't have the samples installed you can still see what the report is doing.

Did you open the spec in Report Studio? Is there a specific area that you want me to elaborate on? The main idea is to cast your percentage numbers as strings so that you can use them on the X axis as categories.