Archive of Mr Excel Message BoardArchive of Mr Excel Message Board
Check out Bill's new book on Charts and
Graphs for Microsoft Office Excel 2007
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
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
That did the trick - still trying to figure out how I did it before! Ah well, on hardcopy no one knows the difference!
Galto