
Members

June 25, 2016

See the attached image. This was while trying to create a horizontal bullet chart. I was totally done then realized that the tiny squares for the legend had somehow grown to long bars and I couldn't get them back to squares. I used Excel's Undo (2016) about 50 steps and saw when it happened - very early when I was adding and tweaking the Actual and Target data.
But even clicking Undo/Redo I couldn't figure out what it was I was doing. I finally gave up and started over, and got it right on the 2nd image. The bars in the legend were so big when I got to the point of resizing the actual bullet chart part, the legend wanted to take up 2 rows of data, which made it useless. The image shown below is when I clicked "redo." For some reason, Excel let me go back much further than it let me go forward so never got it back to the almost-final chart.
However, I'd like to know what I did to cause this, how to avoid, and how to fix.
The google did nothing for me when I searched for stuff along the lines of: change bar size excel legend: and similar keywords.
The stuff Peltier did to come up with this is nothing short of amazing... You really have to pay attention when you are in "Format Data Series" and "Format Data Point" when hiding markers in the chart but not the legend.
Most Users Ever Online: 57
Currently Online:
11 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Md. Rahman
Lilian Vo
Jane Kumwenda
David Miller
Efe Onwochei
LynAnn Williams
Brandy Kriger
purna chandar
E K
velissa barr
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas