MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


Posted by Ian Mac on February 04, 2002 2:45 PM

Just had a quick play with this, the only way I could get to work was add a column with the formula

=TEXT(A1,"mm/dd/yyyy")

in it and create the chart from that.

Any help?

Ian Mac

Posted by Galto on February 08, 2002 5:01 AM

Thanks Ian.

That did the trick - still trying to figure out how I did it before! Ah well, on hardcopy no one knows the difference!

Galto