I recreated the chart with the data set up simply as numbers and it works
fine. In my original chart, the data was the result of an equation. Would
this have something to do with the issue?

"Carla" wrote:

I am using the column chart type. I am charting only one data series (1
opacity reading per month). this might seem like a stupid question but does
a column chart require two sets of data?

"Carla" wrote:


further to this, if I only chart half of my data (6 months worth) it works
fine.

"trip_to_tokyo" wrote:

Sorry, Carla, but nothing else springs to mind at the moment: if it does I'll
post back.

"Carla" wrote:

Hi, my lines still stay emanciapated even if I put the gap to Zero! I am
absolutely stumped. I have created other graphs exactly the same way and
they work fine. Any other suggestions?-

"trip_to_tokyo" wrote:

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?