View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Bar graph -bars not evenly spaced

bar or column
I have 2003 XP
I do not see a problem with mine

which column (I think) is wrong

"Sarah Marriott" wrote:

Hi,

I have a simple bar graph which has 4 series but about 99 data points (i.e.
there are 99 bars shown.) My problem is that the bars are not evenly spaced
within the chart, so I don't get a nice graph. One series, consistently, is
about 2 pixels right of it's 'area'. I cannot find an option to centre the
bar above its description.
Changing the bar's borders does not work, changing the size of the graph
does not work. Changing the Overlap or Gap Width options does not work either!

Any ideas?

This problem has been found on both Excel 2002(XP) and Excel 2007.

Do I have too many bars for excel to cope with?

TIA

Sarah