+ Reply to Thread
Results 1 to 2 of 2

create Column Chart

  1. #1
    Hans Knudsen
    Guest

    create Column Chart

    How do I create a column chart that (as data labels) shows the actual numbers for one of the series and percentages for two other
    series. Here is the data:

    A
    B
    C=A+B
    D
    E=C+D
    B/C %
    D/C %

    102
    64
    166
    41
    207
    38,6%
    24,7%

    104
    62
    166
    42
    208
    37,3%
    25,3%

    103
    69
    172
    43
    215
    40,1%
    25,0%

    102
    61
    163
    36
    199
    37,4%
    22,1%

    100
    56
    156
    30
    186
    35,9%
    19,2%



    The chart must show the numbers in column A, B and D where the data labels for column A data should be 102, 104 etc whereas for
    column B and D it should be percentages as shown in the two rightmost columns.

    Regards
    Hans Knudsen



  2. #2
    Hans Knudsen
    Guest

    re: create Column Chart

    My apologies for this complete mess. I will try again later.
    Hans


    "Hans Knudsen" <[email protected]> skrev i en meddelelse news:%[email protected]...
    > How do I create a column chart that (as data labels) shows the actual numbers for one of the series and percentages for two other
    > series. Here is the data:
    >
    > A
    > B
    > C=A+B
    > D
    > E=C+D
    > B/C %
    > D/C %
    >
    > 102
    > 64
    > 166
    > 41
    > 207
    > 38,6%
    > 24,7%
    >
    > 104
    > 62
    > 166
    > 42
    > 208
    > 37,3%
    > 25,3%
    >
    > 103
    > 69
    > 172
    > 43
    > 215
    > 40,1%
    > 25,0%
    >
    > 102
    > 61
    > 163
    > 36
    > 199
    > 37,4%
    > 22,1%
    >
    > 100
    > 56
    > 156
    > 30
    > 186
    > 35,9%
    > 19,2%
    >
    >
    >
    > The chart must show the numbers in column A, B and D where the data labels for column A data should be 102, 104 etc whereas for
    > column B and D it should be percentages as shown in the two rightmost columns.
    >
    > Regards
    > Hans Knudsen
    >




+ 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