Results 1 to 12 of 12
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Stacked Column Chart With Labels (2000)

    I have a stacked column chart with 10 categories. I would like to insert numerical values in each of the sections, but some are too small (even when I reduce the font to 8). How do I "attach a numerical value along-side the column with an arrow pointing to the subject section?
    Thanks.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Stacked Column Chart With Labels (2000)

    I am not completely clear onw what you have and want. Could you elaborate, perhaps post an example?

    Steve

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Stacked Column Chart With Labels (2000)

    Steve,
    Here is my chart ("Combined" Worksheet). As you can see, the 3rd and 4th sections (Depreciation and Uncollectibles) are too small for labels. Any way I could put a label outside, beside the stacked chart?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Stacked Column Chart With Labels (2000)

    Would a pie chart do? It has the ability to display to draw lines between the data labels and the pie segments. Even better, the "bar of pie" chart can display small amounts in a legible way. See attached.

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Stacked Column Chart With Labels (2000)

    Thanks, Hans, but I am required to use the stacked version. BTW, how did you insert the values outside of both the pie ans stacked chart?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Stacked Column Chart With Labels (2000)

    With a pie chart, the data labels are automatically placed outside the pie (and bar).

    I don't know how to do what you want with a stacked bar chart, except by moving things around manually.

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Stacked Column Chart With Labels (2000)

    A "simple way" could be to create the chart as you have, then use the camera tool to take a "picture" of the underlying range of cells with just the stacked chart.

    Steve

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Stacked Column Chart With Labels (2000)

    Nice idea, let's wait and see what Jeff says.

  9. #9
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Stacked Column Chart With Labels (2000)

    I was playing some more.

    If you add a dummy value and change the "breakouts", you can just have the dummy be the pie. The by changing the size, options, of the pie you can just "hide" the pie portion.

    [In this scheme I think the axes would have to be added manually...]
    Steve

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Stacked Column Chart With Labels (2000)

    Clever <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

    I had considered something similar. It doesn't improve the "legibility" of the chart, but that doesn't appear to be Jeff's concern.

  11. #11
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Stacked Column Chart With Labels (2000)

    There is not much you can do with "legibility" unless you make them the chart large enough to see the "smaller" stacks or change chart types to allow for grouping.

    Even less "problematic" stacked bars are difficult for the mind to perceive the differences since they have common "reference line"...

    Steve

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Stacked Column Chart With Labels (2000)

    Agreed!

Posting Permissions

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