Solved

Stacked Bar Chart looses data when changing a specific horizontal axis value

Posted on 2012-12-21
2
273 Views
Last Modified: 2012-12-22
Stacked-Bar-Weirdness.xlsx I have a stacked bar chart that I put together.    When I change a specific value on the horizontal axis most of the bars seem to vanish.    The values are based on a series of month/year dates.   In the attached sample, change the word "test" in Cell AW4 to the correct date (12/2010) and watch what happens to the bar charts.  They all seem to vanish except one.  I have constructed this bar chart several times and still come up with the same problem and it seems to always be the values in the vicinity of AW.
0
Comment
Question by:StevenPMoffat
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 150 total points
ID: 38714023
I really do not understand this but if you do want to enter the correct the date in that cell and in any of the blank cells on row 4 (say AX4) enter a text value which is not visible (a space).

Apparently the treatment for text cells is different from the treatment for numeric cells. If all of the used cells in row4 are numerical then the the list is considered numerical and is treated differently.

On the other hand if any of the used cells is not numerical then all are considered as text and are reproduced as-is on the chart.
0
 

Author Closing Comment

by:StevenPMoffat
ID: 38715552
Provided a good workaround.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now