Thread: Chart Type
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Chart Type

Setting the axis to category should thicken the columns.

If you want to email me an example workbook I will have a look see.

Cheers
Andy

Michelle wrote:
Thank you for the quick reply and they are dates but the columns are to show
the amount spent in that month and it does show the amount but the column is
stil a single line instead of a column. I changed it like you said but that
did not fix it. Can you help?
"Andy Pope" wrote:


Hi,

Sounds like you category axis labels are dates.
If so right click chart and pick Chart Options. On the Axis tab set the
axis type to Category rather than automatic or Time series.

If not post back with a little more detail.

Cheers
Andy

Michelle wrote:

The chart columns are thin like lines