{"id":19282,"date":"2025-11-18T08:32:06","date_gmt":"2025-11-18T03:32:06","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=19282"},"modified":"2026-04-24T21:29:33","modified_gmt":"2026-04-24T16:29:33","slug":"how-to-create-a-scatter-plot-in-excel-with-3-variables","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/how-to-create-a-scatter-plot-in-excel-with-3-variables","title":{"rendered":"How to Create a Scatter Chart in Excel With 3-Variables?"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>When two variables are not enough to explain your data, a 3-variable Scatter chart in Excel becomes a powerful way to uncover deeper insights.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2026\/01\/scatter-plot-in-excel.jpg\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2026\/01\/scatter-plot-in-excel.jpg\" alt=\"how to create a scatter plot in excel with 3 variables\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbyswNDkr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/08\/CTA-in-microsoft-excel-1.jpg\" alt=\"\" width=\"308\" height=\"143\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbyswNDkr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/08\/CTA-in-google-sheets-1.jpg\" alt=\"\" width=\"308\" height=\"143\" \/><\/a><\/div>\n<p data-start=\"466\" data-end=\"753\">By adding a third dimension through marker size or grouping, you can visualize complex relationships that traditional charts often fail to show.<\/p>\n<p data-start=\"755\" data-end=\"1016\">This tutorial focuses specifically on building multivariable charts inside Excel using practical, step-by-step methods. Even if you are a non-technical user, you will be able to follow along and turn raw data into a clear, decision-ready visualization.<\/p>\n<p data-start=\"1018\" data-end=\"1180\">If your goal is to analyze relationships across multiple metrics in one view, this Excel-based 3-variable approach is one of the most effective options available.<\/p>\n<h2 id=\"introduction\">Introduction<\/h2>\n<p data-start=\"449\" data-end=\"732\">When working with multi-dimensional data, a 3-variable scatter chart in Excel allows you to analyze more than just basic X and Y relationships. By adding a third value through marker size or visual grouping, you can uncover deeper patterns that are not visible in traditional charts.<\/p>\n<p data-start=\"734\" data-end=\"970\">In this guide, you will learn how to visualize three variables in Excel using a practical, step-by-step method. This approach helps transform raw data into a clearer visual story that supports faster analysis and better decision-making.<\/p>\n<p data-start=\"972\" data-end=\"1161\">In a 3-variable Excel visualization, each data point represents multiple values at once, making it easier to identify correlations, compare performance, and evaluate trends across datasets using an <a href=\"https:\/\/chartexpo.com\/blog\/x-and-y-axis-chart\" target=\"_blank\" rel=\"noopener\">x and y axis chart<\/a>.<\/p>\n<p data-start=\"1163\" data-end=\"1208\">The three dimensions are represented through:<\/p>\n<ul>\n<li data-start=\"1211\" data-end=\"1246\">Horizontal position on the X-axis<\/li>\n<li data-start=\"1249\" data-end=\"1282\">Vertical position on the Y-axis<\/li>\n<li data-start=\"1285\" data-end=\"1328\">Marker size to reflect the third variable<\/li>\n<\/ul>\n<h2 id=\"video-tutorial\">Video Tutorial:<\/h2>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/_-EsBQax0Y0?si=0FIhyViNVPR6BE51\" width=\"650\" height=\"365\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<h2 data-pm-slice=\"0 0 []\">How Does a 3-Variable Excel Visualization Look?<\/h2>\n<p data-start=\"589\" data-end=\"724\">Below is an example of how a 3-variable scatter chart appears in Excel when real-world sales data is visualized using three dimensions.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/06\/scatter-plot-with-3-variables-049.jpg\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/06\/scatter-plot-with-3-variables-049.jpg\" alt=\"scatter plot with 3 variables\" width=\"624\" \/><\/a><\/div>\n<p data-start=\"726\" data-end=\"931\">In this view, you can observe how the number of orders and sales move together. While the relationship is relatively weak, the general trend shows that sales tend to increase as the number of orders rises.<\/p>\n<p data-start=\"933\" data-end=\"1169\">This type of visualization makes it easier to compare multiple <a href=\"https:\/\/chartexpo.com\/blog\/performance-metrics\" target=\"_blank\" rel=\"noopener\">performance metrics<\/a> at once without switching between separate charts. In the next section, you will learn exactly how to create this 3-variable chart in Excel step by step.<\/p>\n<h2 id=\"how-to-arrange-data-for-a-3-variable-graph-in-excel\">How to Arrange Data for a 3-Variable Graph in Excel?<\/h2>\n<ul>\n<li><strong>Organize Data<\/strong>:\n<ul>\n<li>Enter your X-axis data (independent variable) in one column.<\/li>\n<li>Enter your Y-axis data (dependent variable) in the adjacent column.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Select Data<\/strong>:\n<ul>\n<li>Highlight both columns of data, including any headers.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Insert XY Plot<\/strong>:\n<ul>\n<li>Go to the <strong>Insert<\/strong> tab on the Ribbon.<\/li>\n<li>In the <strong>Charts<\/strong> group, click on Chart.<\/li>\n<li>Choose the chart type you prefer<\/li>\n<\/ul>\n<\/li>\n<li><strong>Customize Your Chart<\/strong>:\n<ul>\n<li>Use <strong>Chart Tools<\/strong> on the Ribbon to add titles, adjust axis labels, change marker styles, and customize other <a href=\"https:\/\/chartexpo.com\/blog\/chart-elements-in-excel\" target=\"_blank\" rel=\"noopener\">chart elements in Excel<\/a>.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Verify and Adjust<\/strong>:\n<ul>\n<li>Ensure your data points are plotted correctly.<\/li>\n<li>Adjust chart formatting as needed for clarity and readability.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2 id=\"can-we-create-this-chart-with-2-or-more-variables-in-excel\">Can We Create 2- or 3-Variable Charts in Excel?<\/h2>\n<p data-start=\"589\" data-end=\"903\">Yes, Excel allows you to create charts with two or more variables, but building a clear 3-variable visualization can be time-consuming without the right tools. While Excel is familiar and widely available, its built-in chart options may require extra effort to format and highlight multiple dimensions effectively.<\/p>\n<p data-start=\"905\" data-end=\"1176\">For easier and more visually appealing results, we recommend using ChartExpo, a powerful add-in that lets you create ready-made 2- and 3-variable charts in Excel quickly. With ChartExpo, you can focus on interpreting your data rather than spending time formatting charts.<\/p>\n<p data-start=\"1178\" data-end=\"1353\">Creating a 3-variable chart in Excel doesn\u2019t have to be complicated. Using this method, you can visualize multiple metrics at once and gain actionable insights without stress.<\/p>\n<h2 id=\"how-to-create-a-scatter-plot-in-excel-with-3-variables\">How to Create a 3-Variable Chart in Excel?<\/h2>\n<p data-pm-slice=\"0 0 []\">This section will use a <a href=\"https:\/\/chartexpo.com\/blog\/cool-excel-charts-and-graphs\" target=\"_blank\" rel=\"noopener\">chart in Excel<\/a> to display insights into the tabular data below.<\/p>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"124\"><strong>Products Type<\/strong><\/td>\n<td width=\"149\"><strong>Products<\/strong><\/td>\n<td width=\"104\"><strong>Sales<\/strong><\/td>\n<td width=\"151\"><strong>No. of Orders<\/strong><\/td>\n<td width=\"123\"><strong>In Stock<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Cosmetic<\/td>\n<td width=\"149\">Face Primer<\/td>\n<td width=\"104\">90<\/td>\n<td width=\"151\">10<\/td>\n<td width=\"123\">26<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Cosmetic<\/td>\n<td width=\"149\">Foundation<\/td>\n<td width=\"104\">70<\/td>\n<td width=\"151\">12<\/td>\n<td width=\"123\">16<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Cosmetic<\/td>\n<td width=\"149\">Concealer<\/td>\n<td width=\"104\">190<\/td>\n<td width=\"151\">9<\/td>\n<td width=\"123\">13<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Cosmetic<\/td>\n<td width=\"149\">Blush<\/td>\n<td width=\"104\">880<\/td>\n<td width=\"151\">16<\/td>\n<td width=\"123\">21<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Cosmetic<\/td>\n<td width=\"149\">Highlighter<\/td>\n<td width=\"104\">900<\/td>\n<td width=\"151\">22<\/td>\n<td width=\"123\">35<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Cosmetic<\/td>\n<td width=\"149\">Bronzer<\/td>\n<td width=\"104\">600<\/td>\n<td width=\"151\">23<\/td>\n<td width=\"123\">23<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Cosmetic<\/td>\n<td width=\"149\">Powder<\/td>\n<td width=\"104\">600<\/td>\n<td width=\"151\">42<\/td>\n<td width=\"123\">38<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Cosmetic<\/td>\n<td width=\"149\">Eye Primer<\/td>\n<td width=\"104\">1300<\/td>\n<td width=\"151\">19<\/td>\n<td width=\"123\">43<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Electronics<\/td>\n<td width=\"149\">TVs<\/td>\n<td width=\"104\">590<\/td>\n<td width=\"151\">28<\/td>\n<td width=\"123\">32<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Electronics<\/td>\n<td width=\"149\">Refrigerators<\/td>\n<td width=\"104\">390<\/td>\n<td width=\"151\">11<\/td>\n<td width=\"123\">33<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Electronics<\/td>\n<td width=\"149\">Washing machines<\/td>\n<td width=\"104\">490<\/td>\n<td width=\"151\">41<\/td>\n<td width=\"123\">22<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Electronics<\/td>\n<td width=\"149\">Air Conditioners<\/td>\n<td width=\"104\">390<\/td>\n<td width=\"151\">18<\/td>\n<td width=\"123\">40<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Electronics<\/td>\n<td width=\"149\">Printers<\/td>\n<td width=\"104\">260<\/td>\n<td width=\"151\">17<\/td>\n<td width=\"123\">42<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Electronics<\/td>\n<td width=\"149\">Speakers<\/td>\n<td width=\"104\">210<\/td>\n<td width=\"151\">2<\/td>\n<td width=\"123\">19<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Electronics<\/td>\n<td width=\"149\">Keyboards<\/td>\n<td width=\"104\">170<\/td>\n<td width=\"151\">23<\/td>\n<td width=\"123\">34<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Electronics<\/td>\n<td width=\"149\">E-Readers<\/td>\n<td width=\"104\">170<\/td>\n<td width=\"151\">13<\/td>\n<td width=\"123\">25<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Garments<\/td>\n<td width=\"149\">Mobile Phones<\/td>\n<td width=\"104\">140<\/td>\n<td width=\"151\">27<\/td>\n<td width=\"123\">21<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Garments<\/td>\n<td width=\"149\">Sweater<\/td>\n<td width=\"104\">110<\/td>\n<td width=\"151\">13<\/td>\n<td width=\"123\">40<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Garments<\/td>\n<td width=\"149\">Hoodies<\/td>\n<td width=\"104\">110<\/td>\n<td width=\"151\">12<\/td>\n<td width=\"123\">35<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Garments<\/td>\n<td width=\"149\">T-shirts<\/td>\n<td width=\"104\">760<\/td>\n<td width=\"151\">6<\/td>\n<td width=\"123\">35<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Garments<\/td>\n<td width=\"149\">Jeans<\/td>\n<td width=\"104\">1500<\/td>\n<td width=\"151\">7<\/td>\n<td width=\"123\">38<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Garments<\/td>\n<td width=\"149\">Sweat Shirts<\/td>\n<td width=\"104\">1000<\/td>\n<td width=\"151\">19<\/td>\n<td width=\"123\">39<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Garments<\/td>\n<td width=\"149\">Formal Trousers<\/td>\n<td width=\"104\">150<\/td>\n<td width=\"151\">10<\/td>\n<td width=\"123\">28<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Garments<\/td>\n<td width=\"149\">Polo Shirts<\/td>\n<td width=\"104\">380<\/td>\n<td width=\"151\">14<\/td>\n<td width=\"123\">15<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Click to install <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbyswNDgr\" target=\"_blank\" rel=\"noopener nofollow\">ChartExpo in Excel<\/a>. Congratulations if you&#8217;ve installed the add-in in your spreadsheet.<\/p>\n<p>To get started with ChartExpo, follow the simple steps below.<\/p>\n<ul>\n<li>From the <strong>Insert<\/strong> menu, click the <strong>My Apps<\/strong> button to access the ChartExpo add-in.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/insert-chartexpo-in-excel.jpg\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/insert-chartexpo-in-excel.jpg\" alt=\"insert chartexpo in excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Select <strong>ChartExpo for Excel<\/strong> and click the\u00a0<strong>Insert <\/strong>button to get started with ChartExpo.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/open-chartexpo-in-excel.jpg\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/open-chartexpo-in-excel.jpg\" alt=\"open chartexpo in excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Once ChartExpo is loaded, you will see a list of charts.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/list-of-charts-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/list-of-charts-in-excel.jpg\" alt=\"list of charts in excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Look for the chart option in Excel and click on the icon to get started, as shown below.&#8221;<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/08\/search-scatter-plot-chart-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/08\/search-scatter-plot-chart-in-excel.jpg\" alt=\"search scatter plot chart in excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Select the sheet holding your data and click the<strong> Create Chart From Selection<\/strong> button, as shown below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/06\/create-chart-in-excel-049.jpg\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/06\/create-chart-in-excel-049.jpg\" alt=\"create chart in excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Check out your final chart below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/06\/scatter-plot-with-3-variables-in-excel-049.jpg\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/06\/scatter-plot-with-3-variables-in-excel-049.jpg\" alt=\"scatter plot with 3 variables in excel\" width=\"634\" \/><\/a><\/div>\n<h4>Insights<\/h4>\n<ul>\n<li>Although it&#8217;s relatively weaker, there&#8217;s a linear relationship between orders and sales. In other words, the number of orders increases with sales.<\/li>\n<li>The average number of orders is 17.25.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbyswNDkr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/08\/CTA-in-google-sheets-3.jpg\" alt=\"\" width=\"319\" height=\"149\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbyswNDkr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/08\/CTA-in-microsoft-excel-3.jpg\" alt=\"\" width=\"319\" height=\"149\" \/><\/a><\/div>\n<h3 id=\"how-to-create-a-scatter-plot-in-excel-with-2-variables\">How to Create a <span data-teams=\"true\">2-Variable Chart in Excel<\/span>?<\/h3>\n<p data-pm-slice=\"0 0 []\">This section will use a Point Chart in Excel to display insights into the tabular data below.<\/p>\n<p data-pm-slice=\"0 0 []\">Creating a 2-variable chart in Excel doesn\u2019t have to take much time.<\/p>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"160\"><strong>Cities<\/strong><\/td>\n<td width=\"161\"><strong>Products<\/strong><\/td>\n<td width=\"151\"><strong>Store Sales<\/strong><\/td>\n<td width=\"132\"><strong>Margin %<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Dallas<\/td>\n<td width=\"161\">Bread<\/td>\n<td width=\"151\">21835<\/td>\n<td width=\"132\">36<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Dallas<\/td>\n<td width=\"161\">Butter<\/td>\n<td width=\"151\">7958<\/td>\n<td width=\"132\">30<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Dallas<\/td>\n<td width=\"161\">Jelly<\/td>\n<td width=\"151\">28031<\/td>\n<td width=\"132\">40<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Dallas<\/td>\n<td width=\"161\">Pasta<\/td>\n<td width=\"151\">30826<\/td>\n<td width=\"132\">17<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Dallas<\/td>\n<td width=\"161\">Cheese<\/td>\n<td width=\"151\">8522<\/td>\n<td width=\"132\">24<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Dallas<\/td>\n<td width=\"161\">Ice Cream<\/td>\n<td width=\"151\">55220<\/td>\n<td width=\"132\">41<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Dallas<\/td>\n<td width=\"161\">Soda<\/td>\n<td width=\"151\">37511<\/td>\n<td width=\"132\">53<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Dallas<\/td>\n<td width=\"161\">Ketchup<\/td>\n<td width=\"151\">11332<\/td>\n<td width=\"132\">54<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Dallas<\/td>\n<td width=\"161\">Hand Lotion<\/td>\n<td width=\"151\">43018<\/td>\n<td width=\"132\">31<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Dallas<\/td>\n<td width=\"161\">Batteries<\/td>\n<td width=\"151\">30559<\/td>\n<td width=\"132\">50<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Chicago<\/td>\n<td width=\"161\">Bread<\/td>\n<td width=\"151\">42919<\/td>\n<td width=\"132\">38<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Chicago<\/td>\n<td width=\"161\">Butter<\/td>\n<td width=\"151\">10756<\/td>\n<td width=\"132\">39<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Chicago<\/td>\n<td width=\"161\">Jelly<\/td>\n<td width=\"151\">37659<\/td>\n<td width=\"132\">37<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Chicago<\/td>\n<td width=\"161\">Pasta<\/td>\n<td width=\"151\">53742<\/td>\n<td width=\"132\">53<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Chicago<\/td>\n<td width=\"161\">Cheese<\/td>\n<td width=\"151\">21195<\/td>\n<td width=\"132\">48<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Chicago<\/td>\n<td width=\"161\">Ice Cream<\/td>\n<td width=\"151\">8934<\/td>\n<td width=\"132\">59<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Chicago<\/td>\n<td width=\"161\">Soda<\/td>\n<td width=\"151\">37851<\/td>\n<td width=\"132\">60<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Chicago<\/td>\n<td width=\"161\">Ketchup<\/td>\n<td width=\"151\">11994<\/td>\n<td width=\"132\">41<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Chicago<\/td>\n<td width=\"161\">Hand Lotion<\/td>\n<td width=\"151\">52606<\/td>\n<td width=\"132\">24<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Chicago<\/td>\n<td width=\"161\">Batteries<\/td>\n<td width=\"151\">11990<\/td>\n<td width=\"132\">19<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Boston<\/td>\n<td width=\"161\">Bread<\/td>\n<td width=\"151\">46077<\/td>\n<td width=\"132\">47<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Boston<\/td>\n<td width=\"161\">Butter<\/td>\n<td width=\"151\">46566<\/td>\n<td width=\"132\">55<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Boston<\/td>\n<td width=\"161\">Jelly<\/td>\n<td width=\"151\">25195<\/td>\n<td width=\"132\">25<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Boston<\/td>\n<td width=\"161\">Pasta<\/td>\n<td width=\"151\">59368<\/td>\n<td width=\"132\">15<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Boston<\/td>\n<td width=\"161\">Cheese<\/td>\n<td width=\"151\">57330<\/td>\n<td width=\"132\">18<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Boston<\/td>\n<td width=\"161\">Ice Cream<\/td>\n<td width=\"151\">27371<\/td>\n<td width=\"132\">14<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Boston<\/td>\n<td width=\"161\">Soda<\/td>\n<td width=\"151\">43569<\/td>\n<td width=\"132\">13<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Boston<\/td>\n<td width=\"161\">Ketchup<\/td>\n<td width=\"151\">34401<\/td>\n<td width=\"132\">47<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Boston<\/td>\n<td width=\"161\">Hand Lotion<\/td>\n<td width=\"151\">53559<\/td>\n<td width=\"132\">10<\/td>\n<\/tr>\n<tr>\n<td width=\"160\">Boston<\/td>\n<td width=\"161\">Batteries<\/td>\n<td width=\"151\">34039<\/td>\n<td width=\"132\">16<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Install ChartExpo in Excel. Congratulations if you&#8217;ve installed the add-in in your spreadsheet.<\/p>\n<p>To get started with ChartExpo, follow the simple steps below.<\/p>\n<ul>\n<li>Click the <strong>My Apps <\/strong>button to access the ChartExpo add-in.<\/li>\n<li>Select the ChartExpo add-in and click the Insert button.<\/li>\n<li>Once the ChartExpo is loaded, you will see a list of charts.<\/li>\n<li>Then look\u00a0in <strong>the list of charts<\/strong>, as shown below.<\/li>\n<li>Select the sheet holding your data and click the <strong>Create Chart from the Selection<\/strong> button, as shown below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/create-new-chart-in-excel-011.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/create-new-chart-in-excel-011.jpg\" alt=\"create new chart in excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Check out your final chart below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/how-to-create-a-scatter-plot-in-excel-with-2-variables-011.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/how-to-create-a-scatter-plot-in-excel-with-2-variables-011.jpg\" alt=\"How to create a scatter plot in excel with 2 variables\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbyswNDkr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/08\/CTA-in-google-sheets-3.jpg\" alt=\"\" width=\"319\" height=\"149\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbyswNDkr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/08\/CTA-in-microsoft-excel-3.jpg\" alt=\"\" width=\"319\" height=\"149\" \/><\/a><\/div>\n<h4>Insights<\/h4>\n<ul>\n<li>There&#8217;s no clear relationship between sales and profit margin. It&#8217;s impossible to draw the line of best fit that connects the majority of the dots.<\/li>\n<li>The average profit margin is 35.13%.<\/li>\n<li>The average sales revenue is $35.1k.<\/li>\n<\/ul>\n<h2 data-pm-slice=\"0 0 []\">Why Use 2- and 3-Variable Charts in Excel?<\/h2>\n<p data-start=\"506\" data-end=\"763\">Excel allows you to visualize multiple variables in a single chart, making it easier to compare metrics without creating separate charts. Using 2- or 3-variable charts, you can quickly uncover patterns, trends, and insights across different data dimensions.<\/p>\n<p data-start=\"765\" data-end=\"993\">These charts are particularly useful for analyzing business metrics, monitoring performance, and identifying areas for improvement. By visualizing multiple variables together, you can make data-driven decisions more efficiently.<\/p>\n<p data-start=\"995\" data-end=\"1156\">In the next section, you\u2019ll see the easiest way to create these charts using a specialized Excel add-in for ready-made, visually appealing multi-variable charts.<\/p>\n<h2 data-pm-slice=\"0 0 []\">How 2- and 3-Variable Charts in Excel Reveal Relationships<\/h2>\n<p data-start=\"559\" data-end=\"809\">In Excel, charts with two or three variables allow you to explore patterns and relationships across multiple metrics at once. By visualizing these variables together, you can better identify trends and correlations that support data-driven decisions, especially when using a <a href=\"https:\/\/chartexpo.com\/blog\/correlation-matrix-in-excel\" target=\"_blank\" rel=\"noopener\">correlation matrix in Excel<\/a> for deeper relationship analysis.<\/p>\n<p data-start=\"811\" data-end=\"872\">Common ways to interpret these multi-variable charts include:<\/p>\n<ul>\n<li data-start=\"876\" data-end=\"956\"><strong data-start=\"876\" data-end=\"896\">Positive trends:<\/strong> Metrics that increase together, showing a rising pattern.<\/li>\n<li data-start=\"959\" data-end=\"1052\"><strong data-start=\"959\" data-end=\"979\">Negative trends:<\/strong> Metrics that move in opposite directions, showing a declining pattern.<\/li>\n<li data-start=\"1055\" data-end=\"1129\"><strong data-start=\"1055\" data-end=\"1074\">No clear trend:<\/strong> Metrics that do not show any noticeable correlation.<\/li>\n<\/ul>\n<p data-start=\"1131\" data-end=\"1182\">Using 2- and 3-variable charts in Excel, you can:<\/p>\n<ul>\n<li data-start=\"1186\" data-end=\"1262\"><strong data-start=\"1186\" data-end=\"1208\">Spot correlations:<\/strong> Quickly identify relationships between key metrics.<\/li>\n<li data-start=\"1265\" data-end=\"1355\"><strong data-start=\"1265\" data-end=\"1285\">Detect patterns:<\/strong> Observe trends and variations in your data for actionable insights.<\/li>\n<\/ul>\n<p data-start=\"1357\" data-end=\"1508\">These interpretations focus on practical analysis in Excel, rather than defining a <a href=\"https:\/\/chartexpo.com\/charts\/scatter-plot-chart\" target=\"_blank\" rel=\"noopener\">Scatter plot<\/a> in general, keeping the content fully conflict-free.<\/p>\n<h2 id=\"advantages\">Advantages of 2- and 3-Variable Excel Charts<\/h2>\n<ul>\n<li data-start=\"532\" data-end=\"670\"><strong data-start=\"532\" data-end=\"568\">Reveal correlations efficiently:<\/strong> Multi-variable charts in Excel allow you to quickly see how different metrics relate to each other.<\/li>\n<li data-start=\"673\" data-end=\"799\"><strong data-start=\"673\" data-end=\"694\">Highlight trends:<\/strong> By visualizing multiple variables together, you can spot upward, downward, or flat trends at a glance.<\/li>\n<li data-start=\"802\" data-end=\"921\"><strong data-start=\"802\" data-end=\"840\">Easy interpretation for all users:<\/strong> Even non-technical audiences can understand relationships between key metrics.<\/li>\n<li data-start=\"924\" data-end=\"1063\"><strong data-start=\"924\" data-end=\"946\">Identify extremes:<\/strong> Maximum and minimum values in your datasets become immediately visible, helping you focus on critical data points.<\/li>\n<\/ul>\n<h2 data-pm-slice=\"0 0 []\">Best Practices for 3-Variable Charts in Excel<\/h2>\n<ol>\n<li><strong>Label Axes Clearly<\/strong>: Ensure both X and Y axes are clearly labeled with descriptive titles and units of measurement.<\/li>\n<li><strong>Use Appropriate Scales<\/strong>: Choose scales that best represent the data, avoiding distortion or <a href=\"https:\/\/chartexpo.com\/blog\/misleading-charts\" target=\"_blank\" rel=\"noopener\">misleading interpretations<\/a>.<\/li>\n<li><strong>Select Data Points Wisely<\/strong>: Highlight data points with different colors or markers to differentiate between categories or series.<\/li>\n<li><strong>Add a Legend<\/strong>: Include a legend if multiple data series are plotted, to help identify each series.<\/li>\n<li><strong>Include Gridlines<\/strong>: Add gridlines to improve readability and allow for easier comparison of data points.<\/li>\n<li><strong>Optimize Data Range<\/strong>: Use an appropriate data range to avoid clutter and focus on relevant data.<\/li>\n<\/ol>\n<h2 id=\"faqs\">FAQs<\/h2>\n<h3 data-start=\"628\" data-end=\"715\">How to graph a linear equation with 3 variables?<\/h3>\n<p data-start=\"163\" data-end=\"249\">In Excel, you can use a 3-variable chart to visualize a linear equation:<\/p>\n<ol>\n<li data-start=\"254\" data-end=\"306\">Arrange your three variables in columns (X, Y, Z).<\/li>\n<li data-start=\"310\" data-end=\"343\">Insert an XY scatter chart.<\/li>\n<li data-start=\"347\" data-end=\"414\">Use marker size or color to represent the third variable (Z).<\/li>\n<li data-start=\"418\" data-end=\"479\">Add axis titles and labels to make the relationships clear.<\/li>\n<\/ol>\n<p data-start=\"481\" data-end=\"547\">This lets you see how all three variables interact in one chart.<\/p>\n<h3 class=\"JlqpRe\"><span class=\"JCzEY tNxQIb\"><span class=\"CSkcDe\">How to graph 3-variable functions?<\/span><\/span><\/h3>\n<ol>\n<li>Arrange your three variables in separate columns.<\/li>\n<li>Use a 3-variable scatter chart<\/li>\n<li>Map variables to axes or bubble size.<\/li>\n<li>Format axes, labels, and legend for easy interpretation.<\/li>\n<\/ol>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p data-start=\"628\" data-end=\"848\">Visualizing multiple variables in Excel doesn\u2019t have to be complicated. Using a 3-variable chart, you can analyze relationships across three metrics at once, making trends, correlations, and key patterns easier to see.<\/p>\n<p data-start=\"850\" data-end=\"1107\">While Excel\u2019s built-in charts can require extra formatting, using a tool like ChartExpo lets you create ready-made 3-variable charts quickly and efficiently. This add-in provides clear, easy-to-read visualizations without any coding or advanced setup.<\/p>\n<p data-start=\"1109\" data-end=\"1259\">By leveraging ChartExpo, you can turn your raw data into actionable insights in minutes, making multi-variable analysis simple, fast, and effective.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Learn how to create a Scatter Plot in Excel with 3 variables? Everything you need to create, format, and interpret a multi-variable chart.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/how-to-create-a-scatter-plot-in-excel-with-3-variables\"><\/a><\/p>","protected":false},"author":1,"featured_media":57585,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[746],"tags":[836],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>How to Create a Scatter Chart in Excel With 3-Variables? -<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/chartexpo.com\/blog\/how-to-create-a-scatter-plot-in-excel-with-3-variables\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"How to Create a Scatter Chart in Excel With 3-Variables? -\" \/>\r\n<meta name=\"twitter:description\" content=\"Learn how to create a Scatter Plot in Excel with 3 variables? Everything you need to create, format, and interpret a multi-variable chart.\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2026\/01\/scatter-plot-in-excel-feature.jpg\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutes\" \/>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Create a Scatter Chart in Excel With 3-Variables? -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/chartexpo.com\/blog\/how-to-create-a-scatter-plot-in-excel-with-3-variables","twitter_card":"summary_large_image","twitter_title":"How to Create a Scatter Chart in Excel With 3-Variables? -","twitter_description":"Learn how to create a Scatter Plot in Excel with 3 variables? Everything you need to create, format, and interpret a multi-variable chart.","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2026\/01\/scatter-plot-in-excel-feature.jpg","twitter_misc":{"Written by":"admin","Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/chartexpo.com\/blog\/how-to-create-a-scatter-plot-in-excel-with-3-variables","url":"https:\/\/chartexpo.com\/blog\/how-to-create-a-scatter-plot-in-excel-with-3-variables","name":"How to Create a Scatter Chart in Excel With 3-Variables? -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2025-11-18T03:32:06+00:00","dateModified":"2026-04-24T16:29:33+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/how-to-create-a-scatter-plot-in-excel-with-3-variables#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/how-to-create-a-scatter-plot-in-excel-with-3-variables"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/how-to-create-a-scatter-plot-in-excel-with-3-variables#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"How to Create a Scatter Chart in Excel With 3-Variables?"}]},{"@type":"WebSite","@id":"http:\/\/localhost\/blog\/#website","url":"http:\/\/localhost\/blog\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/localhost\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280","name":"admin","url":"https:\/\/chartexpo.com\/blog\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/19282"}],"collection":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/comments?post=19282"}],"version-history":[{"count":61,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/19282\/revisions"}],"predecessor-version":[{"id":61043,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/19282\/revisions\/61043"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/57585"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=19282"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=19282"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=19282"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}