A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Aligning columns in excel



 
 
Thread Tools Display Modes
  #1  
Old November 22nd, 2004, 11:31 PM
vhg119
external usenet poster
 
Posts: n/a
Default 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  
Old November 23rd, 2004, 12:49 AM
LeninVMS
external usenet poster
 
Posts: n/a
Default


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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 11:42 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.