I want to do just this only i will be drilling a 10mm hole to accept 10mm acrylic tube ( I am making a manometer for balancing the carburettors on my bike). The ally will be 3/4in square bar and plenty of paraffin will be used.
Drilling sheet metal is always dodgy as the bit grabs the metal as it breaks through and spins the sheet making it an effective bacon slicer. Clamp it with at least two clamps and keep fingers well away. I will not be going all the way through the 3/4 bar just about a 1/4 inch deep.
My reason for making the manometer is that though there are plenty of vacuum gauge setups you can buy unless you go for big money the dam needles bounce about something rotten.