topic Re: SAS VA - Curve in graph not fitting the y-axis in SAS Visual Analytics

SAS VA - Curve in graph not fitting the y-axis

ChrHC — Fri, 04 Oct 2019 13:14:07 GMT

Hi SAS experts.

I have run in to a problem that i hope you guys can be helpful with.

I have recently calculated a monthly average and created a curve diagram with two axis.

However my average does not allign itself properly on the y-axis. It appears to "round up its location", but the data is however not rounded. (see picture below).

Does any have any idea what could cause this

Re: SAS VA - Curve in graph not fitting the y-axis

Sam_SAS — Mon, 07 Oct 2019 19:44:40 GMT

Hello,

The placement of the left Y axis line is centered because there is only one value. By coincidence, the center of your Y2 axis is close to the same value, but slightly different.

Depending on the version of VA that you have, you might be able to manually set the axis maximum and minimum values to be identical for the Y1 and Y2 axes.

(Actually, it may be simpler just to use a line chart that has a shared Y axis instead of separate Y1 and Y2 axes.)

Sam

Re: SAS VA - Curve in graph not fitting the y-axis

ChrHC — Tue, 08 Oct 2019 11:08:53 GMT

Hi, thank you for your reply Sam.

The users of this report will need to use a time filter at their leisure, which means the average will change depending on their choices.

So a fixed line is not an option.

I'm not sure that i understand why the line cannot setup on the y-axis based on one value?

Re: SAS VA - Curve in graph not fitting the y-axis

Sam_SAS — Tue, 08 Oct 2019 12:31:50 GMT

If you are using a dual-axis chart, try using the basic version instead (a basic Line Chart instead of a Dual-Axis Line Chart). This should help.

Re: SAS VA - Curve in graph not fitting the y-axis

ChrHC — Tue, 08 Oct 2019 13:15:53 GMT

Hi.

You are absolutely right. The line is now properly alligned.

You mention the ability to share an y-axis in your earlier post, can i ask you to elaborate a little on that method?

Thank you for your help!

Re: SAS VA - Curve in graph not fitting the y-axis

Sam_SAS — Tue, 08 Oct 2019 13:31:13 GMT

When I mentioned sharing an axis, I just meant using a basic line chart and applying both measures to the same axis. I don't think shared axes are possible in the dual-axis line chart (or dual-axis time series plot).