““Creating Lenses with Excel If you wish to use Excel radar diagrams to simulate lenses, follow these steps: Open a new Excel spreadsheet. Type the word Headers in cell A1 Type the word Score in cell B1 Type your chosen header from cell A2 downwards. Use as many headers as you like. Usually 6 or 8 headers are sufficient. Fill the corresponding B cells with zeros Select cells A1 through B… (as far as you went) Click the Chart Wizard button (the one that has a tiny bar chart on it), or use the menu - Chart – Chart Type Select the radar type from among the options in the left side of the action box. Click on the Filled Radar chart sub-type on the upper right part of the box. Click Next Make sure that the series choice is Columns. Ignore the way the chart may look in the example. It often looks too small there, but it comes out all right. Click next Add the chart title, if you want. And clear the "show legend" box in the legend tab. Click finish. Click OK to put the chart on the same sheet. When you are with your client, you can type in his chosen scores against each header in the list (replacing the zeros). Excel will automatically update the chart. If needed, you can print the charts using the file-print””
