Results 1 to 4 of 4

very simple % chart

Threaded View

  1. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,938

    Re: very simple % chart

    There are a number of issues with your description. Chart data ranges must be contiguous; you have rows in between the data you want to plot. A pie chart isn't the right type of chart for this. A pie chart shows pieces of a whole, but you want to plot one whole and a part. You can't really mix percentages and counts on a pie chart. (Some folks around here will tell you that pie charts are overused and are seldom appropriate.)

    Please see the attached, which I think resolves your issues. It's a bar chart. The percentage is actually plotted as a separate series which has been formatted to make the bar invisible, but the data label is still visible. It can be moved around if you want it to appear in a different position.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

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