On Office 07 (I believe) I am trying to make a few simple bar graphs. They consist of various economic
indicators for various nations. Example:
When I attempt to produce a bar graph of the data, the Country field is listed as the Y axis and the Score on
the X (bars grounded on the left side of the screen pointing right). For my use it would make more sense to have them the
other way (bars on the bottom of the screen pointing up).
The most apparent logical solution was the "switch
rows/columns" function. However, this merely keeps the bars on the left and changes the appearance of the bars, as well
as removing the bars for entries with a score of 0.
My second attempt was to place the data in rows rather than
7| 5| 7
which still produced the same graph
As far as I can tell, from Microsoft help, searching this forum, and the
broader internet, the problem is that I need to make the category variable (Country) on the horizontal axis, and do the
opposite to the value variable. I have not been able to find a logical way to make that occur either online or through
experimentation. How can I fix this