Tuesday, May 5, 2020

How Did I Do This?

In Excel, I inserted a column chart, and initially it put the legends below the axis sort of hodge podge like this:

Somehow I changed it to look like this:

And because I added TRAIN as a weapon, I need to either update this chart to use the new set of cells or change the hodge podge legend.


  1. Looks to me like what you did was put each weapon type in as X-axis labels.

  2. The second view or legend is much more understandable that the first. It's been awhile since I did Excel charts, so I don't remember how to switch between the two, but it may have to do with the actual size of the graphed area. If there is not enough room to have the labels directly below the bars (second view in your post), it may automatically generate a legend where each color or pattern is identified (first view in your post).