Chart - Columns Too Narrow!
Posted by Galto on February 04, 2002 11:31 AM
Hello,
I have two columns of data about 20 rows long. Column A containins dates - End of week dates, actually in mm/dd/yyyy format...
02/02/2002
02/09/2002
02/16/2002
.
.
Column B contains data values that correspond to those dates.
24
36
52
.
.
When I try to chart the data on a simple column graph, something odd happens. The columns on the chart are very skinny and no amount of formatting can widen them (overlap and gap width).
I suspect that Excel is recognizing that all the dates are 7 days apart and it's trying to "help" by accounting for this pattern. The chart appears to push all the data values to one site of the tick mark on the x-axis. If I substitute "Week 1 Week 2" etc for the dates, the columns are nice and healthy and wide.
Surely this can be fixed... Surely I've done this before! Any suggestions?
Thanks!
Galto