Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
stacked bar chart - problem adjusting bar width - Excel 2007
I need some help with adjusting the width of the bars on a stacked bar
chart. If I create a chart with less than a dozen observations, I can expand the width by "Format Data Series Series Options and setting the "gap width" to 0% or "no gap". Bars widen to fill the space as advertised. However when I try to apply the same method to a chart with 50 observations, A significant gap contiinues to exist. Gap is about about 7 to 10 times wider than the bar. Does anyone have suggestions? I have some VBA experience, so if a solution exists with manipulating excel objects, I'm willing to try that. Thanks to all |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 How to change width of stacked columns | Charts and Charting in Excel | |||
Stacked bar chart, Excel 2007 | Charts and Charting in Excel | |||
Stacked column-chart Excel 2007 | Excel Discussion (Misc queries) | |||
Stacked bar Chart in Excel 2007 | Charts and Charting in Excel | |||
Automatic bar width in stacked column chart too thin | Charts and Charting in Excel |