Hi,



I am trying and struggling to find a way to present some data in one graph

The data I have looks like this:



where Cat=category, P=period (month), and the % result for each period is the % of tests failed.

I ideally want this presented with each category taking up a separate portion of the x-axis. To look something like this:



This just shows the % of test failed though and does not include the number of tests for each period. How do I do this?

Ideally I think I'd want a 2nd y-axis and either double bars on each period or a line series for number of tests and bars below for % pass. But I cannot figure out how to do this for this data...

Can anyone help please?

Thanks in advance

Please post a sample sheet. Pics are nice to look at but impossible to work with

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post