View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default How do I change the width of data columns in a column chart?

Hi,

Sounds like your x axis is being treated as Dates rather than categories.
Right click chart and pick chart options. On the Axes tab check Xaxis
Category type.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Diana" wrote in message
...
I created a column chart with 7 data series, and the data columns are very
thin, so you can't tell one series from another. I tried using overlap
and
gap to increase the width of the columns, but that is not working. Any
help
would be greatly appreciated.