Column Chart Thickness of Bars
I need to graph the amount of concrete poured against the planned amount for
each week over about 60 weeks. When I create a Column Chart in Excel 2007 the bars in the chart are thin lines, I have tried to format the Data Series and remove the gap width but this does not seem to have much effect. I've also tried increasing the thickness of the border however this just looks stupid and makes the data overlap. Is there any way to fix this? Cheers |
Column Chart Thickness of Bars
The bars are narrow because you have one value and six blanks per week.
Right click the horizontal axis, choose Format Axis, and under Axis Options - Axis Type - choose Text Axis. Excel recognized your X values as dates and used the Date Axis option as the Automatic type. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "twinkle17" wrote in message ... I need to graph the amount of concrete poured against the planned amount for each week over about 60 weeks. When I create a Column Chart in Excel 2007 the bars in the chart are thin lines, I have tried to format the Data Series and remove the gap width but this does not seem to have much effect. I've also tried increasing the thickness of the border however this just looks stupid and makes the data overlap. Is there any way to fix this? Cheers |
All times are GMT +1. The time now is 04:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com