Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to draw out a bar chart backed by a 3-dimension database
Hello everyone:
I've a problem: I'm drawing a population pyramid bolstered by a 3-dimensional database, with the population as the only figure to display, and break up by gender, age group, and record year; e.g. Year Gender Agegroup Population 2000 Male 10-14 200000 1999 Female 5-9 1340000 I've got a total 2 years in year break up, 2 gender types, male & female, and about 10 age groups; What I wanna to do is to generate a bar chart, with age break displayed on the vertical axis, population displayed on the horizontal axis, and break up by gender, shown on alternative quadrants of horizontal axis devided by vertical null point (treat female figure as negative), and stack the year data on the vertical axis, show an example: ++++++|++++++++ Year 2000,Age group 15-19 *****|****** Year 2005,Age group 15-19 +++++++++|++++++++++ Year 2000,Age group 10-14 *******|******* Year 2005,Age group 10-14 ++++++|+++++++ Year 2000,Age group 5-9 *******|********* Year 2005,Age group 5-9 Female _____________|_______________Male Where * and + represents different years' break, left and right quadrants represent gender break, and vertical axis represent age break, the length of + and * represent the population figure; I've been doing this graph using a statistical software and I would like to move it into excel file to link the datapoints to other files, enabling this chart manipulatable by altering the figures to obtain dynamic effects, how can this be achieved? Thanks & appreciates! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to draw a line on a chart, and have it move with the chart? | Charts and Charting in Excel | |||
How do I draw chart like car counter? | Charts and Charting in Excel | |||
Does anyone have a 12-dimension spider chart template in Visio? | Charts and Charting in Excel | |||
Can you draw more than one pie in a chart? | Charts and Charting in Excel | |||
how do i draw a chart with excel | Excel Discussion (Misc queries) |