What am l doing wrong (using the standalone designer or visual studio), as for whatever reason l cannot get the stacked bar chart to display all the data / data point labels, if l use a column chart instead then it works? See screenshots attached.
Sample data (sql below for anyone wishing to reproduce)
-- Other districts -- 298994
Amber Valley 0
Chesterfield 4 ---- this value goes missing along with all the zero's
East Riding of Yorkshire 0
North East Derbyshire 1002
I have checked all settings, which are fine, if l change the scale from numeric (which) l want to logarithmic then it works, its almost as if, the range of numbers from the smallest to the largest is too great as if l reduce the max number i.e in the example above change -- other districts -- to say 700 then it works, however the data point labels still do not show the zeros like they do in the column chart.
Anyone know whats wrong?
Thanks in advance
Create Table dbo.TestData
AdminDistrict nvarchar(100) Not Null,
StatCount int Not Null
Insert Into dbo.TestData (AdminDistrict, StatCount)
Values (N'-- Other districts --', 298994),
(N'Amber Valley', 0),
(N'East Riding of Yorkshire',0),
(N'North East Derbyshire', 1002)