+ Reply to Thread
Results 1 to 6 of 6

Bar chart with whisker

  1. #1
    Registered User
    Join Date
    11-11-2006
    Posts
    3

    Bar chart with whisker

    Hi,
    I am trying to create a bar chart that shows the following:
    - % of population living in a given area (Column A)
    - % of population living outside a given area (Column B)
    - total population of given area in number format (Column C)
    I can figure out how to graph Columns A and B in a bar chart, but want to add Column C as a whisker. Any suggestions on how to do this?
    Thanks.

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by kvonm
    Hi,
    I am trying to create a bar chart that shows the following:
    - % of population living in a given area (Column A)
    - % of population living outside a given area (Column B)
    - total population of given area in number format (Column C)
    I can figure out how to graph Columns A and B in a bar chart, but want to add Column C as a whisker. Any suggestions on how to do this?
    Thanks.
    My area of learning has not yet reached a 'Whisker' - but to represent a data series as a different chart type, rightmouse the Data Series, and select Chart Type

    Select your required type for that series.

    hth
    ---
    Si fractum non sit, noli id reficere.

  3. #3
    Registered User
    Join Date
    11-11-2006
    Posts
    3
    Thanks for your response. I'm referring to the whisker you might see on a box plot chart, but without the box, and with a specific "end point". I'm not sure if it's possible in excel - from what I've seen, box plots themselves are challenging to make, much less an altered form of one.
    Again - thanks for the tip.

  4. #4
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by kvonm
    Thanks for your response. I'm referring to the whisker you might see on a box plot chart, but without the box, and with a specific "end point". I'm not sure if it's possible in excel - from what I've seen, box plots themselves are challenging to make, much less an altered form of one.
    Again - thanks for the tip.
    Try http://support.microsoft.com/kb/155130

    ---

  5. #5
    Registered User
    Join Date
    11-11-2006
    Posts
    3
    That may just do the trick - thank you.

  6. #6
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by kvonm
    That may just do the trick - thank you.
    Would be interesing to see the completed chart, could you take a copy, dsguise any personal data, then zip and post it here.

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1