Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    122
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Width of bar in a stacked bar chart (Excel 2000/XP)

    I am trying to create a series of stacked bar charts (2 series) with about 15 bars. The resulting chart has very skinny bars with a lot of space between bars. I have maxed the overlap at 100 and changed the gap width to 0. I get the same results with 2D and 3D charts. Is there some way to make the bars wider?

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

    Re: Width of bar in a stacked bar chart (Excel 2000/XP)

    Could you post a small sample workbook?

  3. #3
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    122
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Re: Width of bar in a stacked bar chart (Excel 2000/XP)

    Sample chart for one program

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

    Re: Width of bar in a stacked bar chart (Excel 2000/XP)

    The X axis has automatically been made into a timescale axis by Excel. Each bar represents 1 day, and since the dates are 7 days (1 week) apart, the bars take up only 1/7th of the available width. To change this:
    - Select Chart | Chart Options...
    - Activate the Axes tab.
    - Set the Category Axis to Category.
    - Click OK.
    See attached version.

  5. #5
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    122
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Re: Width of bar in a stacked bar chart (Excel 2000/XP)

    Thank you, thats exactly what I needed to make this work

Posting Permissions

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