...
Click on Fnish and close the rest tof the dialogs. The Analyze tab is selected in Excel showing a Piot Table on the left and the cube Measures and Dimensions on the rigt:
Click on the Issue count option in the Values (Measures) box, This counts all the issues in the cube (JQL):
Now select the Priority, Staus and Type dimensions. This will group the data according the selected dimensions:
Select the data fro the table and add achart in the regular way: