If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Aligning columns in excel
I'm trying to create a graph in excel. There are three columns in excel. First one is the case label. Second and third are values for separate trials. The graph style i'm using is the column graph. Whenever I try to create this graph, there is always a little bit of space between the first column and the Y axis. How do I get rid of the space? I tried setting "Gap Width" in the Options tab of "format data series", but its butting them all up together, not really the effect I'm looking for. Vince -- vhg119 ------------------------------------------------------------------------ vhg119's Profile: http://www.excelforum.com/member.php...o&userid=16751 View this thread: http://www.excelforum.com/showthread...hreadid=319543 |
#2
|
|||
|
|||
i. You could Arrange the three columns with one column blank between each and then set gap-width=0 ii. Or, if you are content with only half of the first column, you could click on the X-axis and uncheck the Value Y-axis crosses in between categories box. Hope this helps. Regards, Lenin -- LeninVMS ------------------------------------------------------------------------ LeninVMS's Profile: http://www.excelforum.com/member.php...fo&userid=6681 View this thread: http://www.excelforum.com/showthread...hreadid=319543 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Match two Excel Columns in Access | CR | General Discussion | 1 | November 12th, 2004 11:59 AM |
Excel columns problem | Charlie Johnson | General Discussion | 4 | October 12th, 2004 04:40 PM |
Aligning misalligned columns in one table | Littlebear | General Discussion | 3 | October 1st, 2004 04:35 AM |
Inserted Excel Worksheet won't display all columns | Andy | General Discussion | 1 | September 30th, 2004 01:18 PM |
Excel: Text to Columns (parsing) help | Julie | Worksheet Functions | 2 | August 24th, 2004 06:07 PM |