HI All,
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)
AdminDistrict StatCount
===========================================
-- Other districts -- 298994
Amber Valley 0
Bolsover 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
Paul
Create Table dbo.TestData
(
AdminDistrict nvarchar(100) Not Null,
StatCount int Not Null
)
Go
Insert Into dbo.TestData (AdminDistrict, StatCount)
Values (N'-- Other districts --', 298994),
(N'Amber Valley', 0),
(N'Chesterfield', 4),
(N'East Riding of Yorkshire',0),
(N'North East Derbyshire', 1002)
Go