Only Half of First Bar is Showing

  • Thread starter Thread starter klam
  • Start date Start date
K

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
 
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
 
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,
 
Back
Top