View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default Excel 2007 is charting skinny lines instead of columns

Try this:-

- click in one of your columns so that all of them are highlighted

- right hand click then Format Data Series (window of same name should
launch)

- Series Options should be highlighted in orange on left hand side

- change Gap Width (on right hand side) to a lower percentage

- Close

Hopefully your columns will now no longer look as though they have been on a
diet!

If my comments have helped please hit Yes.

Thanks.



"Carla" wrote:

Hi,
I have a chart that I have created that show the columns as a skinny line
instead of a column. The chart is to show all the data for the past 12
months, so the x axis will always only show 12 months worth of data.

Anyone have any ideas why 2007 is doing this?