| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
bar char - bar width
I've created a simple, standard bar chart in Excel. Oddly, Excel by default
has made the widths of the bars themselves extremely narrow. I have never seen this behavior before. Any ideas what may be causing this and suggestions on how I can fix it? Thanks. -- Jeff |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
bar char - bar width
Jeff -
To fix, in Excel 2003 and earlier versions: Format Data Series | Options | Gap Width. - Mike http://www.mikemiddleton.com "Jeff Reese" wrote in message ... I've created a simple, standard bar chart in Excel. Oddly, Excel by default has made the widths of the bars themselves extremely narrow. I have never seen this behavior before. Any ideas what may be causing this and suggestions on how I can fix it? Thanks. -- Jeff |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
bar char - bar width
Is this weekly data, for instance? Excel might interpret dates and provide
seven slots for one weekly value, leaving you with six empty slots per filled point. Change from a time scale axis to a regular category axis: go to the Chart menu, Chart Options, Axes tab, and under Category (X) Axis, change Automatic to Category. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Jeff Reese" wrote in message ... I've created a simple, standard bar chart in Excel. Oddly, Excel by default has made the widths of the bars themselves extremely narrow. I have never seen this behavior before. Any ideas what may be causing this and suggestions on how I can fix it? Thanks. -- Jeff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find data character width in Excel | Excel Discussion (Misc queries) | |||
| How do I convert char into integer in Excel VBA? | Excel Discussion (Misc queries) | |||
| Data Validation - width of drop down box | Excel Discussion (Misc queries) | |||
| Adjust an Excel table with the width of a Word page | Excel Discussion (Misc queries) | |||
| Changed column width keeps reverting back to original size | Excel Discussion (Misc queries) | |||
Linear Mode
