Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 200078 - Last Review: September 27, 2003 - Revision: 3.1
XL2000: #N/A Chart Label Issues
This article was previously published under Q200078
In a Microsoft Excel chart, a data label with a #N/A value in a column chart obscures the label next to it.
The grab handles for the #N/A label appear in the upper-left corner of the plot area of the chart, but the #N/A label is displayed on top of the label in the column to its immediate left.
To work around this issue, delete or move the #N/A label. Because the grab handles for the #N/A label appear near the upper-left area of the plot area of the chart, you must cause the label and grab handles to join before you can delete or move the label.
To move or delete a label with a value of #N/A, follow these steps:
- Type the following data in a new Excel worksheet:
A1: A B1: B C1: C D1: D E1: E
A2 1 B2: 2 C2: 3 D2: 4 E2: 5
- In cell D2, type the following formula:
=NA()
Cell D2 now contains the value #N/A. - Select cells A1:E2.
- Click Chart Wizard on the standard toolbar.
- In step 1 of the Chart Wizard, accept the defaults, and then click Next.
- In step 2 of the Chart Wizard, accept the defaults, and then click Next.
- In step 3 of the Chart Wizard, on the Data Labels tab, click Show value, and then click Finish.
Note that the label "#N/A" obscures the label "3" in column C. - Click any column label to make the label grab handles appear.
Note that the grab handles for #N/A appear in the upper-left section of the plot area of the chart. - Click #N/A to select the #N/A label.
- Click the area inside the #N/A grab handles (upper-left section of the plot area).
Note that the grab handles disappear and that #N/A appears instead of the grab handles. - Click the #N/A label that obscures column C.
Note that the #N/A label disappears. - Click any column label to make the label grab handles appear.
- Click the #N/A in the upper-left section of the plot area.
Press DELETE to delete the label, or drag the label where you want.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
APPLIES TO
- Microsoft Excel 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate