LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 19th 14, 10:45 PM posted to microsoft.public.excel.charting
external usenet poster
First recorded activity by ExcelBanter: Aug 2014
Posts: 1
Default Inside Base Series Label Showing #N/A

I have two bar charts that are displaying percentages if the data exists and does not return #N/A. When I select to use data labels and have them "Inside End," they appear exactly how I want with no #N/A. However, when I change the location to "Inside Base," all #N/As appear. The strange thing is that one of the charts is pulling the same data but does not show #N/As no matter where the data labels are. I don't know how to edit individual charts to trigger the showing or hiding of #N/As.

I realize I could just recreate every chart with the one that is working, but there are about 80 charts and that would take forever. Is there an on/off switch for showing Data Labels that have #N/A and hiding them? The two data sets are identically formatted and I know for a fact that the problem is something with the settings of the chart since if I change the source for the one that is working, it still works.

Thank you for your help.

Michael Wurth

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
How create a formula series with series inside Ric Excel Worksheet Functions 3 September 16th 09 03:09 AM
values 'inside 'base' in a bar chart Connie Charts and Charting in Excel 1 August 14th 09 04:55 AM
Macro: how to create label forms inside the worksheet not userform [email protected] Excel Programming 2 June 26th 08 07:37 AM
X Axis only showing label from a range JDB Charts and Charting in Excel 1 July 6th 07 08:22 PM
Form label not showing Les Stout[_2_] Excel Programming 0 October 17th 06 11:00 AM

All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017