Y2 Data Labels Not Visible

[Woody]

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?

 

[Woody]

Can anyone answer this?

 

[Andy Pope]

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

 

[Woody]

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.