Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
x axis of chart
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. -- Rasoul Khoshravan Azar Kobe University, Kobe, Japan |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
x axis of chart
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 -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Khoshravan" wrote in message ... 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. -- Rasoul Khoshravan Azar Kobe University, Kobe, Japan |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
x axis of chart
On Mon, 3 Sep 2007, in microsoft.public.excel.charting,
Khoshravan said: 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. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
x axis of chart
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 _______ "Khoshravan" wrote in message ... 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. -- Rasoul Khoshravan Azar Kobe University, Kobe, Japan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel |