--- title: "Meaning & Key Takeaway of: Creating Lenses with Excel If you wish to…" description: "\"“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..." image: "https://sms4smile.com/quotes/i/777/shmaya-david-28810_quote_creating-lenses-with-excel-if-you-wish-t_836101.jpg" --- # Creating Lenses with Excel If you wish to use Excel radar… ![“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…” quote by Shmaya David](https://sms4smile.com/quotes/i/777/shmaya-david-28810_quote_creating-lenses-with-excel-if-you-wish-t_836101.jpg) [Download](https://sms4smile.com/quotes/i/777/shmaya-david-28810_quote_creating-lenses-with-excel-if-you-wish-t_836101.jpg) [Open image](https://sms4smile.com/quotes/i/777/shmaya-david-28810_quote_creating-lenses-with-excel-if-you-wish-t_836101.jpg) > ““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”” [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) ## About This Quote This interpretation was drafted with AI assistance. It is one reading of the quote, not the author's own explanation. A step‑by‑step method to create radar charts in Excel that can be used as visual lenses for comparing multiple criteria. **In simple terms:** How to build radar charts in Excel for comparative analysis. Key Takeaway Use radar charts to visualize multi‑dimensional data quickly. Themes data visualization Excel charts analysis Mood practical instructional Type how‑to instructional When to use this quote - business presentations - client reporting - performance dashboards - academic research Key Concepts radar chart visual lens comparative metrics Questions to Reflect On - What data sets benefit most from radar charts? - How can you simplify a crowded radar chart? A Different Perspective Radar charts can be hard to read if too many axes are used. ★ ★ ★ ★ ★ No ratings yet [Excel Radar](https://sms4smile.com/quotes/about/excel-radar-601170/) [New Excel](https://sms4smile.com/quotes/about/new-excel-601174/) [Radar Chart](https://sms4smile.com/quotes/about/radar-chart-601171/) [Radar Diagrams](https://sms4smile.com/quotes/about/radar-diagrams-601172/) [Simulate Lenses](https://sms4smile.com/quotes/about/simulate-lenses-601173/) ## Related quotes > [“Compensation Level of interest Co-workers Chances of promotion My Job Description Subordinates”](https://sms4smile.com/quotes/shmaya-david/compensation-level-of-interest-co-workers-chances-of-promotion-my-job/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“The 8 Basic Headers Work Family & Kids Spouse Health & Fitness Home”](https://sms4smile.com/quotes/shmaya-david/the-8-basic-headers-work-family-kids-spouse-health-fitness-home/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“The 8 Basic Headers Work Family & Kids Spouse Health & Fitness Home Money Recreation & Hobbies Prospects for the Future Work The Boss…](https://sms4smile.com/quotes/shmaya-david/the-8-basic-headers-work-family-kids-spouse-health-fitness-home-money/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“Money Recreation & Hobbies Prospects for the Future Work The Boss Time Management”](https://sms4smile.com/quotes/shmaya-david/money-recreation-hobbies-prospects-for-the-future-work-the-boss-time/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“Sharing each other's passions Division of roles and responsibilities Our time together Our planes for our future Decision making Love & Passion”](https://sms4smile.com/quotes/shmaya-david/sharing-each-other-s-passions-division-of-roles-and-responsibilities/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“Family Relationship with spouse Relationship with children Relationship with extended family Home, chores and responsibilities Recreation & hobbies”](https://sms4smile.com/quotes/shmaya-david/family-relationship-with-spouse-relationship-with-children/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“This presents a simple, yet powerful  graphic representation of the client's life, and enables the coach to identify and call attention to poor results,…](https://sms4smile.com/quotes/shmaya-david/this-presents-a-simple-yet-powerful-graphic-representation-of-the/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“Money, expenses and allowances Lifestyle and standard of living Future planes and arrangements Spouse Communication type and intensity Level of independence”](https://sms4smile.com/quotes/shmaya-david/money-expenses-and-allowances-lifestyle-and-standard-of-living-future/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“Ability to take advantage of opportunities / fulfill dreams Financial security / resilience Financial IQ / Understanding / Independent decision making Social, Recreation &…](https://sms4smile.com/quotes/shmaya-david/ability-to-take-advantage-of-opportunities-fulfill-dreams-financial/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“Katz lists 8 different kinds of quality. From each, we derive general quality criteria against which any result can be measured. Type of Quality…](https://sms4smile.com/quotes/shmaya-david/katz-lists-8-different-kinds-of-quality-from-each-we-derive-general/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“We again ask what other significant results are obtained in (the name of the dimension)? This question we repeat again and again, until the…](https://sms4smile.com/quotes/shmaya-david/we-again-ask-what-other-significant-results-are-obtained-in-the-name/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“If it cannot be measured, it is impossible to know whether we have obtained it. An immeasurable goal is a sloppy and inefficient goal.”](https://sms4smile.com/quotes/shmaya-david/if-it-cannot-be-measured-it-is-impossible-to-know-whether-we-have/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“Number of interests Prospect for the future Type of occupation Ratio of work to free time Promotion & Business development (for entrepreneurs) Health &…](https://sms4smile.com/quotes/shmaya-david/number-of-interests-prospect-for-the-future-type-of-occupation-ratio/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“Money Income from work Passive income Savings and pension funds Monthly expenses Special expenses”](https://sms4smile.com/quotes/shmaya-david/money-income-from-work-passive-income-savings-and-pension-funds/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“Location Community and municipal services Proximity and quality of support/activity centers (i.e. school. Medical aid etc) Rent/Mortgage Repair / renovation Emotional atmosphere”](https://sms4smile.com/quotes/shmaya-david/location-community-and-municipal-services-proximity-and-quality-of/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) ## More by Shmaya David > [“Compensation Level of interest Co-workers Chances of promotion My Job Description Subordinates”](https://sms4smile.com/quotes/shmaya-david/compensation-level-of-interest-co-workers-chances-of-promotion-my-job/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“Money Income from work Passive income Savings and pension funds Monthly expenses Special expenses”](https://sms4smile.com/quotes/shmaya-david/money-income-from-work-passive-income-savings-and-pension-funds/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“Number of interests Prospect for the future Type of occupation Ratio of work to free time Promotion & Business development (for entrepreneurs) Health &…](https://sms4smile.com/quotes/shmaya-david/number-of-interests-prospect-for-the-future-type-of-occupation-ratio/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“If it cannot be measured, it is impossible to know whether we have obtained it. An immeasurable goal is a sloppy and inefficient goal.”](https://sms4smile.com/quotes/shmaya-david/if-it-cannot-be-measured-it-is-impossible-to-know-whether-we-have/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“We again ask what other significant results are obtained in (the name of the dimension)? This question we repeat again and again, until the…](https://sms4smile.com/quotes/shmaya-david/we-again-ask-what-other-significant-results-are-obtained-in-the-name/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“Katz lists 8 different kinds of quality. From each, we derive general quality criteria against which any result can be measured. Type of Quality…](https://sms4smile.com/quotes/shmaya-david/katz-lists-8-different-kinds-of-quality-from-each-we-derive-general/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“Ability to take advantage of opportunities / fulfill dreams Financial security / resilience Financial IQ / Understanding / Independent decision making Social, Recreation &…](https://sms4smile.com/quotes/shmaya-david/ability-to-take-advantage-of-opportunities-fulfill-dreams-financial/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“Money, expenses and allowances Lifestyle and standard of living Future planes and arrangements Spouse Communication type and intensity Level of independence”](https://sms4smile.com/quotes/shmaya-david/money-expenses-and-allowances-lifestyle-and-standard-of-living-future/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“This presents a simple, yet powerful  graphic representation of the client's life, and enables the coach to identify and call attention to poor results,…](https://sms4smile.com/quotes/shmaya-david/this-presents-a-simple-yet-powerful-graphic-representation-of-the/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“Family Relationship with spouse Relationship with children Relationship with extended family Home, chores and responsibilities Recreation & hobbies”](https://sms4smile.com/quotes/shmaya-david/family-relationship-with-spouse-relationship-with-children/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“Sharing each other's passions Division of roles and responsibilities Our time together Our planes for our future Decision making Love & Passion”](https://sms4smile.com/quotes/shmaya-david/sharing-each-other-s-passions-division-of-roles-and-responsibilities/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“Money Recreation & Hobbies Prospects for the Future Work The Boss Time Management”](https://sms4smile.com/quotes/shmaya-david/money-recreation-hobbies-prospects-for-the-future-work-the-boss-time/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“The 8 Basic Headers Work Family & Kids Spouse Health & Fitness Home Money Recreation & Hobbies Prospects for the Future Work The Boss…](https://sms4smile.com/quotes/shmaya-david/the-8-basic-headers-work-family-kids-spouse-health-fitness-home-money/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“The 8 Basic Headers Work Family & Kids Spouse Health & Fitness Home”](https://sms4smile.com/quotes/shmaya-david/the-8-basic-headers-work-family-kids-spouse-health-fitness-home/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) > [“Location Community and municipal services Proximity and quality of support/activity centers (i.e. school. Medical aid etc) Rent/Mortgage Repair / renovation Emotional atmosphere”](https://sms4smile.com/quotes/shmaya-david/location-community-and-municipal-services-proximity-and-quality-of/) [Shmaya David](https://sms4smile.com/quotes/author/shmaya-david/) [Explore all 19 Shmaya David quotes ](https://sms4smile.com/quotes/author/shmaya-david/) ```json { "@context": "https://schema.org", "@graph": [ { "@type": "Quotation", "text": "“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”", "creator": { "@type": "Person", "name": "Shmaya David" }, "isPartOf": { "@id": "https://sms4smile.com/quotes/#website" }, "url": "https://sms4smile.com/quotes/shmaya-david/creating-lenses-with-excel-if-you-wish-to-use-excel-radar-diagrams-to/", "about": { "@type": "Thing", "name": "Excel Radar" }, "@id": "https://sms4smile.com/quotes/shmaya-david/creating-lenses-with-excel-if-you-wish-to-use-excel-radar-diagrams-to/#quotation", "image": { "@type": "ImageObject", "@id": "https://sms4smile.com/quotes/i/777/shmaya-david-28810_quote_creating-lenses-with-excel-if-you-wish-t_836101.jpg", "contentUrl": "https://sms4smile.com/quotes/i/777/shmaya-david-28810_quote_creating-lenses-with-excel-if-you-wish-t_836101.jpg", "url": "https://sms4smile.com/quotes/i/777/shmaya-david-28810_quote_creating-lenses-with-excel-if-you-wish-t_836101.jpg", "width": 1080, "height": 1080, "caption": "“Creating Lenses with Excel If you wish to use Excel radar diagrams to simulate lenses, follow these steps…” — Shmaya David", "creditText": "SMS4Smile Quotes", "creator": { "@id": "https://sms4smile.com/quotes/#organization" } } }, { "@type": "BreadcrumbList", "itemListElement": [ { "@type": "ListItem", "position": 1, "name": "Home", "item": "https://sms4smile.com/" }, { "@type": "ListItem", "position": 2, "name": "Quotes", "item": "https://sms4smile.com/quotes/" }, { "@type": "ListItem", "position": 3, "name": "Shmaya David", "item": "https://sms4smile.com/quotes/author/shmaya-david/" }, { "@type": "ListItem", "position": 4, "name": "“Creating Lenses with Excel If you...", "item": "https://sms4smile.com/quotes/shmaya-david/creating-lenses-with-excel-if-you-wish-to-use-excel-radar-diagrams-to/" } ], "@id": "https://sms4smile.com/quotes/shmaya-david/creating-lenses-with-excel-if-you-wish-to-use-excel-radar-diagrams-to/#breadcrumb" }, { "@type": "WebSite", "@id": "https://sms4smile.com/quotes/#website", "name": "SMS4Smile Quotes", "url": "https://sms4smile.com/quotes/", "publisher": { "@id": "https://sms4smile.com/quotes/#organization" } }, { "@type": "Organization", "@id": "https://sms4smile.com/quotes/#organization", "name": "SMS4Smile Quotes", "url": "https://sms4smile.com/quotes/", "logo": { "@type": "ImageObject", "url": "https://sms4smile.com/quotes/wp-content/themes/sq/assets/icons/icon-512.png", "width": 512, "height": 512 } } ] } ```