Multiple values on Chart

Question

Hello all

I’ve got a request to provide a student report to show the totals and percentages of exams passed. I was wondering if I can put both values on a single chart or should I use 2 charts, bar for the totals and pie for the percentages.

It is possible to put the 2 values on a stacked bar chart for example.

Thanks in advance.
Ron

Answer 1

Hi @ron barlow ,

Stacked charts are usually used to display multiple series in one chart area. When trying to display closely related data, consider using stacked charts. It is best to show no more than four sequences in a stacked chart. If you want to compare the proportion of each series in the population, use a 100% stacked area chart, bar chart, or column chart. These charts can calculate the relative percentage of each series in the corresponding category.
You could add line charts and auxiliary axes on this basis.
For more information, please refer to: Multiple Series on a Chart (Report Builder and SSRS)
Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.