Avatar of StevenPMoffat
StevenPMoffat
 asked on

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

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.
Microsoft Excel

Avatar of undefined
Last Comment
StevenPMoffat

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Saqib Husain

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
StevenPMoffat

ASKER
Provided a good workaround.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck