+ Reply to Thread
Results 1 to 8 of 8

How to set the distance between chart series in stacked column chart

  1. #1
    Registered User
    Join Date
    01-23-2013
    Location
    Slovenská republika
    MS-Off Ver
    Excel 2010
    Posts
    27

    Question How to set the distance between chart series in stacked column chart

    Hello.

    My problem is following:

    I've created a stacked colum chart, like
    stacked-chart-original.png

    But how can I to decrease the distance between chart series like
    stacked-chart-original.png
    ?

    My excel sheet is
    chart_example.xlsx

    Thanks in advance

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,604

    Re: How to set the distance between chart series in stacked column chart

    Select one of the series.
    CTRL+1 to display Format dialog.
    On Series tab reduce the Gap Width value.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-23-2013
    Location
    Slovenská republika
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: How to set the distance between chart series in stacked column chart

    Thanks Andy for your very quick answer. Your solution I've tried before but it didn't resolve the issue. I need two charts for a each month to be closer not for all charts. The following picture it descibes in right way
    stacked-chart-expected.png
    Regards
    Jan

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,604

    Re: How to set the distance between chart series in stacked column chart

    Sorry, missed that there should be a gap between Months.

    Only way to get Actuals closer to Plan is to add empty categories around existing data. But it does not look pretty.

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,604

    Re: How to set the distance between chart series in stacked column chart

    Just to be clear, are you talking about the total series only?

  6. #6
    Registered User
    Join Date
    01-23-2013
    Location
    Slovenská republika
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: How to set the distance between chart series in stacked column chart

    Thanks Andy for the solution. I need work with all series.
    Regards
    Jan

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,604

    Re: How to set the distance between chart series in stacked column chart

    so the chart and data will look like the attached example
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    01-23-2013
    Location
    Slovenská republika
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: How to set the distance between chart series in stacked column chart

    Thanks Andy for your real example and willingness to help me. It is same as you described in #4 - this I already tried .
    Have a nice day!
    Jan

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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