Y2 Data Labels Not Visible

I have a chart with 2 lines and 1 bar-series. One of the lines and the bars
are plotted against the Y2 Axis. I can view data labels for the line plotted
against the Y1 axis and the bars plotted against the Y2 Axis, but not the
line-series potted against the Y2 Axis. Help?

Can anyone answer this?

"Woody" wrote:

> I have a chart with 2 lines and 1 bar-series. One of the lines and the bars
> are plotted against the Y2 Axis. I can view data labels for the line plotted
> against the Y1 axis and the bars plotted against the Y2 Axis, but not the
> line-series potted against the Y2 Axis. Help?

Hi,

If you want to email the file, andy AT andypope DOT info
I will take a look.

Let me know which xl version you are using.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Woody" <Woody@discussions.microsoft.com> wrote in message
news862E731-6A81-4FC3-9D97-D4275E6D5506@microsoft.com...
> Can anyone answer this?
>
> "Woody" wrote:
>
>> I have a chart with 2 lines and 1 bar-series. One of the lines and the
>> bars
>> are plotted against the Y2 Axis. I can view data labels for the line
>> plotted
>> against the Y1 axis and the bars plotted against the Y2 Axis, but not the
>> line-series potted against the Y2 Axis. Help?

Thanks Andy... actually I figured it out. The Y2 Line had a different x-axis
label range than the Y2 Bar and Y1 Line. When I re-defined the same range
for the Y2-Line its data labels appeared.

That's right, no typo, it was the x-axis label range that allowed me to view
the Y2 data points as labels. Excel '07, .xlsx file. Just emailed the file.

"Andy Pope" wrote:

> Hi,
>
> If you want to email the file, andy AT andypope DOT info
> I will take a look.
>
> Let me know which xl version you are using.
>
> Cheers
> Andy
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
> "Woody" <Woody@discussions.microsoft.com> wrote in message
> news862E731-6A81-4FC3-9D97-D4275E6D5506@microsoft.com...
> > Can anyone answer this?
> >
> > "Woody" wrote:
> >
> >> I have a chart with 2 lines and 1 bar-series. One of the lines and the
> >> bars
> >> are plotted against the Y2 Axis. I can view data labels for the line
> >> plotted
> >> against the Y1 axis and the bars plotted against the Y2 Axis, but not the
> >> line-series potted against the Y2 Axis. Help?
>