{"id":17484,"date":"2022-04-08T06:50:24","date_gmt":"2022-04-08T06:50:24","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=17484"},"modified":"2026-04-09T21:50:05","modified_gmt":"2026-04-09T16:50:05","slug":"how-to-make-a-graph-from-a-table","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/how-to-make-a-graph-from-a-table","title":{"rendered":"How to Make a Graph from a Table: A Step-by-Step Guide"},"content":{"rendered":"<p>You&#8217;ll agree when we say storing and organizing data in tables is convenient. You can easily infer quick insights from tabular data . But you can only go far with tables in data analysis.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/how-to-make-a-graph-from-a-table-main.jpg\" alt=\"how-to-make-a-graph-from-a-table\" width=\"650\" \/><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbyswMDUr\" 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\/04\/how-to-make-a-graph-from-a-table-in-google-sheets-3.jpg\" alt=\"\" width=\"308\" height=\"143\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbyswMDUr\" 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\/04\/how-to-make-a-graph-from-a-table-in-microsoft-excel-3.jpg\" alt=\"\" width=\"308\" height=\"143\" \/><\/a><\/div>\n<p><em>Why?<\/em><\/p>\n<p>Picture this: you have a gigantic data set that occupies tens of thousands of rows and columns.. How can you extract reliable insights from such huge tables efficiently?<\/p>\n<p>Assuming persistence is one of your values, how long can it take you to extract meaningful insights? <em>You guessed right.<\/em> It could take you hours, if not days.<\/p>\n<p><em>This is where graphs come in.<\/em><\/p>\n<p><strong>Graphs can help you distill critical insights from noise and outliers. <\/strong>Remember, a huge chunk of any data is always noise. Essentially, you stand to <em>save a ton of time and effort<\/em> when dealing with bulky and complex data.<\/p>\n<p>In this blog, you&#8217;ll learn how to make a graph from a table using easy-to-follow and straightforward steps.<\/p>\n<h3>Table of Content:<\/h3>\n<ol>\n<li><a href=\"#graph-from-tables-with-excel\">How To Make a Graph From a Table in 6 Easy Steps?<\/a>\n<ol>\n<li><a href=\"#step-1-open-the-worksheet\">Step 1: Open the Worksheet, click Insert for My Apps<\/a><\/li>\n<li><a href=\"#step-2-click-insert-to-start\">Step 2: Select ChartExpo, and click Insert to start.<\/a><\/li>\n<li><a href=\"#step-3-view-the-chart-list\">Step 3: Once loaded, view the chart list.<\/a><\/li>\n<li><a href=\"#step-4-select-progress-chart\">Step 4: Look for &#8220;Progress Chart&#8221; in the list.<\/a><\/li>\n<li><a href=\"#step-5-create-a-chart-from-the-selection\">Step 5: Create a Chart from the Selection.<\/a><\/li>\n<li><a href=\"#step-6-view-the-final-chart\">Step 6: View the final chart.<\/a><\/li>\n<\/ol>\n<\/li>\n<li><a href=\"#generate-a-graph-from-tables-importance\">Why Generate a Graph from Tables?<\/a><\/li>\n<li><a href=\"#best-tool-for-graph-from-tables\">Best Tool For Creating A Graph from Table<\/a><\/li>\n<li><a href=\"#disadvantages-of-tables\">Disadvantages of Tables<\/a><\/li>\n<li><a href=\"#make-graph-from-tables-faqs\">How to Make a Graph from a Table FAQs<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<h2 id=\"graph-from-tables-with-excel\">How To Make a Graph From a Table in 6 Easy Steps?<\/h2>\n<p>We&#8217;ll use a <a href=\"https:\/\/chartexpo.com\/blog\/progress-bar-in-excel\" target=\"_blank\" rel=\"noopener noreferrer\">Progress Chart<\/a> to visualize the table 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=\"179\"><strong>Products<\/strong><\/td>\n<td width=\"189\"><strong>Previous Sales<\/strong><\/td>\n<td width=\"217\"><strong>Current Sales<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"179\">Bread<\/td>\n<td width=\"189\">141<\/td>\n<td width=\"217\">176<\/td>\n<\/tr>\n<tr>\n<td width=\"179\">Butter<\/td>\n<td width=\"189\">181<\/td>\n<td width=\"217\">166<\/td>\n<\/tr>\n<tr>\n<td width=\"179\">Jelly<\/td>\n<td width=\"189\">148<\/td>\n<td width=\"217\">128<\/td>\n<\/tr>\n<tr>\n<td width=\"179\">Pasta<\/td>\n<td width=\"189\">121<\/td>\n<td width=\"217\">172<\/td>\n<\/tr>\n<tr>\n<td width=\"179\">Cheese<\/td>\n<td width=\"189\">146<\/td>\n<td width=\"217\">158<\/td>\n<\/tr>\n<tr>\n<td width=\"179\">Ice Cream<\/td>\n<td width=\"189\">149<\/td>\n<td width=\"217\">192<\/td>\n<\/tr>\n<tr>\n<td width=\"179\">Soda<\/td>\n<td width=\"189\">100<\/td>\n<td width=\"217\">152<\/td>\n<\/tr>\n<tr>\n<td width=\"179\">Ketchup<\/td>\n<td width=\"189\">124<\/td>\n<td width=\"217\">191<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>To install ChartExpo into your Excel, click this link.<\/p>\n<h3 id=\"step-1-open-the-worksheet\">Step 1: Open the Worksheet, click Insert for My Apps<\/h3>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/06\/open-chartexpo-in-excel.jpg\" alt=\"insert chartexpo in excel\" width=\"650\" \/><\/div>\n<h3 id=\"step-2-click-insert-to-start\">Step 2: Select ChartExpo, and click Insert to start.<\/h3>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/06\/open-chartexpo-in-excel.jpg\" alt=\"open chartexpo in excel\" width=\"650\" \/><\/div>\n<h3 id=\"step-3-view-the-chart-list\">Step 3: Once loaded, view the chart list.<\/h3>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/06\/list-of-charts-in-excel.jpg\" alt=\"list of charts in excel\" width=\"650\" \/><\/div>\n<h3 id=\"step-4-select-progress-chart\">Step 4: Look for &#8220;Progress Chart&#8221; in the list.<\/h3>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/07\/progress-chart-in-excel.jpg\" alt=\"progress chart in excel\" width=\"650\" \/><\/div>\n<h3 id=\"step-5-create-a-chart-from-the-selection\">Step 5: Create a Chart from the Selection.<\/h3>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/07\/create-progress-chart-in-excel-070.jpg\" alt=\"create progress chart in excel 070\" width=\"650\" \/><\/div>\n<h3 id=\"step-6-view-the-final-chart\">Step 6: View the final chart.<\/h3>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/07\/financial-charts-and-graphs-in-excel.jpg\" alt=\"financial charts and graphs in excel\" width=\"650\" \/><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbyswMDUr\" 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\/04\/how-to-make-a-graph-from-a-table-in-google-sheets-3.jpg\" alt=\"\" width=\"308\" height=\"143\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbyswMDUr\" 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\/04\/how-to-make-a-graph-from-a-table-in-microsoft-excel-3.jpg\" alt=\"\" width=\"308\" height=\"143\" \/><\/a><\/div>\n<h2 id=\"generate-a-graph-from-tables-importance\">Why Generate a Graph from Tables?<\/h2>\n<ul>\n<li>\n<h3>Graphs and Charts are Easier to Understand<\/h3>\n<\/li>\n<\/ul>\n<p>Data visualization designs allow you to interpret vast quantities of data clearly and cohesively. Besides, you can easily extract insights, draw conclusions, and see perspectives.<\/p>\n<p>Using different <a href=\"https:\/\/chartexpo.com\/blog\/types-of-charts-and-graphs\" target=\"_blank\" rel=\"noopener noreferrer\">business charts and graphs<\/a>, you can keep track of crucial and strategic metrics of your business or workplace. Furthermore, you can easily spot anomalies, such as outliers, which can easily misinform your decisions.<\/p>\n<p>You can use graphs to uncover risks and opportunities surrounding your business or workplace.<\/p>\n<ul>\n<li>\n<h3>Spot Patterns and Trends<\/h3>\n<\/li>\n<\/ul>\n<p>Graphs can help you spot emerging trends and respond in real-time.<\/p>\n<p>Patterns and trends make more sense when graphically represented.<\/p>\n<p>Certain relationships in your data may be apparent, primarily if you use tables. But to uncover hidden insights, you need visual representations like <a href=\"https:\/\/chartexpo.com\/blog\/dot-plot\" target=\"_blank\" rel=\"noopener noreferrer\">dot plots<\/a>, which are beyond the capacity of tables.<\/p>\n<ul>\n<li>\n<h3>Data Storytelling<\/h3>\n<\/li>\n<\/ul>\n<p>Tables, especially long ones, are not recommended if you want your data story to be compelling. Data visualization experts use graphs, charts, and maps to help their target audiences understand key takeaways without struggle.<\/p>\n<p>Let&#8217;s agree on this: You&#8217;ll be using visual diagrams, such as graphs from tables and <a href=\"https:\/\/chartexpo.com\/blog\/funnel-chart\" target=\"_blank\" rel=\"noopener noreferrer\">storytelling with funnel charts<\/a>, to create compelling data stories for your audience (and readers).<\/p>\n<p><em>Take a look at the tabular data below.<\/em><\/p>\n<p><em>How to make a graph from a table like the one below?<\/em><\/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>Year<\/strong><\/td>\n<td width=\"258\"><strong>Topic<\/strong><\/td>\n<td width=\"93\"><strong>Positive<\/strong><\/td>\n<td width=\"111\"><strong>Negative<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2019<\/td>\n<td width=\"258\">Quality of food<\/td>\n<td width=\"93\">11<\/td>\n<td width=\"111\">12<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2019<\/td>\n<td width=\"258\">Ease of ordering<\/td>\n<td width=\"93\">29<\/td>\n<td width=\"111\">50<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2019<\/td>\n<td width=\"258\">Services<\/td>\n<td width=\"93\">20<\/td>\n<td width=\"111\">33<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2019<\/td>\n<td width=\"258\">Parking<\/td>\n<td width=\"93\">2<\/td>\n<td width=\"111\">4<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2019<\/td>\n<td width=\"258\">Cleanness<\/td>\n<td width=\"93\">55<\/td>\n<td width=\"111\">12<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2019<\/td>\n<td width=\"258\">Ease of reading the menu<\/td>\n<td width=\"93\">12<\/td>\n<td width=\"111\">7<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2019<\/td>\n<td width=\"258\">wait time to be seated<\/td>\n<td width=\"93\">16<\/td>\n<td width=\"111\">11<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2019<\/td>\n<td width=\"258\">Seating space in the waiting area<\/td>\n<td width=\"93\">8<\/td>\n<td width=\"111\">8<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2019<\/td>\n<td width=\"258\">menu and drink choices<\/td>\n<td width=\"93\">4<\/td>\n<td width=\"111\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2019<\/td>\n<td width=\"258\">Attitude of Waiter<\/td>\n<td width=\"93\">3<\/td>\n<td width=\"111\">5<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2019<\/td>\n<td width=\"258\">Payment method<\/td>\n<td width=\"93\">12<\/td>\n<td width=\"111\">15<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2020<\/td>\n<td width=\"258\">Quality of food<\/td>\n<td width=\"93\">15<\/td>\n<td width=\"111\">12<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2020<\/td>\n<td width=\"258\">Ease of ordering<\/td>\n<td width=\"93\">51<\/td>\n<td width=\"111\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2020<\/td>\n<td width=\"258\">Services<\/td>\n<td width=\"93\">28<\/td>\n<td width=\"111\">12<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2020<\/td>\n<td width=\"258\">Parking<\/td>\n<td width=\"93\">4<\/td>\n<td width=\"111\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2020<\/td>\n<td width=\"258\">Cleanness<\/td>\n<td width=\"93\">45<\/td>\n<td width=\"111\">11<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2020<\/td>\n<td width=\"258\">Ease of reading the menu<\/td>\n<td width=\"93\">12<\/td>\n<td width=\"111\">8<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2020<\/td>\n<td width=\"258\">wait time to be seated<\/td>\n<td width=\"93\">16<\/td>\n<td width=\"111\">18<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2020<\/td>\n<td width=\"258\">Seating space in the waiting area<\/td>\n<td width=\"93\">13<\/td>\n<td width=\"111\">18<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2020<\/td>\n<td width=\"258\">menu and drink choices<\/td>\n<td width=\"93\">4<\/td>\n<td width=\"111\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2020<\/td>\n<td width=\"258\">Attitude of Waiter<\/td>\n<td width=\"93\">3<\/td>\n<td width=\"111\">8<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2020<\/td>\n<td width=\"258\">Payment method<\/td>\n<td width=\"93\">17<\/td>\n<td width=\"111\">16<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2021<\/td>\n<td width=\"258\">Quality of food<\/td>\n<td width=\"93\">18<\/td>\n<td width=\"111\">12<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2021<\/td>\n<td width=\"258\">Ease of ordering<\/td>\n<td width=\"93\">59<\/td>\n<td width=\"111\">20<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2021<\/td>\n<td width=\"258\">Services<\/td>\n<td width=\"93\">30<\/td>\n<td width=\"111\">10<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2021<\/td>\n<td width=\"258\">Parking<\/td>\n<td width=\"93\">2<\/td>\n<td width=\"111\">0<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2021<\/td>\n<td width=\"258\">Cleanness<\/td>\n<td width=\"93\">55<\/td>\n<td width=\"111\">7<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2021<\/td>\n<td width=\"258\">Ease of reading the menu<\/td>\n<td width=\"93\">18<\/td>\n<td width=\"111\">10<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2021<\/td>\n<td width=\"258\">wait time to be seated<\/td>\n<td width=\"93\">22<\/td>\n<td width=\"111\">14<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2021<\/td>\n<td width=\"258\">Seating space in the waiting area<\/td>\n<td width=\"93\">13<\/td>\n<td width=\"111\">16<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2021<\/td>\n<td width=\"258\">menu and drink choices<\/td>\n<td width=\"93\">4<\/td>\n<td width=\"111\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2021<\/td>\n<td width=\"258\">Attitude of Waiter<\/td>\n<td width=\"93\">2<\/td>\n<td width=\"111\">4<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">2021<\/td>\n<td width=\"258\">Payment method<\/td>\n<td width=\"93\">13<\/td>\n<td width=\"111\">14<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Let&#8217;s extract insights from the table above using a graph.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/how-to-make-a-graph-from-a-table-example-restaurant-survey.jpg\" alt=\"how-to-make-a-graph-from-a-table-example-restaurant-survey\" width=\"504\" \/><\/div>\n<p>The above data visualization design (<a href=\"https:\/\/chartexpo.com\/charts\/comparison-bar-chart\" target=\"_blank\" rel=\"noopener noreferrer\">comparison bar chart<\/a>) makes things a little easier. You can easily infer the key issues customers raised during the survey.<\/p>\n<p>In the last three financial years (2019-21), the two most significant issues that customers have raised concerning the restaurant brand are:<\/p>\n<ul>\n<li>Ease of ordering<\/li>\n<li>Cleanliness<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbyswMDUr\" 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\/04\/how-to-make-a-graph-from-a-table-in-google-sheets-1.jpg\" alt=\"\" width=\"308\" height=\"143\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbyswMDUr\" 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\/04\/how-to-make-a-graph-from-a-table-in-microsoft-excel-1.jpg\" alt=\"\" width=\"308\" height=\"143\" \/><\/a><\/div>\n<h2 id=\"best-tool-for-graph-from-tables\">Best Tool For Creating A Graph from a Table<\/h2>\n<p>ChartExpo is a trusted tool that thousands of professionals worldwide use to create insightful and easy-to-understand graphs from tables. As a reliable <a href=\"https:\/\/chartexpo.com\/blog\/chart-maker\" target=\"_blank\" rel=\"noopener noreferrer\">chart-maker tool<\/a>, it helps users transform data into clear visualizations. Besides, it comes as an add-on that you can easily install to get the most from your data.<\/p>\n<p>ChartExpo comes loaded with many advanced data visualization designs, such as the Sankey Diagram, <a href=\"https:\/\/chartexpo.com\/charts\/pareto-chart\" target=\"_blank\" rel=\"noopener noreferrer\">Pareto Chart<\/a>, Comparison Charts, Control Charts, <a href=\"https:\/\/chartexpo.com\/blog\/area-chart\" target=\"_blank\" rel=\"noopener\">Area chart<\/a> design, <a href=\"https:\/\/chartexpo.com\/blog\/x-and-y-axis-chart\" target=\"_blank\" rel=\"noopener\">x and y-axis chart<\/a>, and Funnel Charts, to ensure you never struggle to generate a graph from the table.<\/p>\n<h2 id=\"disadvantages-of-tables\">Disadvantages of Tables<\/h2>\n<p>Tables are best suited for storing and organizing raw data. For anything beyond the aforementioned, you should opt for graphs.<\/p>\n<p><em>Yes, you read that right.<\/em><\/p>\n<p>Data in tables can be displayed as text, using words and numbers. Besides, tables make it easy to compare pairs of related values (e.g., quarterly sales in a given financial year).<\/p>\n<p>Remember, you cannot use tables exclusively to display quantitative information. For more complex data relationships, such as when you have multiple sets of values with a direct relationship, a <a href=\"https:\/\/chartexpo.com\/blog\/sunburst-chart\" target=\"_blank\" rel=\"noopener noreferrer\">Sunburst Chart<\/a> can be an effective alternative to a table for organizing and visualizing the data.<\/p>\n<p>For example, some professionals often use tables to display meeting agendas with particular times, topics, locations, and speakers.<\/p>\n<p><strong><em>So when should you use graphs instead of tables?<\/em><\/strong><\/p>\n<p>When the data grows beyond the reasonable scope, you need to explore data visualization to display insights easily.<\/p>\n<p>Graphs are essentially a visual display of data along two axes (x and y-axes). There&#8217;s scientific reasoning behind why data stories with visual designs such as a <a href=\"https:\/\/chartexpo.com\/blog\/mekko-charts\" target=\"_blank\" rel=\"noopener noreferrer\">Mekko graph<\/a> are more compelling than those without one. Did you know our brains can interpret visual content 60,000 times faster than words and numbers?<\/p>\n<p>Use interactive data visualization designs in your data stories to arouse the interest of the target audience. Graphs and charts, like <a href=\"https:\/\/chartexpo.com\/blog\/how-to-make-a-line-graph-with-multiple-lines-in-google-sheets\" target=\"_blank\" rel=\"noopener noreferrer\">line graphs with multiple lines<\/a>, can reveal insights from bulky data in a way that&#8217;s easy to process.<\/p>\n<p>Data visualization is a quick, easy way to convey insights into raw data. You can use visual designs, such as <a href=\"https:\/\/chartexpo.com\/charts\/bar-charts\" target=\"_blank\" rel=\"noopener noreferrer\">bar charts<\/a>, graphs, and maps, to achieve the following:<\/p>\n<ul>\n<li>Identify areas that need attention or improvement in your business or workplace.<\/li>\n<li>Clarify factors that influence the behavior of your target market.<\/li>\n<li>Forecast sales, revenue, losses, etc.<\/li>\n<li><a href=\"https:\/\/chartexpo.com\/blog\/trend-analysis-in-excel\" target=\"_blank\" rel=\"noopener noreferrer\">Trend Analysis<\/a> to take action quickly before your competitors to meet the customer needs.<\/li>\n<\/ul>\n<p>When debating table versus graph, do the following:<\/p>\n<ul>\n<li>Ask how you&#8217;ll use the data.<\/li>\n<li>Consider your target audience.<\/li>\n<li>Decide the best way to map out your information.<\/li>\n<li>Think about the utility of your visual.<\/li>\n<\/ul>\n<h2 id=\"make-graph-from-tables-faqs\">How to Plot a Graph from a Table FAQs<\/h2>\n<h3 class=\"JlqpRe\"><span class=\"JCzEY tNxQIb\"><span class=\"CSkcDe\">How do I combine a table and graph in Excel?<\/span><\/span><\/h3>\n<ol>\n<li><strong>Create the Table:<\/strong> Input your data into an Excel table.<\/li>\n<li><strong>Insert a Chart:<\/strong> Select the data, then go to the &#8220;Insert&#8221; tab and choose a chart type.<\/li>\n<li><strong>Position the Chart:<\/strong> Place the chart next to or overlay it on the table.<\/li>\n<li><strong>Adjust Formatting:<\/strong> Modify the chart and table formatting for a clear, cohesive look.<\/li>\n<li><strong>Finalize:<\/strong> Review and make any final adjustments to ensure the table and graph complement each other.<\/li>\n<\/ol>\n<h3 class=\"JlqpRe\"><span class=\"JCzEY tNxQIb\"><span class=\"CSkcDe\">How to create a bar chart in Excel from a table?<\/span><\/span><\/h3>\n<div class=\"p8Jhnd\">\n<div class=\"aj35ze\">\n<ol>\n<li><strong>Select Data:<\/strong> Highlight the table data you want to include in the bar chart.<\/li>\n<li><strong>Insert Bar Chart:<\/strong> Go to the &#8220;Insert&#8221; tab, click on &#8220;Bar Chart,&#8221; and choose a chart style.<\/li>\n<li><strong>Customize Chart:<\/strong> Adjust the chart title, axis labels, and colors as needed.<\/li>\n<li><strong>Position Chart:<\/strong> Place the chart within your worksheet for easy viewing.<\/li>\n<li><strong>Finalize:<\/strong> Review the chart for accuracy and formatting, then save your work.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>Tables are convenient for storing and organizing raw data. However, when the complexity and size of data start growing: you need to explore other more innovative options, such as data visualization.<\/p>\n<p><em>This is where graphs come in.<\/em><\/p>\n<p>Well-constructed visualization designs can complement your data stories. You can use them to uncover hidden patterns, trends, and outliers in your data.<\/p>\n<p>Freemium tools come with pretty basic data visualization designs, which require a lot of editing. And this means you stand to spend a lot of time.<\/p>\n<p>We recommend our readers use the ChartExpo add-on to supercharge their favorite spreadsheet app (Google Sheets).<\/p>\n<p><em>Why?<\/em><\/p>\n<p>ChartExpo comes pre-loaded with over 50 graphs that are <em>easy to read and interpret.<\/em> Besides, it has an ultra-friendly user interface (UI), which means you don&#8217;t need coding or programming skills to visualize your data.<\/p>\n<p>Sign up today to save the time you can take to generate a graph from tables.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Click to learn how to make a graph from a table using easy-to-follow steps. Discover the best tool to create a useful data visualization from a table.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/how-to-make-a-graph-from-a-table\"><\/a><\/p>","protected":false},"author":1,"featured_media":30786,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[739],"tags":[1120],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>How to Make a Graph from a Table: A Step-by-Step Guide -<\/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-make-a-graph-from-a-table\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"How to Make a Graph from a Table: A Step-by-Step Guide -\" \/>\r\n<meta name=\"twitter:description\" content=\"Click to learn how to make a graph from a table using easy-to-follow steps. Discover the best tool to create a useful data visualization from a table.\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/how-to-make-a-graph-from-a-table-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=\"10 minutes\" \/>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Make a Graph from a Table: A Step-by-Step Guide -","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-make-a-graph-from-a-table","twitter_card":"summary_large_image","twitter_title":"How to Make a Graph from a Table: A Step-by-Step Guide -","twitter_description":"Click to learn how to make a graph from a table using easy-to-follow steps. Discover the best tool to create a useful data visualization from a table.","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/how-to-make-a-graph-from-a-table-feature.jpg","twitter_misc":{"Written by":"admin","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/chartexpo.com\/blog\/how-to-make-a-graph-from-a-table","url":"https:\/\/chartexpo.com\/blog\/how-to-make-a-graph-from-a-table","name":"How to Make a Graph from a Table: A Step-by-Step Guide -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2022-04-08T06:50:24+00:00","dateModified":"2026-04-09T16:50:05+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/how-to-make-a-graph-from-a-table#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/how-to-make-a-graph-from-a-table"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/how-to-make-a-graph-from-a-table#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"How to Make a Graph from a Table: A Step-by-Step Guide"}]},{"@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\/17484"}],"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=17484"}],"version-history":[{"count":63,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/17484\/revisions"}],"predecessor-version":[{"id":60631,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/17484\/revisions\/60631"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/30786"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=17484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=17484"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=17484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}