Reversing axes on scatter chart

[#1]

Hello,

I am trying to reverse my X and Y axes on my scatter chart. (i.e. 0 - 100% should display as 100 - 0%). I would normally adjust sort order in a chart, but as in a scatter chart my dimensions are essentially expressions, and vice versa, I am at a loss as to how to do this.

In addition to reversing the order of both Cumulative Volume and CoV, I would like my X axis to be on the top of the graph and my Y axis to be on the right of the graph.

Thanks for your help!

M

[Michiel_QV_Fan · Accepted solution]

You could create negative values and format these to be shown without a '-' sign of () for minus.

[#3]

Excellent, thank you!

[#4]

Actually, Michiel, could you elaborate a little bit further please?

I was able to reverse my axes by adding a '-' in front of my expression, however I'm not sure how to achieve this without using the '-' sign, or how to hide it?

Thanks very much!

M

[Michiel_QV_Fan]

multiply your expression with -1 to create the negative values.

Go to number format and create a negative format just like the positive format:

fixed to: #,##0;#,##0

[Anonymous]

Hi Michiel,

I have multiplied the expression with -1 and now when I go to Number tab and select Fixed to  for y expression and change the format from #,##0 to #,##0;#,##0 , there is no change.

Can you please help me with this.

Thanks,

Niharika

[Michiel_QV_Fan]

Can you post some printscreens?

[#8]

Hi Niharika,

Make sure you check the following option on the chart properties.

Ex: If you would like to reverse Y axis, then Check Static Max option and set to 0 for that particular axis.

[Anonymous]

Thanks Swetha,

That's really helpfull.