Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Microsoft Excel Help with a population pyramid graph

  • 13-06-2012 12:04pm
    #1
    kevincaomhin
    Registered Users, Registered Users 2 Posts: 72 ✭✭


    Hi, I was hoping someone would have experience of creating a population pyramid similar to below in excel.

    fig2_1.gif


    I can create the pyramid but adding the lines for a different population is wrecking my head.


    Thanks a million for your time,

    Kevin


Comments

  • #2
    davidoco
    Registered Users, Registered Users 2 Posts: 656 ✭✭✭davidoco


    in excel 2007

    side ways bar chart, shrink
    delete all unnecessary labels etc
    format the data series and overlap by 91% and width 95%
    trendline also added

    basic version attached


  • #3
    kevincaomhin
    Registered Users, Registered Users 2 Posts: 72 ✭✭kevincaomhin


    Hi David,

    Thanks for that. Unfortunately I need the line to be based on a different data series.

    Thanks for your time tho.

    Cheers,

    Kevin


  • #4
    KAGY
    Registered Users, Registered Users 2 Posts: 1,093 ✭✭✭KAGY


    kevincaomhin wrote: »
    Hi David,

    Thanks for that. Unfortunately I need the line to be based on a different data series.

    Thanks for your time tho.

    Cheers,

    Kevin
    use davidoc's method - but have the table with the other two lines separate,
    add new data series (use negative x values for the LHS of the charts)
    use secondary axis
    if necessary right click the series (e.g. if it's gone in as a bar chart) and "change data series chart type"
    don't have time to polish the attached file


Advertisement