Mysterious gaps

E

expatgold

I am charting a date series on the left column and either 1 or -1 in the right. The right column has either 1 or -1 nothing else. My column chart is set to maximum 1 minimimum -1 so there should be either a coloured bar at the top for 1 values or a black bar down for -1 values (inverted if negative)..

Strangely there are gaps in the top row with no corresponding black down bar and where the gaps are the value is 1 so there should be no gap.

I simply cannot figure out why there are these gaps (spread quite regularlyac4ross the chart).

Any ideas much appreciated, regards, mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List all tables, including document structure 0
Paragraph numbering in Word 1
One extra x axis item that wont go away - can anyone help? 3
Cumulative formula for word table 0
Displaying zero values as gap in a chart 1
Convert Error Bars to Series and Colour 1
Excel 2007: Line where a gap should be, but only when plotting on ahorizontal date axis 2
Date gaps in chart after pivotTable 0

Top