Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Changing the Width of Bars in a Horizontal bar Graph
Hi, I cannot seem to figure out who to change the width of each bar in a
horizontal bar graph. Can someone please advise me as to how I could do this. Thanks in advance :) |
#2
|
|||
|
|||
Double click the plotted series and in the resulting dialog box select
the Options tab. In there adjust the 'Gap Width' value. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , Ott1 @discussions.microsoft.com says... Hi, I cannot seem to figure out who to change the width of each bar in a horizontal bar graph. Can someone please advise me as to how I could do this. Thanks in advance :) |
#3
|
|||
|
|||
BTW, this changes all bars, since they cannot be changed individually.
Not without tricks, anyway. These are tricks for making variable-width column charts, and the tricks mostly work for bar charts as well: http://peltiertech.com/Excel/Charts/VarWidthColumn.html http://peltiertech.com/Excel/ChartsH...thColumns.html http://pubs.logicalexpressions.com/P...cle.asp?ID=533 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Tushar Mehta wrote: Double click the plotted series and in the resulting dialog box select the Options tab. In there adjust the 'Gap Width' value. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changed column width keeps reverting back to original size | Excel Discussion (Misc queries) | |||
changing the width of the font drop-down menu box? | Excel Discussion (Misc queries) | |||
2 Question: Coloumn width, Filename | Excel Worksheet Functions | |||
horizontal & vertical scroll bars | Excel Worksheet Functions | |||
Scroll bars (vertical and horizontal). | Excel Discussion (Misc queries) |