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?
|