This question is not clear, but you could display your data set in a stacked bar chart to see if that does what you want.
A chart is graphical, like a pie chart or a bar chart or a column chart. A table is an organised set of figures laid out in a table. You might use figures in the table to make a chart.
You can use data typed into a spreadsheet to make a chart automatically. Depending on how you want to display your data, in pie chart form, as a line graph, or a series of bar graphs, you can select the data to chart, click the chart icon, then choose the chart type to best represent your data visually.
First you need to have the correct kind of data that is appropriate for the chart. Then you select it. You can then start the chart wizard and choose the chart you want. You can also select the data and then press the F11 key.
No, unless you put the chart on top of the data and are unable to get to it any more to make changes.
To make a data table you must make a chart with how ever many columns you are going to need and then fill out your information.
You make sure all your data is correct and you have whatever headings you may need. You then select the data that you want in your chart, with the headings if necessary. You then start the Chart Wizard by clicking on its icon. Pressing the F11 key or pressing and hold the Alt key and the pressing F1, will create a chart immediately from the data. You can then make adjustments with it to change it to the way you want using the options in the Chart menu.
When you make your pie chart in Excel, set the parameters of the chart to display percent for each data item (slice of the pie).
Each one. On A tally chart represents 1 Each. Number Represents 5 make. A tally chart
Using charts to organise your data is more reliable as it enables you to put the data in the appropriate chart, this means you data will make more sense if needed to be explained and it also makes it easier to analyse your data.
A time series chart is good for showing data that occurs over a time interval, but the intervals between data points are not consistent. See related links for how to make a time series chart with Excel.
The individual values that are on the chart itself are known as points or data points. A group of related values together make up a series.
You need to check the source data. You can have only one series for a pie chart. The data must be numeric data. Make sure all things are correct and then try again.