Conservative. Idaho. Software engineer. Historian. Trying to prevent Idiocracy from becoming a documentary.
Email complaints/requests about copyright infringement to clayton @ claytoncramer.com. Reminder: the last copyright troll that bothered me went bankrupt.
"And we know that all things work together for good to them that love God, to them who are the called according to his purpose." -- Rom. 8:28
Pages
▼
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.
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).
Looks to me like what you did was put each weapon type in as X-axis labels.
ReplyDeleteThe 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).
ReplyDelete