Hi,
I have a chart that that makes a comparison. Let's say I have in the x-axis information from Q1 through Q4 for two companies. Therefore, I should have two bars for Q1, two bars for Q2 and so on. This works fine when I do have data for all four quarters.
This set up does not work when one of the companies does not have data for one of the quarters. Let's say Q3 does not have data for one of the companies. In this scenerio, the value of Q4 slides down to fill in the value in Q3, and Q4 is left without data for that company.
The following is how the chart is set up:
chartDefinition.DataGroupColumn = "Name";
chartDefinition.PlotArea.XAxis.DataLabelsColumn = "TimePeriod";
chartDefinition.Legend.Appearance.GroupNameFormat = "#VALUE:#NAME";
How can I fix this issue?
Thanks,
E.
I have a chart that that makes a comparison. Let's say I have in the x-axis information from Q1 through Q4 for two companies. Therefore, I should have two bars for Q1, two bars for Q2 and so on. This works fine when I do have data for all four quarters.
This set up does not work when one of the companies does not have data for one of the quarters. Let's say Q3 does not have data for one of the companies. In this scenerio, the value of Q4 slides down to fill in the value in Q3, and Q4 is left without data for that company.
The following is how the chart is set up:
chartDefinition.DataGroupColumn = "Name";
chartDefinition.PlotArea.XAxis.DataLabelsColumn = "TimePeriod";
chartDefinition.Legend.Appearance.GroupNameFormat = "#VALUE:#NAME";
How can I fix this issue?
Thanks,
E.