Using charts in excel share one way that you think charts in MS EXCEL CAN BE USED IN BUSINESS (for example to show a breakdown of different types of products ) think about pie charts. bar charts. line charts column charts etc. and each displays excel data.