Excuse this post if the questions has already been covered. I am trying to create a composite chart showing actual and plan numbers by day, as columns on a chart. The chart also has a line showing a weighted average value. Data comes from a SQL stored procedure. The resulting chart looks like this:
This is not exactly the result that I want. I am trying to get the columns for each day to be next to each other. For example, the columns for Saturday would be side-by-side, not in two separate sets of columns. It should look something like this:
Below is the code that I am using. Thanks in advance for your assistance.
DataTable tbldata = new DataTable();
Try adding this to the column layer:columnLayer.SwapRowsAndColumns = true;
This should give you 5 groups of 2 columns instead of 2 groups of 5.
That worked! Thanks!!!!!