Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2001
    Location
    Astcote, Northamptonshire, England
    Posts
    11
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Column or bar chart percentage labels (97)

    I would really like to show both value and percentage labels on a column chart (similar to the option offered for a pie chart). The percentages would be of the total of all the values displayed. I don't need any y-axis labels, just columns with a couple of figures on or above them. I feel that I must be missing something terribly obvious but I've searched high and low without success. The data comes from tables which have not been laid out very helpfully so even the basic chart requires a degree of careful selection! There are % figures on the sheet but even if I select them as another series I can't get the simple display I want. The comparative column chart doesn't work as the values are 0-1000 or so and the percentage bar hardly gets off the ground on that sort of scale. For a College Inspection the Principal asked her secretary to produce about 200 of these charts (displaying answers to student surveys). The secretary thought it would be simple - then called me. I thought it would be - then I called here! The Principal may well have to put up with pies but I'd still like to get a solution for my own interest. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Column or bar chart percentage labels (97)

    Yes it can be done via a little creative cheating

    I created a new column that held percentages and then created one that concatenated names and percentages to be used as the label
    example attached. Hope that helps
    Attached Files Attached Files

  3. #3
    New Lounger
    Join Date
    Jul 2001
    Location
    Astcote, Northamptonshire, England
    Posts
    11
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Column or bar chart percentage labels (97)

    Thank you very much for your suggestion. It's pretty neat and straightforward to apply too. I've already started to think of a few other applications I might adapt it for. Very, very grateful.

    Andrew Hill on the other side of the world.

Posting Permissions

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