Results 1 to 3 of 3
  1. #1
    oggy
    Guest

    Default Excel, Stacked Column chart. Columns not wide enough

    Hi
    I'm trying to do a stacked column chart to show componants that make up a total. I want the chart to be easily interpreted so need the columns on the chart to be wide enough to understand at a glance. When I select just the data from my source I have no problem and get nice fat stacks on my chart but with no dates. When however I expand the selection to pull in the dates so they go along the X axis, the resulting stacks move from a fat stack in the middle of the chart column to a narrow stack left aligned at the tick mark of the relevant date. Reducing the data shown on the chart down to just a few series leaves plenty of room between the dates but still only a narrow stack. Any ideas on how I can fatten my stacks?

  2. #2
    oggy
    Guest

    Default Re: Excel, Stacked Column chart. Columns not wide enough

    I solved it. Because I was using dates that were 14 days apart, Excel only let me use 1/14th of the width of the column. I reformated the date series from dates to labels and now I have nice fat stacks

  3. #3
    robo
    Guest

    Default Re: Excel, Stacked Column chart. Columns not wide enough

    Isn't it great when someone from PressF1 helps you.
    robo.

Similar Threads

  1. excel bar chart
    By bpt2 in forum PressF1
    Replies: 2
    Last Post: 04-09-2007, 12:42 PM
  2. Excel chart
    By bpt2 in forum PressF1
    Replies: 1
    Last Post: 07-07-2007, 08:41 PM
  3. Excel Columns
    By lee987 in forum PressF1
    Replies: 1
    Last Post: 16-06-2006, 05:43 AM
  4. Excel chart
    By bpt2 in forum PressF1
    Replies: 1
    Last Post: 19-05-2006, 03:57 PM
  5. Excel Chart
    By Ron Bakker in forum PressF1
    Replies: 4
    Last Post: 21-07-2003, 06:57 AM

Posting Permissions

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