Hi Malurus,
You are on the right track here. Once you add the two variables to the y-axis, the trick is to use both the Bar and Line graphing elements. (drag and drop the 2nd element onto graph)
From there, modify which variable (current or historical rainfall) applies to which graphing element. To do this:
From lefthand panel, expand the Variables menu
Select historical for the Line element
Select current for the Bar element
You can also add the SE bars for the Bar element via this panel
You should end up with something like the image below (lefthand panel items indicated in red):
I cannot find a way to do it mannually but it seems to be possible via script. Try this (change to your own column names):
Graph Builder(
Variables( X( :Month ), Y( :MeanRainfall ), Y( :Rainfall, Position( 1 ) ) ),
Elements(
Bar(
X,
Y( 1 ),
Legend( 3 ),
Row order( 0 ),
Error Bars( "Standard Error" ),
Summary Statistic( "Mean" )
),
Line(
X,
Y( 2 ),
Legend( 3 ),
Row order( 0 ),
Error Bars( "Standard Error" ),
Summary Statistic( "Mean" )
)
)
);
Hi Malurus,
You are on the right track here. Once you add the two variables to the y-axis, the trick is to use both the Bar and Line graphing elements. (drag and drop the 2nd element onto graph)
From there, modify which variable (current or historical rainfall) applies to which graphing element. To do this:
From lefthand panel, expand the Variables menu
Select historical for the Line element
Select current for the Bar element
You can also add the SE bars for the Bar element via this panel
You should end up with something like the image below (lefthand panel items indicated in red):