Only Half of First Bar is Showing

[klam]

I wanted to have the tick on the x-axis right over the label so I lurked from
another post (Andy) the following:

"Double click the category axis and on the scale tab uncheck,
Value (Y) axis crosses between categories.
This will mean adding a dummy set of data to the begining and end of the
data series otherwise you will loses 2 columns."

I did this, including adding the dummy set at the beginning and end.
However, now the first bar in the column chart is pressed right up against
the y-axis and its width is only half of that of the other bars. How can I
get it to space correctly?

Using Excel 2003.

tia for any suggestions

 

[Jon Peltier]

You apparently didn't add the dummy values at the start and end of the data
range. This means if the range was C3:C10, you have to make sure C2 and C11
are blank, then adjust the range to C2:C11. This way, a blank column, not
your actual data, is cut in half at the left and right extremes of the
chart.

- Jon

 

[klam]

I figured it out. Sorry for the post - I had tried all of the scale options
for both axes before I posted.

In case anyone else has this problem, here's what worked for me...Altho the
data range was correct, which I verified, when I looked at the series, Excel
automatically excluded the blanks cells in the category labels and values.
When I manually added them back in, the bars all shifted over.

cheers,