Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Widen Chart Columns
I'm using a stacked column format. I want to show data for about 3 weeks (1
week in each column). Everything looks fine, except the column seems very narrow. How do I change the width of the column on the chart? Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Widen Chart Columns
Hi,
Double click column and adjust the GapWidth property on the series option tab. Also check the categroy axis is not being plotted as true dates as this will leave big gaps between non consectutive dates. Right click chart and choose Chart Options. On Axis tab set x axis to Category. Cheers Andy RichN wrote: I'm using a stacked column format. I want to show data for about 3 weeks (1 week in each column). Everything looks fine, except the column seems very narrow. How do I change the width of the column on the chart? Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Widen Chart Columns
In Excel 2007, you need to change the information in the column to text
instead of a date. This will widen the bars on the graph. I could not find a place to make it a "category" in 2007 (which is what I did with the previous version). "Andy Pope" wrote: Hi, Double click column and adjust the GapWidth property on the series option tab. Also check the categroy axis is not being plotted as true dates as this will leave big gaps between non consectutive dates. Right click chart and choose Chart Options. On Axis tab set x axis to Category. Cheers Andy RichN wrote: I'm using a stacked column format. I want to show data for about 3 weeks (1 week in each column). Everything looks fine, except the column seems very narrow. How do I change the width of the column on the chart? Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Widen Chart Columns
In xl2007 you need to select the axis.
CTRL+1 to display the format dialog. Axis Options Category as Text. Cheers Andy MMartinPhD wrote: In Excel 2007, you need to change the information in the column to text instead of a date. This will widen the bars on the graph. I could not find a place to make it a "category" in 2007 (which is what I did with the previous version). "Andy Pope" wrote: Hi, Double click column and adjust the GapWidth property on the series option tab. Also check the categroy axis is not being plotted as true dates as this will leave big gaps between non consectutive dates. Right click chart and choose Chart Options. On Axis tab set x axis to Category. Cheers Andy RichN wrote: I'm using a stacked column format. I want to show data for about 3 weeks (1 week in each column). Everything looks fine, except the column seems very narrow. How do I change the width of the column on the chart? Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stack & Cluster columns in same chart | Charts and Charting in Excel | |||
How do I create a link between columns from a data chart? | Excel Discussion (Misc queries) | |||
Chart Property Confusion | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
I want to draw a line through the columns of a chart, plot the o. | Charts and Charting in Excel |