You can make a bar graph in Excel by first ... suit different data sets. For example, if you have several types of data in each category, you can use a clustered bar to represent it side-by ...

You can split cells into columns in Excel using the "Text to Columns ... 4. Click in the ruler at the top of the "Data preview" to indicate where you want to break the text into multiple columns.