Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change category width...
Hi all,
Is it possible, on the X axis of the column chart, to make the category width thinner? I want to be able to put the columns next to each other without a gap, but I don't want to make the columns wider than they are (ie I don't want to use gap width). Many thanks Andy |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change category width...
On Thu, 1 Mar 2007, in microsoft.public.excel.charting,
ajayb said: Is it possible, on the X axis of the column chart, to make the category width thinner? I want to be able to put the columns next to each other without a gap, but I don't want to make the columns wider than they are (ie I don't want to use gap width). First set the gap width to zero, then restore the columns to a width that suits you by selecting the chart and dragging the frame so that the chart is less wide. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change category width...
ther is an overlap that goes from -100 to +100 that may do what you want. When you double clik on a bar a menu comes up. click options. both the Overlap and gap widtth are on this menu. try different values of both options. "ajayb" wrote: Hi all, Is it possible, on the X axis of the column chart, to make the category width thinner? I want to be able to put the columns next to each other without a gap, but I don't want to make the columns wider than they are (ie I don't want to use gap width). Many thanks Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why can't i change column width? | Excel Discussion (Misc queries) | |||
If I do not plot empty cells, how do I change the category axis? | Charts and Charting in Excel | |||
change column width | Setting up and Configuration of Excel | |||
Excel: Can I change Chart-title/category/value from a sheet-cell? | Charts and Charting in Excel | |||
How do I change the category axis number formatting in a Pivot Ch. | Charts and Charting in Excel |