Excel 2010 Barchart Problems
Posted: Sat Sep 20, 2014 6:53 am
I'm seeing a number of problems when I try to create a bar graph of the following Excel 2010 data:
Region Cow Sheep Goat W Buf Blend
Abruzzo 6 2 4 1 8
Lazio 7 8 3 5 7
Marche 8 6 5 6 9
Molise 5 6 5 4 8
Tuscana 15 15 15 15 15
Umbria 7 8 5 3 6
When the chart first appears, the X headings are offset to the right causing me to have to manually change the label values to shift them back left where they belong.
In trying to change the colors of bars, right clicking a bar sometimes brings a pop up with "color" in it, sometimes not. If I do get the popup with "color" and change color, the color of a different bar (other than the one clicked) changes.
Can anyone help with these? Thanks very much.
Region Cow Sheep Goat W Buf Blend
Abruzzo 6 2 4 1 8
Lazio 7 8 3 5 7
Marche 8 6 5 6 9
Molise 5 6 5 4 8
Tuscana 15 15 15 15 15
Umbria 7 8 5 3 6
When the chart first appears, the X headings are offset to the right causing me to have to manually change the label values to shift them back left where they belong.
In trying to change the colors of bars, right clicking a bar sometimes brings a pop up with "color" in it, sometimes not. If I do get the popup with "color" and change color, the color of a different bar (other than the one clicked) changes.
Can anyone help with these? Thanks very much.