Visualization and Interpretation of HEI Scores
How Can HEI Scores be Displayed Graphically?
When using the HEI, it may be helpful to visualize its multidimensional qualities using a radar plot such as the one shown below.
A radar plot displays information about each component score simultaneously. The outer edge of the “wheel” (or end of the “spoke”) represents a score that is 100% of the maximum score for that component, while the center of the circle represents a score of 0% of the score for any component (see Figure 1).
Looking at the collection of component scores in this way may help those using the HEI to visualize patterns of dietary intake and compare differences in diets that may have similar scores overall (see Figure 4), but different component scores contributing to the total HEI score.
When radar plots are used to visualize an HEI score, it is important to display the components in the same order each time so that comparisons can be made. The suggested order of components is: Total Fruits, Whole Fruits, Total Vegetables, Greens & Beans, Whole Grains, Dairy, Total Protein Foods, Seafood and Plant Proteins, Fatty Acids, Refined Grains, Sodium, Added Sugars, and Saturated Fats.
Steps for Creating a Radar Plot
To create a radar plot in Excel, follow the steps below starting with your blank worksheet.
To create a radar plot directly in PowerPoint, navigate to Insert and select Chart -> Radar, and click OK. The slide will show a radar plot and will open an Excel worksheet that can be edited by following the steps below.
Key in the data you wish to plot in the radar chart. It works well to type the component names in column A and add headers in row 1 describing what is being plotted (e.g. Quintile 1, Cluster A, etc.)
*Note that the order that you type the components determines the order that they appear on the circle of the radar plot. The authors of the HEI have recommended that researchers and users of the HEI depict radar plots in the same order so that plots can be compared more easily. The recommended order is noted in the table below.
Set up the spreadsheet to calculate the component scores as percentages of the total maximum score for each component. (For reference, for HEI 2015, these scores are listed in Step 3 below). The equation in each cell should be =(X/Y)*100 where X = the component score from your sample and Y = the maximum score for that component.
Navigate to the Insert menu and select Recommended Charts and then pick the All Charts tab to select the chart called Radar.
*Note that a number of versions of Excel have a glitch that causes the radar plots not to display radial axis lines (the “spokes” of the plot). If your radar plot does not have radial lines and you would like them to display, try changing the plot to a Radar with Markers or a Filled Radar by right clicking and selecting Change Chart Type. On the new plot, find Add Chart Elements (in some Excel versions, do this by clicking on the plot and select the plus sign icon) and selecting More Options from the Axis line. In the new menu that opens, under the Axis Options tab, click on the Fill & Line icon (this icon looks like a paint can), find the section for Line, and select Solid line.
|Greens & beans||5|
|Total protein foods||5|
|Seafood & plant proteins||5|
Interpretation of HEI Scores: Grading
Information on interpretation of HEI scores utilizing grading can be found in the following publication:
Krebs-Smith SM, Pannucci TE, Subar AF, Kirkpatrick SI, Lerman JL, Tooze JA, Wilson MM, and Reedy J. Update of the Healthy Eating Index-2015. J Acad Nutr Diet. 2018 Sep;118(9):1591-1602.
See additional selected HEI publications.