Solved
Contributor
Posts: 39

# Proc Gchart Raxis error : Order= clause on the axis statement is not valid. The default axis used

Hi,

I have Raxis values ranging from -80 to 0 in proc gchart.

i specified as

axis2 order = (-70 to 0 by -10)
offset=(0,0)
minor = none
value = (h=1);

but i log i see

"WARNING: Order= clause on the axis statement is not valid. The default axis values will be used."

i'm getting -60 to 0 range values in output. not from -80 to 0.

please help.

Accepted Solutions
Solution
‎07-01-2016 08:50 PM
Super User
Posts: 12,316

## Re: Proc Gchart Raxis error : Order= clause on the axis statement is not valid. The default axis use

Use

``````axis2 order = (-70 to 0 by 10)
offset=(0,0)
minor = none
value = (h=1);``````

The code you originally showed in effect tells SAS to: start the left hand side at a value of -70, decrease by 10 at each step to the right and end at 0.

Since the default axis shows -60 I actually doubt that you have values of -80 to display. And if you want to see -80 then starting at -70 would exclude them. To see -80 when you specify an order list then you need to make the upper and lower bounds such that the expected values are displayed.

All Replies
Solution
‎07-01-2016 08:50 PM
Super User
Posts: 12,316

## Re: Proc Gchart Raxis error : Order= clause on the axis statement is not valid. The default axis use

Use

``````axis2 order = (-70 to 0 by 10)
offset=(0,0)
minor = none
value = (h=1);``````

The code you originally showed in effect tells SAS to: start the left hand side at a value of -70, decrease by 10 at each step to the right and end at 0.

Since the default axis shows -60 I actually doubt that you have values of -80 to display. And if you want to see -80 then starting at -70 would exclude them. To see -80 when you specify an order list then you need to make the upper and lower bounds such that the expected values are displayed.

Contributor
Posts: 39

## Re: Proc Gchart Raxis error : Order= clause on the axis statement is not valid. The default axis use

Awesome thanks
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
• 2 replies
• 247 views
• 0 likes
• 2 in conversation