Chart 2ndary axis issue

[ryan.fitzpatrick3]

I have a chart that has a 2ndary axis, the 2ndary data is centered in
the middle of the chart, since I'm doing a variance, but when I put
the 2ndary data up on the y axis the chart 2ndary data reformats and
moves to the right side of the chart. My question is how do I keep the
chart bars in the middle with the labels on the right side of the
chart? I can send an example if needed if I'm not clear.

Ryan

 

[Jon Peltier]

What kind of chart is it, and are the X values for the two series?

- Jon

 

[ryan.fitzpatrick3]

It's a bar chart, both y and x axis have data on them

 

[Jon Peltier]

Horizontal bar? If so then the horizontal axis is the Y axis.

And I was asking what data was used for the categories of the two series. Is
it the same data or different data?

- Jon

 

[ryan.fitzpatrick3]

Sorry, it is a horizontal chart, with different data. The bottom has
the months, the top has the price variance with 0 in the middle, the
left side has the items and the right side has the variance price
difference. I can send you an example of it if you'd like.