Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I resize bars in chart
I have a chart with column bars every six months. They are way too skinny.
How do I fatten them up? I set gap width to zero, but they are still too skinny. I set scale major unit and minor unit to six months. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I resize bars in chart
Hi,
You need to change the axis from Time series to Category. xl2003: Right click chart and pick Chart Options. On Axes tab set axis to Category xl2007: Right click axis and Axis Options page set the axis to Text Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Mike Row Soft" wrote in message ... I have a chart with column bars every six months. They are way too skinny. How do I fatten them up? I set gap width to zero, but they are still too skinny. I set scale major unit and minor unit to six months. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Customise error bars on individual bars in a bar chart 2007 | Charts and Charting in Excel | |||
Pie Chart Resize | Charts and Charting in Excel | |||
resize chart | Charts and Charting in Excel | |||
3D Chart Resize | Charts and Charting in Excel | |||
How do I resize a chart in Excel after the chart has been saved... | Charts and Charting in Excel |