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

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


<(E-Mail Removed)> wrote in message
news:81032983-43a2-405f-afda-(E-Mail Removed)...
>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

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


On Feb 5, 9:15 am, "Jon Peltier" <jonxlmv...@SPAMpeltiertech.com>
wrote:
> What kind of chart is it, and are the X values for the two series?
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. -http://PeltierTech.com
> _______
>
> <ryan.fitzpatri...@safeway.com> wrote in message
>
> news:81032983-43a2-405f-afda-(E-Mail Removed)...
>
> >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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


<(E-Mail Removed)> wrote in message
news:e1047cc0-af3f-4423-8d8b-(E-Mail Removed)...
> It's a bar chart, both y and x axis have data on them
>
>
> On Feb 5, 9:15 am, "Jon Peltier" <jonxlmv...@SPAMpeltiertech.com>
> wrote:
>> What kind of chart is it, and are the X values for the two series?
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Tutorials and Custom Solutions
>> Peltier Technical Services, Inc. -http://PeltierTech.com
>> _______
>>
>> <ryan.fitzpatri...@safeway.com> wrote in message
>>
>> news:81032983-43a2-405f-afda-(E-Mail Removed)...
>>
>> >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
>

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.

On Feb 5, 11:04 am, "Jon Peltier" <jonxlmv...@SPAMpeltiertech.com>
wrote:
> 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
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. -http://PeltierTech.com
> _______
>
> <ryan.fitzpatri...@safeway.com> wrote in message
>
> news:e1047cc0-af3f-4423-8d8b-(E-Mail Removed)...
>
> > It's a bar chart, both y and x axis have data on them
>
> > On Feb 5, 9:15 am, "Jon Peltier" <jonxlmv...@SPAMpeltiertech.com>
> > wrote:
> >> What kind of chart is it, and are the X values for the two series?
>
> >> - Jon
> >> -------
> >> Jon Peltier, Microsoft Excel MVP
> >> Tutorials and Custom Solutions
> >> Peltier Technical Services, Inc. -http://PeltierTech.com
> >> _______
>
> >> <ryan.fitzpatri...@safeway.com> wrote in message
>
> >>news:81032983-43a2-405f-afda-(E-Mail Removed)...
>
> >> >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