charts look different if you put in data into the x axis
 

when i make a chart using data for the y axis it looks completely different
if i leave the source data for the x axis blank. as soon as i select the
source data for the x axis the whole chart become messed up. here are two
pictures to show what i'm talking about. the one that looks weirder uses
data in the x axis. essentially the x axis is dates. (i'm using excel 2002
btw)

http://i87.photobucket.com/albums/k1...Picture3-3.png

http://i87.photobucket.com/albums/k1...Picture4-1.png

charts look different if you put in data into the x axis
 

please, does anyone have any insight into this?

"kyle" wrote:

when i make a chart using data for the y axis it looks completely different
if i leave the source data for the x axis blank. as soon as i select the
source data for the x axis the whole chart become messed up. here are two
pictures to show what i'm talking about. the one that looks weirder uses
data in the x axis. essentially the x axis is dates. (i'm using excel 2002
btw)

http://i87.photobucket.com/albums/k1...Picture3-3.png

http://i87.photobucket.com/albums/k1...Picture4-1.png

charts look different if you put in data into the x axis
 

Excel 2007 only
With AverageIfs() and Step Chart
http://www.mediafire.com/file/jmnonittewx/02_21_10.xlsx

charts look different if you put in data into the x axis
 

Excel 2007
No more helper columns.
Automated with macro.
http://c0718892.cdn.cloudfiles.racks.../02_21_10.xlsm
Pdf preview:
http://c0718892.cdn.cloudfiles.racks...m/02_21_10.pdf