Chart Formatting

[sdchris]

Hello,

I have a chart with three variables plotted on a chart with two y-axis. Two variables are tied to the primary y axis, and the third is linked to the secondary y-axis. When the chart is displayed, the third, secondary axis variable shows up in between the two other variables. Is there a way to move the third variable, which is tied to the secondary axis, to the far right (i.e. closer to the secondary y axis)? Any ideas would be appreciated. Thanks!

 

[socool111]

could you post a picture of the chart (with mock data if need be)?

 

[sdchris]

could you post a picture of the chart (with mock data if need be)?

Sure thing. Click the link below. Basically, I'd like for the green bars to be on the far right of each group.

View image: Capture

 

[socool111]

Not quite sure how to do it as you like...but try right cliking the data points (the green bars), and change the data chart type, to a line graph...it might look better to how you want it