{"id":46528,"date":"2025-01-24T22:07:24","date_gmt":"2025-01-24T17:07:24","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=46528"},"modified":"2026-02-04T15:46:58","modified_gmt":"2026-02-04T10:46:58","slug":"grouping-data-in-excel","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/grouping-data-in-excel","title":{"rendered":"Grouping Data in Excel for Clear and Precise Visuals"},"content":{"rendered":"<p>Why is grouping data in Excel so helpful? This powerful feature makes large datasets easier to manage and understand. It organizes data into clear sections, saving time and improving efficiency.<\/p>\n<p>Imagine a massive spreadsheet filled with sales, expenses, or project timelines. Scrolling endlessly to find relevant details can be frustrating. Grouping data in Excel solves this by allowing you to collapse or expand sections as needed. It helps you focus on what\u2019s important without distractions.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/grouping-data-in-excel.jpg\" alt=\"Grouping Data in Excel\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTczMis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTczMis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQklNQUM3MzIrTXVsdGlBeGlzTGluZUNoYXJ0Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<p>Time-saving tools are invaluable in today\u2019s fast-paced work environments. Research shows that professionals spend nearly 20% of their work hours searching for information. Grouping minimizes this effort, enabling you to access specific data sections quickly.<\/p>\n<p>Another key benefit is clarity. Grouped data reduces visual clutter, making spreadsheets easier to read and interpret. It is particularly useful for presentations or when sharing files with a team. It enhances collaboration by ensuring everyone can find what they need efficiently.<\/p>\n<p>Mastering grouping data in Excel gives you more control over your spreadsheets. It transforms overwhelming datasets into structured and actionable insights. Whether you\u2019re managing budgets or tracking performance, grouping makes it simpler.<\/p>\n<h3>Table of Contents:<\/h3>\n<ol>\n<li><a href=\"#why-is-it-helpful-to-group-data-in-excel\">Why is It Helpful to Group Data in Excel?<\/a><\/li>\n<li><a href=\"#how-to-group-rows-in-excel\">How to Group Rows in Excel?<\/a><\/li>\n<li><a href=\"#how-to-group-columns-in-excel\">How to Group Columns in Excel?<\/a><\/li>\n<li><a href=\"#how-to-analyze-grouped-data-in-excel\">How to Analyze Grouped Data in Excel?<\/a><\/li>\n<li><a href=\"#what-are-the-tips-for-grouping-data-in-excel\">What are the Tips for Grouping Data in Excel?<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<p>First&#8230;<\/p>\n<h2 id=\"why-is-it-helpful-to-group-data-in-excel\">Why is It Helpful to Group Data in Excel?<\/h2>\n<p>Grouping data in Excel is a game-changer for managing spreadsheets. It transforms scattered information into a clear and structured format. Whether working with large datasets or <a href=\"https:\/\/chartexpo.com\/blog\/how-to-create-a-report-in-excel\" target=\"_blank\" rel=\"noopener\">detailed reports<\/a>, grouping makes everything more manageable.<\/p>\n<ul>\n<li><strong>Enhanced organization:<\/strong> Grouping organizes data into logical sections. It helps you create a clean and structured layout for better understanding.<\/li>\n<li><strong>Improved readability:<\/strong> Collapsed groups reduce visual clutter. It makes spreadsheets easier to navigate and interpret at a glance.<\/li>\n<li><strong>Streamlined analysis:<\/strong> Focusing on grouped data simplifies analysis. You can quickly compare sections or highlight key trends.<\/li>\n<li><strong>Efficient data management:<\/strong> Grouping allows you to collapse irrelevant details and focus on important sections. This makes handling large datasets less overwhelming.<\/li>\n<li><strong>Time-saving feature:<\/strong> Grouped data lets you skip unnecessary scrolling. Finding specific sections becomes faster and more efficient.<\/li>\n<li><strong>Professional presentation:<\/strong> Well-grouped data looks polished and professional, making it ideal for reports, client presentations, or team discussions.<\/li>\n<li><strong>Collaborative benefits:<\/strong> Grouped spreadsheets make teamwork smoother. Colleagues can quickly locate and understand relevant sections.<\/li>\n<\/ul>\n<h2 id=\"how-to-group-rows-in-excel\">How to Group Rows in Excel?<\/h2>\n<p>Grouping rows in Excel is a smart way to manage and organize large datasets. It helps you focus on specific data sections while keeping everything tidy. Whether you&#8217;re analyzing yearly reports or project timelines, grouping rows can make your work faster and clearer.<\/p>\n<p>How?<\/p>\n<ol>\n<li>Start by adding your data to an Excel sheet. Ensure your data is well-organized for easy grouping.<\/li>\n<\/ol>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/add-data-to-excel-for-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/add-data-to-excel-for-doing-grouping-data-in-excel.jpg\" alt=\"Add Data to Excel for Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<ol start=\"2\">\n<li>Select the rows you want to group (e.g., Period Y-2021). Highlight them by clicking and dragging over the row numbers.<\/li>\n<\/ol>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/select-rows-you-want-to-group-for-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/select-rows-you-want-to-group-for-doing-grouping-data-in-excel.jpg\" alt=\"Select Rows You Want to Group for Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<ol start=\"3\">\n<li>Go to the <strong>Data<\/strong> tab in the toolbar. Click on <strong>Group<\/strong>, select <strong>Rows<\/strong>, and click <strong>OK<\/strong>. Your selected rows are now grouped.<\/li>\n<\/ol>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-group-select-rows-and-click-ok-for-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-group-select-rows-and-click-ok-for-doing-grouping-data-in-excel.jpg\" alt=\"Click Group, Select Rows and Click Ok for Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<ol start=\"4\">\n<li>Repeat the process for additional periods or categories (e.g., Period Y-2022 and Period Y-2023). Select the rows, group them, and confirm your selection.<\/li>\n<\/ol>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/repear-process-of-additional-periods-for-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/repear-process-of-additional-periods-for-doing-grouping-data-in-excel.jpg\" alt=\"Repear Process of Additional Periods for Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<ol start=\"5\">\n<li>Click the <strong>\u201c-\u201d<\/strong> sign next to the Group to hide grouped data. It collapses the rows, making your sheet cleaner and more focused.<\/li>\n<\/ol>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-sign-next-to-group-hide-grouped-data-for-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-sign-next-to-group-hide-grouped-data-for-doing-grouping-data-in-excel.jpg\" alt=\"Click \" width=\"650\" \/><\/a><\/div>\n<ol start=\"6\">\n<li>You can expand the data again. Click the <strong>\u201c+\u201d<\/strong> sign, and your grouped rows will reappear as they were.<\/li>\n<\/ol>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/expand-data-again-for-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/expand-data-again-for-doing-grouping-data-in-excel.jpg\" alt=\"Expand Data Again for Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<h2 id=\"how-to-group-columns-in-excel\">How to Group Columns in Excel?<\/h2>\n<p>Does your spreadsheet look like a tangled web of data? Grouping columns is the secret weapon to tame the chaos. It keeps things clean and helps you focus on what matters. Let\u2019s dive in!<\/p>\n<ol>\n<li><strong>Select the columns: <\/strong>Click and drag across the column headers you want to group. For example, to group columns B through D, just highlight them. Easy.<\/li>\n<li><strong>Open the grouping tool: <\/strong>Go to the <strong>Data <\/strong>tab on the ribbon. Look for the <strong>Outline <\/strong>group and click <strong>Group.<\/strong> Excel will ask, \u201cRows or Columns?\u201d Choose <strong>Columns<\/strong>, of course!<\/li>\n<li><strong>Confirm the grouping: <\/strong>You&#8217;ll see a line (or a bracket) above the selected columns.<\/li>\n<li><strong>Collapse or expand the group: <\/strong>Here\u2019s the fun part! Notice the tiny plus (+) or minus (-) button near your bracket. Click it to collapse or expand the Group. Collapse to declutter, expand to dive back in.<\/li>\n<\/ol>\n<h2 id=\"how-to-analyze-grouped-data-in-excel\">How to Analyze Grouped Data in Excel?<\/h2>\n<p>Ever stared at a cluttered Excel sheet and thought, \u201cThere has to be a better way\u201d? Grouping data in Excel and analyzing it is a lifesaver for keeping things organized. However, Excel has its limits in <a href=\"https:\/\/chartexpo.com\/blog\/data-visualization-guide\" target=\"_blank\" rel=\"noopener\">data visualization<\/a>. Sure, it can handle the basics, but translating raw numbers into stunning, insightful visuals? Not so much.<\/p>\n<p data-pm-slice=\"0 0 []\">That\u2019s where ChartExpo steps in. It\u2019s a powerful tool that transforms your data into eye-catching, interactive charts, including <a href=\"https:\/\/chartexpo.com\/charts\/scatter-plot-chart\" target=\"_blank\" rel=\"noopener\">Scatter plot<\/a> visuals\u2014making data analysis faster, smarter, and more impactful.<\/p>\n<p>Let\u2019s see why grouping data matters and how ChartExpo can improve your <a href=\"https:\/\/chartexpo.com\/tools\/excel\" target=\"_blank\" rel=\"noopener\">Excel charts<\/a> and overall Excel game!<\/p>\n<p>But first\u2026<\/p>\n<p>Here are some top <a href=\"https:\/\/chartexpo.com\/blog\/types-of-charts-and-graphs\" target=\"_blank\" rel=\"noopener\">charts and graphs<\/a> created in Excel using ChartExpo:<\/p>\n<h3>Sankey Chart<\/h3>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/sankey-chart-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/sankey-chart-after-doing-grouping-data-in-excel.jpg\" alt=\"Sankey Chart After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<h3>Comparison Bar Chart<\/h3>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/comparison-bar-chart-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/comparison-bar-chart-after-doing-grouping-data-in-excel.jpg\" alt=\"Comparison Bar Chart After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<h3>Gauge Chart<\/h3>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/gauge-chart-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/gauge-chart-after-doing-grouping-data-in-excel.jpg\" alt=\"Gauge Chart After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<h3>Progress Circle Chart<\/h3>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/progress-circle-chart-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/progress-circle-chart-after-doing-grouping-data-in-excel.jpg\" alt=\"Progress Circle Chart After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<h3>Multi Axis Line Chart<\/h3>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/multi-axis-line-chart-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/multi-axis-line-chart-after-doing-grouping-data-in-excel.jpg\" alt=\"Multi Axis Line Chart After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<p>Let\u2019s learn how to install ChartExpo in Excel.<\/p>\n<ol>\n<li>Open your Excel application.<\/li>\n<li>Open the worksheet and click the \u201c<strong>Insert<\/strong>\u201d menu.<\/li>\n<li>You\u2019ll see the \u201c<strong>My Apps<\/strong>\u201d option.<\/li>\n<li>In the Office Add-ins window, click \u201c<strong>Store<\/strong>\u201d and search for ChartExpo on my Apps Store.<\/li>\n<li>Click the \u201c<strong>Add<\/strong>\u201d button to install ChartExpo in your Excel.<\/li>\n<\/ol>\n<p>ChartExpo charts, including a <a href=\"https:\/\/chartexpo.com\/charts\/waterfall-chart\" target=\"_blank\" rel=\"noopener\">Waterfall chart<\/a>, are available in both Google Sheets and Microsoft Excel. Use the following CTAs to install the tool of your choice and create beautiful visualizations with a few clicks in your favorite tool.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTczMis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTczMis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQklNQUM3MzIrTXVsdGlBeGlzTGluZUNoYXJ0Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<h3>Example<\/h3>\n<p>Let\u2019s analyze and interpret this sample data in Excel using ChartExpo, making <a href=\"https:\/\/chartexpo.com\/blog\/analyzing-and-interpreting-data\" target=\"_blank\" rel=\"noopener\">analyzing and interpreting data<\/a> easier and more insightful.<\/p>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"67\"><strong>Period<\/strong><\/td>\n<td width=\"220\"><strong>Cash Flow (in thousand USD)<\/strong><\/td>\n<td width=\"115\"><strong>Discount Rate<\/strong><\/td>\n<td width=\"136\"><strong>Discount Factor<\/strong><\/td>\n<td width=\"197\"><strong>Discounted Cash Flow<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"67\">Y-2019<\/td>\n<td width=\"220\">145<\/td>\n<td width=\"115\">6.77<\/td>\n<td width=\"136\">0.288<\/td>\n<td width=\"197\">42<\/td>\n<\/tr>\n<tr>\n<td width=\"67\">Y-2020<\/td>\n<td width=\"220\">138<\/td>\n<td width=\"115\">6.77<\/td>\n<td width=\"136\">0.27<\/td>\n<td width=\"197\">37<\/td>\n<\/tr>\n<tr>\n<td width=\"67\">Y-2021<\/td>\n<td width=\"220\">131<\/td>\n<td width=\"115\">6.77<\/td>\n<td width=\"136\">0.253<\/td>\n<td width=\"197\">33<\/td>\n<\/tr>\n<tr>\n<td width=\"67\">Y-2022<\/td>\n<td width=\"220\">102<\/td>\n<td width=\"115\">6.77<\/td>\n<td width=\"136\">0.237<\/td>\n<td width=\"197\">24<\/td>\n<\/tr>\n<tr>\n<td width=\"67\">Y-2023<\/td>\n<td width=\"220\">112<\/td>\n<td width=\"115\">6.77<\/td>\n<td width=\"136\">0.171<\/td>\n<td width=\"197\">19<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>To get started with ChartExpo, install\u00a0<a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTczMis=\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">ChartExpo in Excel<\/a>.<\/li>\n<li>Now Click on <strong>My Apps<\/strong> from the <strong>INSERT<\/strong> menu.<\/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=\"alignnone size-full wp-image-4345\" 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>Choose <strong>ChartExpo<\/strong> from <strong>My Apps<\/strong>, then click <strong>Insert<\/strong>.<\/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=\"alignnone size-full wp-image-4345\" 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 it loads, scroll through the charts list to locate and choose the \u201c<strong>Multi Axis Line Chart<\/strong>\u201d.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/search-multi-axis-line-chart-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/search-multi-axis-line-chart-in-excel.jpg\" alt=\"search multi axis line chart in excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You will see a Multi Axis Line Chart on the screen.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/see-multi-axis-line-chart-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/see-multi-axis-line-chart-after-doing-grouping-data-in-excel.jpg\" alt=\"See Multi Axis Line Chart After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click the \u201c<strong>Create Chart From Selection<\/strong>\u201d button after selecting the data from the sheet, as shown.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-create-chart-from-selection-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-create-chart-from-selection-after-doing-grouping-data-in-excel.jpg\" alt=\"Click Create Chart From Selection After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>ChartExpo will generate the visualization below for you.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/initial-visual-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/initial-visual-after-doing-grouping-data-in-excel.jpg\" alt=\"Initial Visual After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click on Settings and change the <strong>\u201cData Representation\u201d<\/strong> as follows.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/change-data-representation-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/change-data-representation-after-doing-grouping-data-in-excel.jpg\" alt=\"Change Data Representation After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>If you want to add anything to the chart, click the <strong>Edit Chart <\/strong>button:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-edit-chart-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-edit-chart-after-doing-grouping-data-in-excel.jpg\" alt=\"Click Edit Chart After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click the pencil icon next to the<strong> Chart Header<\/strong> to change the title.<\/li>\n<li>It will open the properties dialog. Under the <strong>Text<\/strong> section, you can add a heading in <strong>Line 1<\/strong> and enable <strong>Show<\/strong>.<\/li>\n<li>Give the appropriate title of your chart and click the <strong>Apply<\/strong> button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/add-chart-header-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/add-chart-header-after-doing-grouping-data-in-excel.jpg\" alt=\"Add Chart Header After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You can add the dollar sign with discounted cash flow value as follows:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/add-prefix-with-discounted-cash-flow-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/add-prefix-with-discounted-cash-flow-after-doing-grouping-data-in-excel.jpg\" alt=\"Add Prefix With Discounted Cash Flow After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You can add the percentage sign with \u201cDiscounted Rate\u201d values as follows:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/add-postfix-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/add-postfix-after-doing-grouping-data-in-excel.jpg\" alt=\"Add Postfix After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You can add the dollar sign with \u201cCash Flow\u201d values as follows:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/add-prefix-with-cash-flow-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/add-prefix-with-cash-flow-after-doing-grouping-data-in-excel.jpg\" alt=\"Add Prefix With Cash Flow After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You can enable the Legend show button as follows:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/enable-legend-show-button-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/enable-legend-show-button-after-doing-grouping-data-in-excel.jpg\" alt=\"Enable Legend Show Button After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Change the Legend shape of \u201cDiscounted Cash Flow\u201d to Column and click the \u201cApply\u201d button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/change-legend-shape-of-discounted-cash-flow-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/change-legend-shape-of-discounted-cash-flow-after-doing-grouping-data-in-excel.jpg\" alt=\"Change Legend Shape of Discounted Cash Flow After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Change the Legend shape of \u201cDiscount Rate\u201d into a Line and Circle and click the \u201cApply\u201d button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/change-legend-shape-of-discount-rate-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/change-legend-shape-of-discount-rate-after-doing-grouping-data-in-excel.jpg\" alt=\"Change Legend Shape of Discount Rate After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Change the Legend shape of \u201cDiscount Factor\u201d into a Line and Circle and click the \u201cApply\u201d button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/change-legend-shape-of-discount-factor-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/change-legend-shape-of-discount-factor-after-doing-grouping-data-in-excel.jpg\" alt=\"Change Legend Shape of Discount Factor After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click the \u201cSave Changes\u201d button to persist the changes made to the chart.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-save-changes-after-doing-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-save-changes-after-doing-grouping-data-in-excel.jpg\" alt=\"Click Save Changes After Doing Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Your final Multi Axis Line Chart will look like the one below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/final-grouping-data-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/final-grouping-data-in-excel.jpg\" alt=\"Final Grouping Data in Excel\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTczMis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTczMis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQklNQUM3MzIrTXVsdGlBeGlzTGluZUNoYXJ0Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<h4>Insights<\/h4>\n<ul>\n<li>Cash flows declined from 2019 to 2021.<\/li>\n<li>A slight recovery occurred in 2022-2023.<\/li>\n<li>Discounted cash flows decreased steadily, driven by a 6.77% discount rate.<\/li>\n<li>The decline reflects the erosion of value over time.<\/li>\n<\/ul>\n<h3>Leveraging Grouping Data in Microsoft Excel to Create Insightful Charts:<\/h3>\n<ol>\n<li>Open your Excel Application.<\/li>\n<li>Install <a href=\"https:\/\/www.youtube.com\/watch?v=cWKBUrdIW88\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">ChartExpo Add-in for Excel<\/a> from Microsoft AppSource to create <a href=\"https:\/\/chartexpo.com\/blog\/interactive-storytelling\" target=\"_blank\" rel=\"noopener\">interactive visualizations<\/a>.<\/li>\n<li>Select the Multi Axis Line Chart from the list of charts.<\/li>\n<li>Select your data<\/li>\n<li>Click on the \u201cCreate Chart from Selection\u201d button.<\/li>\n<li>Customize your chart properties to add header, axis, legends, and other required information.<\/li>\n<\/ol>\n<p>The following video will help you to create a Multi Axis Line Chart in Microsoft Excel.<\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/NBylfzh0u9M?si=sXxL-NE0BxjaLuXl\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTczMis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTczMis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQklNQUM3MzIrTXVsdGlBeGlzTGluZUNoYXJ0Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<h2 id=\"what-are-the-tips-for-grouping-data-in-excel\">What are the Tips for Grouping Data in Excel?<\/h2>\n<p>Grouping data in Excel is like tidying up a cluttered room\u2014smart planning makes it easier. Here\u2019s how to organize efficiently:<\/p>\n<ul>\n<li><strong>Start with a clear plan: <\/strong>Decide what to group and why. Planning ensures your data structure makes sense from the start.<\/li>\n<li><strong>Summarize for insights: <\/strong>Pair groups with subtotals or summaries to highlight key points. It makes it easy to <a href=\"https:\/\/chartexpo.com\/blog\/trend-analysis\" target=\"_blank\" rel=\"noopener\">spot trends<\/a> without sifting through rows of data.<\/li>\n<li><strong>Leverage quick shortcuts: <\/strong>Use Excel\u2019s shortcuts like <strong>Alt + Shift + \u2192<\/strong> to group fast. Or try Auto Outline for a one-click organization boost.<\/li>\n<li><strong>Think layers with nested groups: <\/strong>Dive deep into details using nested levels (e.g., months within quarters). Collapse or expand as needed to switch between big-picture and granular views.<\/li>\n<li><strong>Label clearly for tidy sheets: <\/strong>Add meaningful headings to avoid confusion. A well-labelled group saves time when revisiting or <a href=\"https:\/\/chartexpo.com\/blog\/how-to-share-excel-workbook\" target=\"_blank\" rel=\"noopener\">sharing your data<\/a>.<\/li>\n<\/ul>\n<h2>FAQs<\/h2>\n<h3>How do I group data in Excel based on range?<\/h3>\n<p>To group data by range in Excel:<\/p>\n<ol>\n<li>Sort your data.<\/li>\n<li>Select it and click <strong>PivotTable<\/strong> (Insert tab).<\/li>\n<li>Drag the data to <strong>Rows<\/strong> and values to <strong>Columns\/Values<\/strong>.<\/li>\n<li>Use &#8220;Group Selection&#8221; for ranges.<\/li>\n<\/ol>\n<h3>What is the purpose of grouping data in Excel?<\/h3>\n<p>D organizes information for better analysis. It simplifies large datasets by categorizing values into ranges or intervals. It aids in spotting trends, summarizing data, creating reports, and improving readability, especially in pivot tables or charts.<\/p>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>Grouping data in Excel is a simple yet powerful feature. It organizes information into manageable sections, making it easier to handle. It boosts efficiency and reduces frustration when working with large spreadsheets.<\/p>\n<p>One of the biggest advantages is better readability. Collapsing groups removes clutter and allows you to focus on what\u2019s important. This makes it faster to find and analyze specific data.<\/p>\n<p>Grouping also saves time. It eliminates unnecessary scrolling by letting you access key details in seconds. It&#8217;s useful, especially for time-sensitive tasks.<\/p>\n<p>Grouping data enhances collaboration, too. Grouped data makes spreadsheets clearer for teams. Everyone can easily navigate and understand the content, improving teamwork.<\/p>\n<p>For presentations, grouping adds a professional touch. It ensures your data looks organized and polished, leaving a strong impression.<\/p>\n<p>In summary, grouping is a valuable tool for anyone using Excel. It streamlines workflows, simplifies analysis, and supports better decision-making.<\/p>\n<p>Do not hesitate.<\/p>\n<p>Start grouping data in Excel and install ChartExpo to make your work smarter and more effective.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Grouping Data in Excel allows for better analysis by structuring information into clear sections, saving time, reducing clutter, &#038; helping focus on key data points.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/grouping-data-in-excel\"><\/a><\/p>","protected":false},"author":1,"featured_media":46540,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[746],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Grouping Data in Excel for Clear and Precise Visuals -<\/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\/grouping-data-in-excel\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"Grouping Data in Excel for Clear and Precise Visuals -\" \/>\r\n<meta name=\"twitter:description\" content=\"Grouping Data in Excel allows for better analysis by structuring information into clear sections, saving time, reducing clutter, &amp; helping focus on key data points.\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/feature-ce732-200x200-1.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=\"17 minutes\" \/>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Grouping Data in Excel for Clear and Precise Visuals -","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\/grouping-data-in-excel","twitter_card":"summary_large_image","twitter_title":"Grouping Data in Excel for Clear and Precise Visuals -","twitter_description":"Grouping Data in Excel allows for better analysis by structuring information into clear sections, saving time, reducing clutter, & helping focus on key data points.","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/feature-ce732-200x200-1.jpg","twitter_misc":{"Written by":"admin","Est. reading time":"17 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/chartexpo.com\/blog\/grouping-data-in-excel","url":"https:\/\/chartexpo.com\/blog\/grouping-data-in-excel","name":"Grouping Data in Excel for Clear and Precise Visuals -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2025-01-24T17:07:24+00:00","dateModified":"2026-02-04T10:46:58+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/grouping-data-in-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/grouping-data-in-excel"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/grouping-data-in-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"Grouping Data in Excel for Clear and Precise Visuals"}]},{"@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\/46528"}],"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=46528"}],"version-history":[{"count":10,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/46528\/revisions"}],"predecessor-version":[{"id":58664,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/46528\/revisions\/58664"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/46540"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=46528"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=46528"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=46528"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}