| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help on visible data | Excel Discussion (Misc queries) | |||
| Visible Data | Excel Discussion (Misc queries) | |||
| Return the first visible cell below filter labels | Excel Worksheet Functions | |||
| how do I sum only visible data in a column | Excel Discussion (Misc queries) | |||
| Autoshapes not visible on spreadsheet but visible in print preview | Excel Discussion (Misc queries) | |||
Linear Mode
