Problem setting bar chart width with conditional formula
Can someone please help me with how to conditionally set the width of a bar chart that is sourced from a cross-tab?
I have a bar chart that has a cross-tab data source with months as the group (X) axis. The cross-tab width changes as the number of months increases or decreases, but the chart width does not change. I need the chart width to change along with the cross-tab width. I have tried setting the chart width in a conditional formula (units of measure are inches) in the size and positioin dialogue, but the changes do not affect the chart width. I have tried using constant values in the formula and they do not change the chart width either. I can only get the chart width to change if I modify the width value (not using a formula), but that will not conditionally change the width.