To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.
Being upfront about presenting portfolio is non-negotiable if you want people to actually trust you - clients, coworkers, ...