PDA

View Full Version : Excel, Stacked Column chart. Columns not wide enough



oggy
13-08-2004, 10:41 AM
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?

oggy
13-08-2004, 11:03 AM
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

robo
13-08-2004, 07:11 PM
Isn't it great when someone from PressF1 helps you.
robo.