Posted to microsoft.public.excel.charting
|
|
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!
|