LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default Automatic bar width in stacked column chart too thin

Hi - I tried to post this question on 10 Jan but can't seem to find it so
suspect my posting was unsuccessful - apologies if I've missed it.

I've created a stacked column chart, but the bars are automatically coming
out as 1pt wide so I can't even see the colours - previously column widths in
a standard bar chart have been fine. The best I can do is to alter the gap
width in 'format data series- options' but this only makes it marginally
wider.

I'm guessing it has something to do with the data - this is as follows:
Column A = weeks of the year (31/12/07, 7/1/08, etc to 29/12/08)
Columns B-D = input data in time format ie 29 mins 15 secs as 00:29:15. The
three columns each record data for the time spent on a particular activity in
the week, ie running, swimming, cycling.
Column E = numeric value vetween 120-200 (ie average heart rate)

I've created the chart as follows:
Column A = dates form x axis
Columns B-D = data charted in stacked columns on primary axis
Column E = charted on secondary axis

Any pointers as to what I'm doing wrong gratefully received!

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stacked columns width too thin - how can I alter? rafcoles Charts and Charting in Excel 1 January 10th 08 10:07 AM
Individual column width to represent stacked total DemonFish Excel Discussion (Misc queries) 1 July 13th 07 11:30 AM
Column Chart - X axis too thin because of MANY categories. Mike Charts and Charting in Excel 3 June 15th 06 01:18 PM
Automatic column width adjustment Senator Excel Worksheet Functions 4 July 3rd 05 08:17 PM
To create a stacked column chart and group the stacked bars togeth Jacqueline Charts and Charting in Excel 1 February 17th 05 11:05 PM


All times are GMT +1. The time now is 03:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"