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?

Y2 Data Labels Not Visible
 

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?

Y2 Data Labels Not Visible
 

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" wrote in message
...
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?

Y2 Data Labels Not Visible
 

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" wrote in message
...
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?