Learn how to show charts with hidden data cells in Excel. When there is data that is hidden in your table, Excel will not show that information in the chart.

However, Microsoft Excel grants you the convenient option in Chart Tools to move this chart to a new sheet, which also enlarges it for easier viewing.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

With Excel's versatile chart tool, putting together data visualizations is as easy as pie (groan).

Open the Excel workbook to the worksheet that has the list of data already entered into cells. Alternatively, type a new list of data on a worksheet; click on the default worksheet name "Sheet1 ...