The source data has more data than you need arrayed in the table, so you will need to hide those items in the source data that are not needed to be portrayed in the chart.
| Why we do this | What we are to do | Some thoughts |
|---|---|---|
| To prepare the data |
using the data on the 16-Chart 02 worksheet
select the values in columns E, G, I, K, M, O, Q, and S |
You may find it useful to hide the columns you are not going to select, to see only column A plus these eight columns |
| To create a chart that compares multiple data sets by category | create a chart that compares these values to the categories in column A. | Do not include the totals on row 57. |
| We want to see the relative amount of each category of values in each state, so this will be a stacked chart of some type. |
Place the chart on a separate worksheet
(this means the chart stands alone on a worksheet and does not float above a grid of cells on a worksheet) named 16-Veterans. |
Use any appropriate chart style that pleases you, but again here, do not settle for the defaults.
Customize the chart in some fashion. |
| To demonstrate facility with the chart formatting tools | Make it very clear in the formatting which values are which. | If the data format is self-explanatory, you may not need a label for an axis. |
| To bring attention to something in the chart using a your understanding of formatting data labels | Use the data label formatting tools to point out the state who has the highest number of Asian, non-Hispanic veterans | Format your axes and axes labels so that the viewer is in no doubt about what is being depicted. |
| To demonstrate facility with the chart formatting tools | If you use a legend, put it at the top of the chart and it may overlap the but should not cover any important things that need to be seen. | If you use a legend, be sure to have the legend pull its name from the appropriate cell in the worksheet. |