Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / September 2007

Tip: Looking for answers? Try searching our database.

x axis of chart

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Khoshravan - 03 Sep 2007 13:24 GMT
I am drawing a bar chart of age of firefighters.
In the X axis I have the age interval and in the y axis I have numbe of
firefighters with age in that range.

The table is as follows:
Age    No
20    0
30    4
40    64

In this table, 20 means that those whose age are between 0 and 20 and 30
means ages between 20 and 30. Chart draws the bar exactly above these
numbers, but for better interpretation I want the bar chart to appear between
these number. I think this is a basic question and there is a solution for it.
One solution is to put the age as follows:
0-20
20-30
30-40
in x axis but this is not a good solution.

Signature

Rasoul Khoshravan Azar
Kobe University, Kobe, Japan

Bernard Liengme - 03 Sep 2007 13:43 GMT
Right click the x-axis; open the Format Axis dialog from the shortcut menu
On the Scale tab, check the box "Y axis crosses between categories"
best wishes
Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

>I am drawing a bar chart of age of firefighters.
> In the X axis I have the age interval and in the y axis I have numbe of
[quoted text clipped - 17 lines]
> 30-40
> in x axis but this is not a good solution.
Del Cotter - 03 Sep 2007 17:27 GMT
>I am drawing a bar chart of age of firefighters.

>In this table, 20 means that those whose age are between 0 and 20 and 30
>means ages between 20 and 30. Chart draws the bar exactly above these
>numbers, but for better interpretation I want the bar chart to appear between
>these number.

Look here for Mike Middleton's solution:

http://www.treeplan.com/better.htm

You don't have to use the free add-in supplied. I think the page also
contains instructions for achieving the result manually.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
   which goes to a spam folder-- please send your email to del3 instead.

Jon Peltier - 03 Sep 2007 17:29 GMT
Try Mike Middleton's Better Histograms utility:

http://www.treeplan.com/better.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

>I am drawing a bar chart of age of firefighters.
> In the X axis I have the age interval and in the y axis I have numbe of
[quoted text clipped - 17 lines]
> 30-40
> in x axis but this is not a good solution.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.