First, I would synchronize your axis. Right-click one of your axes and select 'Synchronize axis'. This will show the true relative size between your line and your bars.
As for seeing the % failure on this view, you're not going to be able to. Your values are in the hundreds of thousands, and your percentages are all below 20. They're just too small.
If you want to see the failure, you need to instead use the total of failures, not the percentage. So, for example, your '11+' group had 10% failure. If you were to use the total failures instead, your grey line would be 4,163.
Even then, it's such a small number it probably won't be visible.
I recommended removing your running total from the chart completely and try a different chart type.
1 of 1 people found this helpful
Your problem is that your Tableau chart has the wrong value for your orange line. Your orange line is a running total, whereas in the snapshot out of Excel, that line is a PERCENTAGE of cumulative failure. So in Tableau, you need to convert your running total into a percentage of total. Then your right axis till be from 0% to 100% and your grey and orange lines will show up.
thanks Mike .I did nt realize that it was cumulative percentage