I'm working on a Stack3DColumnChart but it is given me an error 'Staked Column 3D chart'. Error You must have at least one row and one numeric column and data should be either all positive or negative.
How can i make to display +- values in Charts?
Thanks
Hello,
Thank you for posting in our community!
When working with charts, each one has a specific requirements defining what Chart Data to be used. For a 3D Stacked Column chart, the minimum number and rows are 1 numeric column with all-positive or all-negative values, as per the error message. You will find some more details regarding rows and columns as well as a Data example here.
For example, the DataSource could look something similar to the following, where the DataSource contains 4 Columns and 5 Rows:
protected void Page_Load(object sender, EventArgs e) { this.UltraChart1.DataSource = GetData(); this.UltraChart1.DataBind(); }
private DataTable GetData() { DataTable mydata = new DataTable(); // Define the columns and their names mydata.Columns.Add("Series Label", typeof(string)); mydata.Columns.Add("Segment A", typeof(int)); mydata.Columns.Add("Segment B", typeof(int)); mydata.Columns.Add("Segment C", typeof(int));
// Add the rows of data mydata.Rows.Add(new Object[] { "Stack A", 8, 11, 14 }); mydata.Rows.Add(new Object[] { "Stack B", 4, 11, 16 }); mydata.Rows.Add(new Object[] { "Stack C", 3, 11, 18 }); mydata.Rows.Add(new Object[] { "Stack D", 3, 11, 12 }); mydata.Rows.Add(new Object[] { "Stack E", 3, 11, 16 }); return mydata; }
In case you are interested, here you will find several online samples illustrating Stacked Column Chart and Stacked 3D Bar/Column Chart