How to alter width of columns in Column Charts?
 

Hi,
I am having trouble with creating a readable column chart as the columns
within it are so thin that it is impossible to see what colour they are. Is
it possible to edit column width within a chart? If so please do tell as I
dont have much more hair to pull out!

How to alter width of columns in Column Charts?
 

You can change all the columns at once. Double click a column series, and on
the Options tab, change the gap width. Zero means no gap, the bars are
touching.

If you have dates on the X axis, using Days as your units, and you have one
column per week, you will have six days per week without a column. You can't
make the columns wider than one category axis unit. You could change to a
category type axis: Chart menu Chart Options Axes tab, select Category
instead of Auto or Time Scale.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"TimJim" wrote in message
...
Hi,
I am having trouble with creating a readable column chart as the columns
within it are so thin that it is impossible to see what colour they are.
Is
it possible to edit column width within a chart? If so please do tell as I
dont have much more hair to pull out!

How to alter width of columns in Column Charts?
 

Thanks, that was exactly what I needed :)

"Jon Peltier" wrote:

You can change all the columns at once. Double click a column series, and on
the Options tab, change the gap width. Zero means no gap, the bars are
touching.

If you have dates on the X axis, using Days as your units, and you have one
column per week, you will have six days per week without a column. You can't
make the columns wider than one category axis unit. You could change to a
category type axis: Chart menu Chart Options Axes tab, select Category
instead of Auto or Time Scale.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"TimJim" wrote in message
...
Hi,
I am having trouble with creating a readable column chart as the columns
within it are so thin that it is impossible to see what colour they are.
Is
it possible to edit column width within a chart? If so please do tell as I
dont have much more hair to pull out!