We can use a bubble chart instead of a scatter chart where there are three data series (X, Y , Z). Z determines size of the bubble.
(1) Select three data columns (X, Y and Z).
You can specify different options before clicking finish.
Two variation charts produced in Excel 2003. 3D format is more attractive in Excel 2013.