How do I manually adjust the width of my columns in a bar graph?
in [Charts]
|
From: Excel User Neu1 Excel User on 27 Jun 2008 15:50 In a graph, I would like to manually drag the columns to make them thicker or thinner. I would also like to adjust the spacing between columns.
From: Wigi on 27 Jun 2008 18:04 Right click a series on the chart, choose Format data series... and then in the Options tab, play a bit with overlap and gap width. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Excel User Neu1" wrote: > In a graph, I would like to manually drag the columns to make them thicker or > thinner. I would also like to adjust the spacing between columns.
From: Jon Peltier on 28 Jun 2008 09:06 Note that you can only adjust the entire series, not each individual column and gap. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Wigi" <Wigi(a)discussions.microsoft.com> wrote in message news:AD768992-22A3-4F70-A9E0-81509D124A06(a)microsoft.com... > Right click a series on the chart, choose Format data series... and then > in the Options tab, play a bit with overlap and gap width. > > -- > Wigi > http://www.wimgielis.be = Excel/VBA, soccer and music > > > "Excel User Neu1" wrote: > >> In a graph, I would like to manually drag the columns to make them >> thicker or >> thinner. I would also like to adjust the spacing between columns.
From: ShaneDevenshire on 28 Jun 2008 12:34 Hi, 1. You can't manually drag to adjust column widths on a chart. 2. You can use the menu methods already suggested. 3. You can "Fake" the display of a column chart so that some bars appear wider than others but its a lot of work. -- Cheers, Shane Devenshire "Excel User Neu1" wrote: > In a graph, I would like to manually drag the columns to make them thicker or > thinner. I would also like to adjust the spacing between columns.
|
Pages: 1 Prev: Problems with Viewing Charts in Excel 2007 Next: Variable or Split vertical axis scales |