Updated:Scatterplot Labeling and Pivot Tables

Hi all,

So I am trying to create a bubble chart using pivot tables. I understand that you must use a regular chart and manually input the data as Excel doesn't allow the user to create bubble or scatterplots with pivot tables. But as you can see in the attachment it would take too much time to add each individual unit (FC-XXX) into the chart.

Is there a way to automatically input the pivot chart data into a bubble or scatterplot chart by any means? Probably some Macro?

Please help I'm so frustrated!

UPDATE:

I was able to format it using a scatterplot to get the result I want. Next problem is there a way I can label each point so that i can identify each unit by simply choosing the point?

This is for a dashboard btw