| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
stacked bar chart
Hi
I'm trying to chart people totals by age band against sex (male or female). I have a stacked bar chart that aligns to the left but i would like to shift the y-axis centrally and then chart right if male or left if female (doesn't really matter which way). I've tried shifting the axis but figures to the left go into negative. data eg. SEX 0 to 4 5 to 14 15 to 44 45 to 54 MALE 119 411 1326 549 FEMALE 120 423 1297 547 The goal is a tree shaped graph, narrow at base getting larger in the middle before shrinking near the top. Can it be done? Many thanks rich |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
stacked bar chart
Have a look at Jon's example:
http://peltiertech.com/Excel/Charts/tornadochart.html best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "RichHoughton" wrote in message ... Hi I'm trying to chart people totals by age band against sex (male or female). I have a stacked bar chart that aligns to the left but i would like to shift the y-axis centrally and then chart right if male or left if female (doesn't really matter which way). I've tried shifting the axis but figures to the left go into negative. data eg. SEX 0 to 4 5 to 14 15 to 44 45 to 54 MALE 119 411 1326 549 FEMALE 120 423 1297 547 The goal is a tree shaped graph, narrow at base getting larger in the middle before shrinking near the top. Can it be done? Many thanks rich |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
stacked bar chart
Thank you very much
"Bernard Liengme" wrote: Have a look at Jon's example: http://peltiertech.com/Excel/Charts/tornadochart.html best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "RichHoughton" wrote in message ... Hi I'm trying to chart people totals by age band against sex (male or female). I have a stacked bar chart that aligns to the left but i would like to shift the y-axis centrally and then chart right if male or left if female (doesn't really matter which way). I've tried shifting the axis but figures to the left go into negative. data eg. SEX 0 to 4 5 to 14 15 to 44 45 to 54 MALE 119 411 1326 549 FEMALE 120 423 1297 547 The goal is a tree shaped graph, narrow at base getting larger in the middle before shrinking near the top. Can it be done? Many thanks rich |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stacked Bar Chart - used for a Tornado Chart | Charts and Charting in Excel | |||
| How can I combine a stacked bar chart with stacked colum chart? | Charts and Charting in Excel | |||
| Stacked Chart help needed | Charts and Charting in Excel | |||
| Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
| How to make a stacked bar chart using time? | Charts and Charting in Excel | |||
Linear Mode
