Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stacked columns width too thin - how can I alter? | Charts and Charting in Excel | |||
Individual column width to represent stacked total | Excel Discussion (Misc queries) | |||
Column Chart - X axis too thin because of MANY categories. | Charts and Charting in Excel | |||
Automatic column width adjustment | Excel Worksheet Functions | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |