Column chart bar width

fbellini · Feb 18th, 2002, 11:49 AM

I have a file with a column chart with columns that are far too narrow. It consists og dates on the x-axis and numeric data on the Y axis.

The dates span 4 years and exist for only May & October.

Attempting to widen the bars using "Format data series" "options" is thwarted as the gap-width is initialized to "0".

The x-axis (dates) scale base unit is Months and scale Major&Minor unit are both 6 months.

Do you know of any trick to widen these columns?

Corni · Mar 18th, 2002, 09:27 PM

Why not using the data series for only the two months per year, time 4 years, that comes to 8 values. This way you can control without problem the width of the column. Why keep 10 x 4 = 40 X-axis points without values.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 18th, 2002, 11:49 AM	#1
fbellini New Member Join Date: Feb 2002 Posts: 1	I have a file with a column chart with columns that are far too narrow. It consists og dates on the x-axis and numeric data on the Y axis. The dates span 4 years and exist for only May & October. Attempting to widen the bars using "Format data series" "options" is thwarted as the gap-width is initialized to "0". The x-axis (dates) scale base unit is Months and scale Major&Minor unit are both 6 months. Do you know of any trick to widen these columns?

Mar 18th, 2002, 09:27 PM	#2
Corni Board Regular Join Date: Mar 2002 Location: Brampton Posts: 324	Why not using the data series for only the two months per year, time 4 years, that comes to 8 values. This way you can control without problem the width of the column. Why keep 10 x 4 = 40 X-axis points without values.