ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Mysterious gaps (https://www.excelbanter.com/charts-charting-excel/446991-mysterious-gaps.html)

[email protected]

Mysterious gaps
 
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 regularly ac4ross the chart).

Any ideas much appreciated, regards, mark


All times are GMT +1. The time now is 10:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com