I am creating a spreadsheet showing the port availability in a datacenter per row.

Each row has a different total of available ports.

I have only 2 data types I want to represent. Total ports available in a row, and total ports used in that row. I want to show the 2 data points in the same column the total showing 100% and the ports used climbing up that same column to whatever percentage it is of the total in that row.

For example I will say the Row C has 48 ports total available and 12 of those are in use. 48 should be the 100% mark for that column and the 12 would be represented as 25% of the total.

This is the first graph I have created in excel and can't seem to find something that will fit the bill

I need to show all rows in the datacenter and the percentage used of the total ports for each individual row in a single chart/graph.

Any help would save my bacon!! Thanks!