Results 1 to 11 of 11
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Keeping Stacked Bars Together (2000)

    Is there a way, in the attached chart, to get the stacked bars relevant to the same power plant to be close to each other without any gap in between?

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

    Re: Keeping Stacked Bars Together (2000)

    1) Select a series.
    Select Format | Selected Data Series...
    Activate the Options tab.
    Set Gap width to 0.
    Click OK.

    2) Insert blank rows between the data of the different power plants.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Keeping Stacked Bars Together (2000)

    Perfect as usual, thank you Hans <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Keeping Stacked Bars Together (2000)

    How come, if I insert an additional line in the data table so as to give more separation in the chart between the topmost three categories and the rest, all the remaining categories labels disappear? And is there a way to bold the topmost three categories labels while leaving the rest with normal formatting?

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

    Re: Keeping Stacked Bars Together (2000)

    The 'Number of categories between tick-mark labels' property of the category axis is set to a number > 1. This only works correctly if the distance between the labels is constant, i.e. no extra blank rows. If you set it to 1, all labels will be displayed, but of course with duplication.
    As an alternative, you could delete the duplicate labels in the source data. You can then keep the extra blank row.

    And no, it is not possible to format individual axis labels.

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Keeping Stacked Bars Together (2000)

    Thank you Hans, I've resorted to deleting the categories axis and adding the labels manually.

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

    Re: Keeping Stacked Bars Together (2000)

    Isn't that more work than deleting duplicate labels? See attachment - took about 1 minute.

  8. #8
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Keeping Stacked Bars Together (2000)

    Well I had no choice because I needed to format the top three categories differently.

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

    Re: Keeping Stacked Bars Together (2000)

    OK.

  10. #10
    Star Lounger
    Join Date
    Sep 2002
    Location
    Honolulu, Hawaii, USA
    Posts
    63
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Keeping Stacked Bars Together (2000)

    Sir,
    Here are a couple of options for highlighting the top three; maybe one will serve.
    Foglio1: Though you cannot format the labels individually, you can format the series points individually.
    Foglio2: A border around the group you wish to highlight. In my example, I used a shaded rectangle with 70% transparency.

    Aloha,
    JohnJ

  11. #11
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Keeping Stacked Bars Together (2000)

    Thank you very much John. Nice to meet you <img src=/S/smile.gif border=0 alt=smile width=15 height=15>.

Posting Permissions

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