{"id":47128,"date":"2025-02-11T13:30:53","date_gmt":"2025-02-11T08:30:53","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=47128"},"modified":"2026-02-20T23:58:19","modified_gmt":"2026-02-20T18:58:19","slug":"how-to-add-a-series-in-google-sheets","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/how-to-add-a-series-in-google-sheets","title":{"rendered":"How to Add a Series in Google Sheets?"},"content":{"rendered":"<p>How do I add a series in Google Sheets? This question often arises for those managing data. Whether you\u2019re tracking expenses or planning projects, adding a series saves time and boosts accuracy. Thus, mastering this feature is crucial.<\/p>\n<p>Consider this: businesses spend an average of 20% of their time on repetitive tasks. Automating series in Google Sheets can reduce that. A few clicks can generate lists, sequences, or patterns, making data management faster. Whether you\u2019re managing inventory or planning schedules, efficiency is key.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/how-to-add-a-series-in-google-sheets.jpg\" alt=\"How to Add a Series in Google Sheets\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTc0NCs=\" 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\/MTYrYmxvZyt4bCtjZXhwbytDRTc0NCs=\" 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\/MTYrYmxvZytwYitjZXhwbytQQklNQUM3NDQrTXVsdGlBeGlzTGluZUNoYXJ0Kw==\" 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>Adding a series isn\u2019t just about filling cells. It\u2019s about streamlining workflows and eliminating manual errors. Google Sheets, an alternative to Excel, can do it automatically, eliminating typing out dates or sequential numbers. This feature is invaluable for personal and professional tasks alike.<\/p>\n<p>Learning how to add a series in Google Sheets isn\u2019t tricky. It\u2019s an accessible skill with practical benefits. With this tool, anyone can turn data into something meaningful.<\/p>\n<p>Let\u2019s explore how this simple action can transform your work with spreadsheets.<\/p>\n<style>\n  .toc-container {<br \/>    max-width: 100%;<br \/>    font-family: Arial, sans-serif;<br \/>  }<\/p>\n<p>  .toc-list {<br \/>    list-style: none;<br \/>    padding: 0;<br \/>  }<\/p>\n<p>  .toc-list li {<br \/>    font-size: 16px;<br \/>    line-height: 1.5;<br \/>    word-wrap: break-word;<br \/>    overflow-wrap: break-word;<br \/>    max-width: 100%;<br \/>    margin-bottom: 8px;<br \/>  }<\/p>\n<p>  .toc-list li a {<br \/>    text-decoration: none;<br \/>    color: #0073aa;<br \/>  }<\/p>\n<\/style>\n<div class=\"toc-container\">\n<h3>Table of Contents:<\/h3>\n<ol class=\"toc-list\">\n<li><a href=\"#what-is-a-series-in-google-sheets\">What is a Series in Google Sheets?<\/a><\/li>\n<li><a href=\"#why-add-series-in-google-sheets\">Why Add Series in Google Sheets?<\/a><\/li>\n<li><a href=\"#how-to-fill-series-in-google-sheets\">How to Fill Series in Google Sheets?<\/a><\/li>\n<li><a href=\"#what-is-google-sheets-line-chart-multiple-series\">What is Google Sheets Line Chart Multiple Series?<\/a><\/li>\n<li><a href=\"#what-are-the-tips-for-using-google-sheets-add-series\">What are the Tips for Using Google Sheets Add Series?<\/a><\/li>\n<li><a href=\"#how-to-add-a-series-to-a-chart-in-google-sheets\">How to Add a Series to a Chart in Google Sheets?<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<\/div>\n<p>First&#8230;<\/p>\n<h2 id=\"what-is-a-series-in-google-sheets\">What is a Series in Google Sheets?<\/h2>\n<p><strong>Definition:<\/strong> A series in Google Sheets is a sequence of related data. It can include numbers, dates, or custom text patterns. For example, it might be \u201c1, 2, 3\u201d or \u201cMonday, Tuesday, Wednesday\u201d.<\/p>\n<p>Google Sheets can generate these automatically, saving time and ensuring accuracy. You define a starting value and a pattern, and then the tool completes the sequence for you. Series help track schedules, analyze trends or organize data efficiently. It\u2019s a simple yet powerful feature.<\/p>\n<h2 id=\"why-add-series-in-google-sheets\">Why Add Series in Google Sheets?<\/h2>\n<p>Adding a series in Google Sheets isn\u2019t just a convenience\u2014it\u2019s a smart way to make your data more robust. Whether organizing numbers or creating charts, a series brings clarity and precision. Let\u2019s explore why it\u2019s worth doing.<\/p>\n<ul>\n<li><strong>Compare multiple data sets<\/strong>: When you add a series, comparisons become effortless. Imagine tracking sales across months or team performance over quarters. A series organizes data neatly, letting you spot differences and similarities at a glance.<\/li>\n<li><strong>Analyze trends and patterns<\/strong>: Data speaks louder when trends are visible. Adding a series helps you connect the dots. From growth rates to seasonal patterns, a series makes identifying what\u2019s happening over time easy.<\/li>\n<li><strong>Combine chart types<\/strong>: A series can blend different chart types, such as bar and line charts. This allows you to present diverse data sets in one visual, which results in more impactful storytelling with your numbers.<\/li>\n<li><strong>Improve chart clarity<\/strong>: Adding a series, such as a <a href=\"https:\/\/chartexpo.com\/charts\/waterfall-chart\" target=\"_blank\" rel=\"noopener\">Waterfall chart in Google Sheets<\/a>, sharpens your visuals. It categorizes data clearly, ensuring viewers understand it quickly and your insights aren\u2019t lost in confusion.<\/li>\n<li><strong>Tailor visuals to your audience<\/strong>: Every audience is different. Adding a series lets you adjust visuals to match their needs. Whether it\u2019s executives or teammates, you can create data visualizations that resonate with them.<\/li>\n<li><strong>Simplify complex data<\/strong>: Complex data becomes manageable with a series. It breaks down large sets into understandable pieces. Start by cleaning your data with features like <a href=\"https:\/\/chartexpo.com\/blog\/remove-duplicates-in-google-sheets\" target=\"_blank\" rel=\"noopener\">removing duplicates in Google Sheets<\/a> to focus on the key points.<\/li>\n<\/ul>\n<h2 id=\"how-to-fill-series-in-google-sheets\">How to Fill Series in Google Sheets?<\/h2>\n<p>Google Sheets makes it super easy to create various series, such as numbers, dates, months, or even letters. Let&#8217;s explore the different ways you can do this, with some handy tips along the way!<\/p>\n<h3>Fill a Series of Numbers<\/h3>\n<p>To fill a series of numbers, you can use two methods:<\/p>\n<ul>\n<li>\n<h4>Using Drag<\/h4>\n<\/li>\n<\/ul>\n<ol>\n<li>Start by entering the first two numbers of your series in two adjacent cells (e.g., 1 and 2).<\/li>\n<\/ol>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/first-two-numbers-of-series-for-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/first-two-numbers-of-series-for-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"First Two Numbers of Series for Learning How to Add a Series in Google Sheets \" width=\"284\" \/><\/a><\/div>\n<ol start=\"2\">\n<li>Hover over the bottom-right corner until you see a tiny \u201c+\u201d icon. Click and drag down. The series will continue automatically.<\/li>\n<\/ol>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/click-and-drag-down-for-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/click-and-drag-down-for-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Click and Drag Down for Learning How to Add a Series in Google Sheets\" width=\"281\" \/><\/a><\/div>\n<ul>\n<li>\n<h4>Using Function<\/h4>\n<\/li>\n<\/ul>\n<ol>\n<li>Type a formula like =ROW(A1), press Enter<\/li>\n<\/ol>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/type-of-formula-for-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/type-of-formula-for-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Type of Formula for Learning How to Add a Series in Google Sheets\" width=\"370\" \/><\/a><\/div>\n<ol start=\"2\">\n<li>Hover over the bottom-right corner of the cell until the <strong>\u201c+\u201d<\/strong> appears, and drag down to extend the series.<\/li>\n<\/ol>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/bottom-right-corner-of-cell-until-for-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/bottom-right-corner-of-cell-until-for-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Bottom Right Corner of Cell Until + for Learning How to Add a Series in Google Sheets\" width=\"270\" \/><\/a><\/div>\n<h3>Fill a Series of Dates in Google Sheets:<\/h3>\n<ol>\n<li>Enter the first date in a cell.<\/li>\n<\/ol>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/enter-first-date-in-cell-for-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/enter-first-date-in-cell-for-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Enter First Date in Cell for Learning How to Add a Series in Google Sheets\" width=\"444\" \/><\/a><\/div>\n<ol start=\"2\">\n<li>Hover over the bottom-right corner of the cell until the <strong>\u201c+\u201d<\/strong> icon appears, and drag down to create a series of consecutive dates.<\/li>\n<\/ol>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/drag-down-to-create-series-of-consecutive-date-for-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/drag-down-to-create-series-of-consecutive-date-for-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Drag Down to Create Series of Consecutive Date for Learning How to Add a Series in Google Sheets\" width=\"450\" \/><\/a><\/div>\n<h3>Fill a Series of Months in Google Sheets:<\/h3>\n<ol>\n<li>Type the end dates for January, February, and March (e.g., 31-Jan, 28-Feb, 31-Mar).<\/li>\n<\/ol>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/type-end-dates-of-months-for-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/type-end-dates-of-months-for-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Type End Dates of Months for Learning How to Add a Series in Google Sheets\" width=\"284\" \/><\/a><\/div>\n<ol start=\"2\">\n<li>Select the three cells and drag the bottom-right corner down to continue the pattern.<\/li>\n<\/ol>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/select-three-cells-and-drag-bottom-right-corner-for-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/select-three-cells-and-drag-bottom-right-corner-for-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Select Three Cells and Drag Bottom Right Corner for Learning How to Add a Series in Google Sheets\" width=\"280\" \/><\/a><\/div>\n<h3>Fill a Series of Letters in Google Sheets:<\/h3>\n<ol>\n<li>To fill a series of letters:<\/li>\n<\/ol>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Type the first letter in a cell.<\/li>\n<li>Use the formula = CHAR(CODE(A2)+1) (replace \u201cA2\u201d with your cell reference).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/use-formula-char-for-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/use-formula-char-for-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Use Formula Char for Learning How to Add a Series in Google Sheets\" width=\"277\" \/><\/a><\/div>\n<ol start=\"2\">\n<li>Drag the formula down to create the series.<\/li>\n<\/ol>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/drag-formula-down-to-create-series-for-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/drag-formula-down-to-create-series-for-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Drag Formula Down to Create Series for Learning How to Add a Series in Google Sheets\" width=\"276\" \/><\/a><\/div>\n<h2 id=\"what-is-google-sheets-line-chart-multiple-series\">What is Google Sheets Line Chart Multiple Series?<\/h2>\n<p><strong>Definition:<\/strong> A Google Sheets line chart with multiple series displays trends for various datasets in one chart. Each series represents a set of data points connected by a line. It helps make <a href=\"https:\/\/chartexpo.com\/blog\/visual-analytics\" target=\"_blank\" rel=\"noopener\">visual analytics<\/a> easy. How? You can compare different variables over time or categories.<\/p>\n<p>For example, you can plot sales and profits in the same chart to analyze their relationship. Each series is colored for easy distinction. This helps visualize patterns and correlations across multiple data series simultaneously.<\/p>\n<h2 id=\"what-are-the-tips-for-using-google-sheets-add-series\">What are the Tips for Using Google Sheets Add Series?<\/h2>\n<p>Here\u2019s how to make your <a href=\"https:\/\/chartexpo.com\/tools\/google-sheets\" target=\"_blank\" rel=\"noopener\">Google Sheets charts<\/a> stand out, step by step:<\/p>\n<ul>\n<li><strong>Use clear labels<\/strong>: Give each series a name that\u2019s easy to understand. This will help your audience quickly grasp the data\u2019s meaning.<\/li>\n<li><strong>Select data wisely<\/strong>: Focus on the data that matters. Highlight only the rows or columns you want to showcase.<\/li>\n<li><strong>Combine smartly<\/strong>: Group related data together, but keep it organized. Avoid mixing unrelated information to keep your chart clean and insightful.<\/li>\n<li><strong>Customize your charts<\/strong>: Adjust color, fonts, and layout to make your chart visually appealing and consistent with your style.<\/li>\n<li><strong>Test for clarity<\/strong>: Always review your chart. Check if axes are aligned, labels are visible, and your data tells the right story.<\/li>\n<\/ul>\n<h2 id=\"how-to-add-a-series-to-a-chart-in-google-sheets\">How to Add a Series to a Chart in Google Sheets?<\/h2>\n<p data-pm-slice=\"0 0 []\">Data speaks louder when it\u2019s visual. That\u2019s the real power of data visualization in analysis. It turns raw numbers into clear insights. While Google Sheets handles basic charts well, it often struggles with advanced visuals like a <a href=\"https:\/\/chartexpo.com\/charts\/scatter-plot-chart\" target=\"_blank\" rel=\"noopener\">Scatter plot<\/a> that reveal deeper patterns and relationships.<\/p>\n<p data-pm-slice=\"0 0 []\">Enter ChartExpo. This powerful <a href=\"https:\/\/chartexpo.com\/blog\/google-sheets-extension\" target=\"_blank\" rel=\"noopener\">Google Sheets extension<\/a> levels up your data analysis with advanced, insightful charts. You can even create a <a href=\"https:\/\/chartexpo.com\/charts\/pareto-chart\" target=\"_blank\" rel=\"noopener\">Pareto chart in Google Sheets<\/a> to highlight key contributors. Ready to learn how to add a series in Sheets and make your visuals shine? Install ChartExpo in Google Sheets.<\/p>\n<p>Let\u2019s learn how to install ChartExpo in Google Sheets.<\/p>\n<ol>\n<li>To start using ChartExpo, download it directly from the Google Sheets program. To do this, select <strong>Extensions<\/strong>\u00a0from the top toolbar.<\/li>\n<li>A menu will appear. Click the\u00a0<strong>Get add-ons\u00a0<\/strong>option.<\/li>\n<li>Search for ChartExpo, and click on\u00a0<strong>Charts, Graphs &amp; Visualizations by ChartExpo\u00a0<\/strong>when it appears in the results.<\/li>\n<li>Click the\u00a0<strong>Install\u00a0<\/strong>button. You will have to confirm your Google account and accept some permissions.<\/li>\n<\/ol>\n<p>ChartExpo charts are available both in Google Sheets and Microsoft Excel. Please use the following CTAs to install the tool of your choice and create\u00a0beautiful visualizations\u00a0in a few clicks in your favorite tool.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTc0NCs=\" 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\/MTYrYmxvZyt4bCtjZXhwbytDRTc0NCs=\" 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\/MTYrYmxvZytwYitjZXhwbytQQklNQUM3NDQrTXVsdGlBeGlzTGluZUNoYXJ0Kw==\" 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>Using the data below, let&#8217;s practice <a href=\"https:\/\/chartexpo.com\/blog\/data-analytics-guide\" target=\"_blank\" rel=\"noopener\">data analytics<\/a> with ChartExpo for Google Sheets.<\/p>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"64\"><strong>Item<\/strong><\/td>\n<td width=\"200\"><strong>Cost of Goods Sold ($)<\/strong><\/td>\n<td width=\"178\"><strong>Average Inventory<\/strong><\/td>\n<td width=\"216\"><strong>Inventory Turnover Ratio<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"64\">Item 1<\/td>\n<td width=\"200\">5000<\/td>\n<td width=\"178\">90<\/td>\n<td width=\"216\">57.56<\/td>\n<\/tr>\n<tr>\n<td width=\"64\">Item 2<\/td>\n<td width=\"200\">7500<\/td>\n<td width=\"178\">135<\/td>\n<td width=\"216\">37.56<\/td>\n<\/tr>\n<tr>\n<td width=\"64\">Item 3<\/td>\n<td width=\"200\">10000<\/td>\n<td width=\"178\">190<\/td>\n<td width=\"216\">49.63<\/td>\n<\/tr>\n<tr>\n<td width=\"64\">Item 4<\/td>\n<td width=\"200\">4000<\/td>\n<td width=\"178\">70<\/td>\n<td width=\"216\">55.14<\/td>\n<\/tr>\n<tr>\n<td width=\"64\">Item 5<\/td>\n<td width=\"200\">6000<\/td>\n<td width=\"178\">110<\/td>\n<td width=\"216\">46.55<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>To get started with ChartExpo, install\u00a0<a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTc0NCs=\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">ChartExpo in Google Sheets<\/a>.<\/li>\n<li>Go to <strong>Extensions &gt; Charts, Graphs &amp; Visualizations by ChartExpo &gt; Open<\/strong>.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/06\/open-chartexpo-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/06\/open-chartexpo-in-google-sheets.jpg\" alt=\"open chartexpo in google sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>To access the charts library, click the <strong>Add new chart <\/strong>button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/06\/add-new-chart-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/06\/add-new-chart-in-google-sheets.jpg\" alt=\"add new chart in google sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Once <strong>ChartExpo<\/strong> is loaded. Click on \u201cMulti Axis Line Chart\u201d.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/search-multi-axis-line-chart-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/search-multi-axis-line-chart-in-google-sheets.jpg\" alt=\"search multi axis line chart in google sheets\" width=\"299\" \/><\/a><\/div>\n<ul>\n<li>First, insert the data table into the sheet. Then, select the Sheet name from the drop-down menu in the ChartExpo section.<\/li>\n<li>Select the <strong>metric<\/strong> column; metric is the numeric column in your data sheet.<\/li>\n<li>Select the <strong>dimensions<\/strong> columns; the dimension is the categorical column in your datasheet that contains text information.<\/li>\n<li>Click the <strong>Create chart<\/strong> button to complete the process.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/click-create-chart-after-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/click-create-chart-after-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Click Create Chart After Learning How to Add a Series in Google Sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Your tabular data will turn into a Multi Axis line Chart, as shown below.<\/li>\n<li>Click the <strong>Edit chart<\/strong> button to make custom changes.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/click-edit-chart-after-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/click-edit-chart-after-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Click Edit Chart After Learning How to Add a Series in Google Sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Change the &#8220;Data Representation&#8221; by clicking on the settings button as follows:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/change-data-representation-after-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/change-data-representation-after-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Change Data Representation After Learning How to Add a Series in Google Sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>To change the title of the chart, click the pencil icon next to the <strong>Chart Header<\/strong>.<\/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 the <strong>Show<\/strong> 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\/02\/add-chart-header-after-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/add-chart-header-after-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Add Chart Header After Learning How to Add a Series in Google Sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You can change the precision value into zero of \u201cAverage Inventory\u201d as follows:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/change-precision-value-into-zero-of-average-inventory-after-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/change-precision-value-into-zero-of-average-inventory-after-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Change Precision Value into Zero of Average Inventory After Learning How to Add a Series in Google Sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You can add the $ sign with \u201cCost of Goods Sold\u201d as follows:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/add-prefix-with-cost-of-goods-sold-after-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/add-prefix-with-cost-of-goods-sold-after-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Add Prefix with Cost of Goods Sold After Learning How to Add a Series in Google Sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Add the % sign with \u201cInventory Turnover Ratio\u201d as follows:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/add-postfix-with-inventory-turnover-ratio-after-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/add-postfix-with-inventory-turnover-ratio-after-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Add Postfix with Inventory Turnover Ratio After Learning How to Add a Series in Google Sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Change the Legend shape of \u201cCost of Goods Sold\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\/02\/change-legend-shape-of-cost-of-goods-sold-after-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/change-legend-shape-of-cost-of-goods-sold-after-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Change Legend Shape of Cost of Goods Sold After Learning How to Add a Series in Google Sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Change the Legend shape of \u201cAverage Inventory\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\/02\/change-legend-shape-of-average-inventory-after-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/change-legend-shape-of-average-inventory-after-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Change Legend Shape of Average Inventory After Learning How to Add a Series in Google Sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>After making all changes, click the <strong>\u201cSave\u201d <\/strong>button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/click-save-button-after-learning-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/click-save-button-after-learning-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Click Save Button After Learning How to Add a Series in Google Sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Your final chart will appear as below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/final-how-to-add-a-series-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/final-how-to-add-a-series-in-google-sheets.jpg\" alt=\"Final How to Add a Series in Google Sheets\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTc0NCs=\" 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\/MTYrYmxvZyt4bCtjZXhwbytDRTc0NCs=\" 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\/MTYrYmxvZytwYitjZXhwbytQQklNQUM3NDQrTXVsdGlBeGlzTGluZUNoYXJ0Kw==\" 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>Item 1 has a turnover ratio of 57.56, showing efficient inventory use.<\/li>\n<li>Item 2 trails at 37.56, indicating slower inventory turnover.<\/li>\n<li>Higher turnover ratios highlight better sales velocity against inventory levels.<\/li>\n<\/ul>\n<h3>Add a New Data Series to Google Sheets Charts for Better Insights:<\/h3>\n<ol>\n<li>Open your Google Sheets Application.<\/li>\n<li>Install <a href=\"https:\/\/www.youtube.com\/watch?v=MxnnkdYB49w\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">ChartExpo Add-in for Google Sheets<\/a> from Google Workspace Marketplace.<\/li>\n<li>Select the Multi Axis Line Chart from the list of charts.<\/li>\n<li>Fill in the necessary fields.<\/li>\n<li>Click on the Create Chart button.<\/li>\n<li>Customize your chart properties to add header, axis, legends, and other required information.<\/li>\n<li>Export your chart and share it with your audience.<\/li>\n<\/ol>\n<p>The following video will help you to create the <a href=\"https:\/\/chartexpo.com\/blog\/multi-axis-chart\" target=\"_blank\" rel=\"noopener\">Multi Axis Line Chart<\/a> in Google Sheets.<\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/sRj55j9-GGI?si=WF7YaYT3ClpEp-XY\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><\/iframe><\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTc0NCs=\" 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\/MTYrYmxvZyt4bCtjZXhwbytDRTc0NCs=\" 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\/MTYrYmxvZytwYitjZXhwbytQQklNQUM3NDQrTXVsdGlBeGlzTGluZUNoYXJ0Kw==\" 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>FAQs<\/h2>\n<h3>How do I insert a series in Google Sheets?<\/h3>\n<p>To insert a series in Google Sheets,<\/p>\n<ol>\n<li>Select your data range.<\/li>\n<li>Go to Insert &gt; Chart and choose a chart type.<\/li>\n<li>Click the chart, select Series, and add or edit data ranges as needed.<\/li>\n<li>Customize, then save.<\/li>\n<\/ol>\n<h3>How do I add multiple data series in Google Sheets?<\/h3>\n<p>To add multiple data series in Google Sheets;<\/p>\n<ol>\n<li>Select your data range. Go to Insert &gt; Chart.<\/li>\n<li>In the Setup tab, click Add Series and input additional ranges.<\/li>\n<li>Adjust chart type and customize as needed.<\/li>\n<li>Save your changes.<\/li>\n<\/ol>\n<h3>How do I format a data series in Google Sheets?<\/h3>\n<p>To format a data series in Google Sheets<\/p>\n<ol>\n<li>Click the chart and select Customize &gt; Series.<\/li>\n<li>Choose the series to adjust. Edit colors, line styles, or data points.<\/li>\n<li>Add trendlines or error bars if needed.<\/li>\n<li>Preview and save the changes.<\/li>\n<\/ol>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>Adding a series in Google Sheets is simple and effective. It helps organize and visualize data efficiently, and you can easily manage multiple data sets in one Chart. This functionality is especially useful when performing tasks like what-if analysis in Google Sheets. It allows you to compare trends and explore different scenarios with ease.<\/p>\n<p>Start by preparing your data properly. Make sure your series is in separate columns or rows. Proper formatting ensures accuracy and saves time when creating charts.<\/p>\n<p>Next, insert a chart to display your series and highlight the data range you want to include. Go to the Insert menu and select Chart. Google Sheets automatically adds the data to your Chart.<\/p>\n<p>Customize your Chart to suit your needs. The Chart Editor allows you to add or remove series. The Series tab will enable you to modify colors, labels, and styles, enhancing clarity and readability.<\/p>\n<p>Remember to keep your series meaningful. Avoid cluttering your Chart with too much data. Focus on the most relevant information. It will make your analysis more effective.<\/p>\n<p>Adding a series is a powerful feature in Google Sheets. It simplifies complex data and enhances decision-making.<\/p>\n<p>Do not hesitate.<\/p>\n<p>Install ChartExpo and start practicing adding series in Google Sheets. This skill will make your data analysis more insightful and impactful.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Learn how to add a series in Google Sheets for faster management. Automate repetitive entries and improve spreadsheet efficiency with our step-by-step guide.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/how-to-add-a-series-in-google-sheets\"><\/a><\/p>","protected":false},"author":1,"featured_media":47138,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[743],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>How to Add a Series in Google Sheets? -<\/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-add-a-series-in-google-sheets\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"How to Add a Series in Google Sheets? -\" \/>\r\n<meta name=\"twitter:description\" content=\"Learn how to add a series in Google Sheets for faster management. Automate repetitive entries and improve spreadsheet efficiency with our step-by-step guide.\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/feature-ce744-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":"How to Add a Series in Google Sheets? -","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-add-a-series-in-google-sheets","twitter_card":"summary_large_image","twitter_title":"How to Add a Series in Google Sheets? -","twitter_description":"Learn how to add a series in Google Sheets for faster management. Automate repetitive entries and improve spreadsheet efficiency with our step-by-step guide.","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/02\/feature-ce744-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\/how-to-add-a-series-in-google-sheets","url":"https:\/\/chartexpo.com\/blog\/how-to-add-a-series-in-google-sheets","name":"How to Add a Series in Google Sheets? -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2025-02-11T08:30:53+00:00","dateModified":"2026-02-20T18:58:19+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/how-to-add-a-series-in-google-sheets#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/how-to-add-a-series-in-google-sheets"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/how-to-add-a-series-in-google-sheets#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"How to Add a Series in Google Sheets?"}]},{"@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\/47128"}],"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=47128"}],"version-history":[{"count":8,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/47128\/revisions"}],"predecessor-version":[{"id":59343,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/47128\/revisions\/59343"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/47138"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=47128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=47128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=47128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}