Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
bar chart
How do I shorten the length of the distance between bars in a chart without
comprimising the width of the bars? If I squeeze the entire chart box, the bars become smaller, which I don't want to do. Please help! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
bar chart
Select the series, press Ctrl+1 (numeral one) to format it. In 2003 and
earlier, click on the Options tab, in 2007 look on the first tab. Change gap width (the space between bars) from default 150 (in % of width of one bar) to a smaller number. 50 looks good in many cases. If you have a date scale axis, and one data point per week, this won't help much, because you have one point and six gaps per week. You can change to a category type axis, so one date has one bar, and dates without data don't appear. - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - Training in Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "SSF" wrote in message ... How do I shorten the length of the distance between bars in a chart without comprimising the width of the bars? If I squeeze the entire chart box, the bars become smaller, which I don't want to do. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Setting up and Configuration of Excel | |||
Creating a chart(? pie chart) that shows customers,dates and machi | Charts and Charting in Excel | |||
chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel |