Actually, within Excel you must have the spreadsheet prior to creating a chart.
But, the advantage to creating the chart is that it gives the viewer more of a visual story of what is occurring, instead of just a list of data or numbers.
Chat with our AI personalities
bar chart and pie chart
The original spreadsheet, or you can get the chart to have a data table attached to it when you are creating it.
A spreadsheet does not show a pictorial form, but you can use the data in a spreadsheet to generate a chart, which will show a picture representing the data.
A pie chart or, if you want to show similar details for a number of wholes, a "100 percent stacked column" chart. An example of the second might be the gender split over a number of forms in a school. Each year or form would be a whole column, and each would be divided into boys and girls.
Import your data into an Excel spreadsheet. Select the data appropriately and choose the graph you would like to present your data in. You can use chart wizard to do this.