Bar Graph Problems

[mrscucch]

I keep trying to make a bar graph for some financial data. For some reason when I select the data, all the verticle bars lump together in the middle of the horizontal axis... How can I get them to spread out and use up the whole area?

Also why cant you get lead lines on bar graphs like you can on pie charts?

And lastly... if I want to do a 3 year spread on data in one bar graph.. I dont seem to be able to get it to go in the order I want.

Id like it to go 2007 Category 1, 2008 Category 1, 2009 Category 1
and then 2007 Category 2, 2008 Category 2, 2009 Category 2

you get the idea... it keeps putting the years together and then the categories together and wont group them the way I want to.

[Andy Pope]

most of your problems are probably related to your data layout.

Can you post example workbook