Column Chart - Two series

Question

Hi,

I'm wonder how to create two series in column chart.

In my case, I'm retrieving data from SQL Server using dataset that belongs to different TestExecution (Each Test Execution behaves as a series)

When creating a chart which displays only a data for one series, it lokks ok:

But when I need to displays two series where each series displays data of diffrent test, the columns then displays the data of both series.

I tried to change the Chart Type, and I found that the most closest chart is:

But the above chart seperates the category groups. The required situation is to make the category groups displayed in one column and the series are displayed beyond each other.

Please, I need your help

Regards,

Bader

Answer 1

Hi,

I have a data which belongs to two diffrent products and I need to display them in one chart.

By adding the data of one product the chart looks as below:

I need to add the data of the second product. How can I do that?

I tried to add the product ID to the series group, but then the graph lokks like:

Is there any othre way to do that and displays the data in a best way?

Please, I need your help,

Regards,

Bader

Answer 2

Hi Bader,

For a Stack Column Chart, if there is a series goup and there are multiple fields in the Values area, the instances of the series group and the value fields will generate all possible permutations and display them in each series bar, just as the second screenshot in your post shows.

Based on your scenario, there are two workarounds for your reference:

• Place the "TestExecutionID" field in the Category Groups area below the "EventType" instead.
• Keep the "TestExecutionID" field in the Series Groups area, but display only one series (Passed, Failed, Errors) at one time. To do this, we can create a parameter that has the "Passed", "Failed", and "Errors" three values. Then, we can set the visibility of the three series values based on the parameter.

If you have any questions, please feel free to ask.

Regards,
Mike Yin

TechNet Subscriber Support
If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

---

Mike Yin

TechNet Community Support