Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi!
I've created a bar chart with stacked columns, but the bars have come through no wider than a 1pt line - I've managed to increase them to the width of a 2pt line by reducing the 'gap' to zero in 'Format data series- options', but this is still not wide enough to see the bar colour and not consistent with the legend. How can I get the bars to be a standard width so I can see the data? I've also tried transposing the data to see if this made a difference, but no luck. The data is as follows: Column 1 = date (1/1/08; 8/1/08, etc) Column 2-4 = time values for different training type times, eg run, cycle, swim (format = 00:29:34) Columns 5 = number value between 120 - 200 (for average heart rate) Column 1 = chart x axis. Total of columns 2-4 = primary y axis plotted as stacked column Column 5 = secondary y axis plotted as line. Any suggestions?! Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Individual column width to represent stacked total | Excel Discussion (Misc queries) | |||
How to alter width of columns in Column Charts? | Charts and Charting in Excel | |||
variable height variable width stacked bar charts | Charts and Charting in Excel | |||
Columns showing up as thin vertical lines | Excel Discussion (Misc queries) | |||
Create stacked columns chart but with 2 columns for each x axis? | Charts and Charting in Excel |