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

Excel Problem

Options
  • 11-08-2010 8:14pm
    #1
    Misticles
    Registered Users Posts: 13,746 ✭✭✭✭


    I am trying to make graphs to represent data.

    Data (text) ranges from 5 up to almost 5000 entries.

    I just cannot get Excel to do what I want.

    I want to express x as a % of y in graphical form.

    I have attached an example.

    I want to express column b as a % of column c.

    Or even represent it... column b goes to say 500 on a bar chart whereas column c goes up to 5000.

    Thanks :)


Comments

  • Options
    #2
    Seth Brundle
    Moderators, Politics Moderators Posts: 39,853 Mod ✭✭✭✭Seth Brundle


    Soln. #1: add a new column which calculates the percentage and chart on that.
    Soln. #2: use a calculated field within a pivot chart.


Advertisement