To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.
You can delete a pivot table in Excel with a few clicks on a Mac or Windows PC. Here are two ways to do it.