Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
If you have the counts and percentages data in two columns, select both and drag them on the Y-Axis zone. Then, right-click on the Y-Axis, and Choose "Move to Right" either the Counts or the Percentages. You can then format each (left and right) Y-axis to accommodate your needs.