Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use non-numeric x axis data in excel charts? | Charts and Charting in Excel | |||
Excel 2003 - Charts - "Data Range" and Date/Time data on X-Axis | Charts and Charting in Excel | |||
how to make the axis of charts to start at my lowest value(data)? | Charts and Charting in Excel | |||
Excel Charts - Data being Plotted beyond Primary X-Axis Scale | Charts and Charting in Excel | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel |