{"id":1039,"date":"2008-08-13T10:54:29","date_gmt":"2008-08-13T10:54:29","guid":{"rendered":"https:\/\/www.amitbhawani.com\/blog\/?p=1039"},"modified":"2009-08-21T06:15:05","modified_gmt":"2009-08-21T06:15:05","slug":"types-graphs-microsoft-office","status":"publish","type":"post","link":"https:\/\/www.amitbhawani.com\/blog\/types-graphs-microsoft-office\/","title":{"rendered":"14 Types of Graphs created using Microsoft Office"},"content":{"rendered":"<p>Question : I wanted to have a breif idea of different types of charts we can create using Microsoft Office.<\/p>\n<p>Here are a total of 14 Different Types of Charts you can create :<\/p>\n<p><strong>Area Charts<\/strong> : These Charts use connected points to map each series and the space between the series if filled in with a color or pattern.<\/p>\n<p><strong>Bar Charts<\/strong> : These Charts are typically used for showing performance against benchmarks. Each data point is marked by a horizontal bar that extends to the left or right of the baseline.<\/p>\n<p><strong>Column Charts<\/strong> : Similar to bar charts but use vertical bars instead of horizontal bars and are typically used for showing rainfall, sales figures etc.<\/p>\n<p><strong>Cylinder Charts, Cone Charts and Pyramid Charts<\/strong> : Use the shapes from which they take their names to present data in a more interesting ways than bar and column charts.<\/p>\n<p><strong>Line Charts <\/strong>: These are good for showing changes in data series over time. A typical use would be for charting temperature or changes in price. The data points in each data series are connected by a line.<\/p>\n<p><strong>Pie Charts<\/strong> : A Single data series is divided in the pic slices showing the relative contribution of the various data points. Pie Charts are used for showing market shares, survey results etc.<\/p>\n<p><strong>Doughnut Charts<\/strong> : These are mutunt pie charts that show more than one data series. One single doughnut chart is used to represent two pir charts to show changes in market share over two years.<\/p>\n<p style=\"text-align: center;\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/i0.wp.com\/www.amitbhawani.com\/Images\/M\/ms-office-graph-charts.PNG\" alt=\"Ms Office Charts Graphs\" \/><\/p>\n<p><strong>Radar Charts<\/strong> : Represents data points as symbols around a central point, with the value of each data point represented by its symbol&#8217;s distance from the scanner. Radar charts can be confusing when misused.<\/p>\n<p><strong>Surface Charts<\/strong> : Used to find the best combinations between two sets of data.<br \/>\n<strong><br \/>\nXY or Scatter Charts<\/strong> : Typically used for charting the result of surveys or experiment, plot a series of data pairs against XY coordinate. The result typically resemble a line chart that&#8217;s lost its lines.<\/p>\n<p><strong>Stock Charts<\/strong> : They are mutunt scatter and column charts designed for tracking the movement, close chart to track the stock high,low, and closing prices for each day.<\/p>\n<p><strong>Bubble Charts<\/strong> : They are mutant scatter charts that use bubble of different sizes to show one data series, whose relationship to the other two data series is indicated by placement against the axes. They are harder to read.<br \/>\n<strong><br \/>\nCombination Charts<\/strong> : This adds a line chart to a column chart or bar chart, plotting one or more data series as lines and others as bars or columns. Combination charts are used to demonstrate two trends at once.<br \/>\n<strong><br \/>\n3-D Charts<\/strong> : Include 3-D area charts, 3-D bar Charts, 3-D Column Charts, 3-D Line Charts, 3-D Pie Charts and 3-D Surface Charts.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Question : I wanted to have a breif idea of different types of charts we can create using Microsoft Office. Here are a total of 14 Different Types of Charts you can create : Area Charts : These Charts use connected points to map each series and the space between the series if filled in [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":18476,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[223],"tags":[],"class_list":{"0":"post-1039","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-microsoft","8":"entry"},"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/ms-office-graph-charts.png?fit=390%2C245&ssl=1","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":4399,"url":"https:\/\/www.amitbhawani.com\/blog\/bar-chart-graph-tool\/","url_meta":{"origin":1039,"position":0},"title":"Online Bar Chart Graph Generator","author":"Amit Bhawani","date":"May 20, 2009","format":false,"excerpt":"Creating Online Graphs is really easy now with tools from websites like barchart.be for generating Barchart graphs. I need barchart graphs to create different comparision reports or else showing my website traffic stats on my advertising page and if i directly use the text format of all the stats ,\u2026","rel":"","context":"In &quot;Web Tools&quot;","block_context":{"text":"Web Tools","link":"https:\/\/www.amitbhawani.com\/blog\/category\/web-tools\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/Amit-Bhawani-Traffic-Stats.png?fit=400%2C250&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":13791,"url":"https:\/\/www.amitbhawani.com\/blog\/monitor-sql-queries\/","url_meta":{"origin":1039,"position":1},"title":"Monitor SQL Queries with Real Time Server Charts","author":"Amit Bhawani","date":"September 4, 2010","format":false,"excerpt":"Once your website traffic increases one of the biggest concern would be the server load because if the hosting servers are down you would be loosing a lot of revenue and visitors. Hence you will have to always Monitor the SQL database and make sure that the queries are controlled\u2026","rel":"","context":"In &quot;Software Reviews&quot;","block_context":{"text":"Software Reviews","link":"https:\/\/www.amitbhawani.com\/blog\/category\/software\/"},"img":{"alt_text":"Database Management","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/Database-Management-150x150.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":11997,"url":"https:\/\/www.amitbhawani.com\/blog\/ios4-features-compatibility-iphone-ipod-touch\/","url_meta":{"origin":1039,"position":2},"title":"Find iOS 4 Features Compatibility for iPhone 3G 3GS &#038; iPod Touch","author":"Jyoti Bhawani","date":"June 23, 2010","format":false,"excerpt":"Many iPhone owners have just updated their devices to the latest iOS 4 without even running a compatibility test to know if the features would work or not. This means that there are many features like the Home screen folders, Unified Inbox and threading for Mail, Internet tethering which would\u2026","rel":"","context":"In &quot;Apple&quot;","block_context":{"text":"Apple","link":"https:\/\/www.amitbhawani.com\/blog\/category\/apple\/"},"img":{"alt_text":"iOS4 Feature Checklist","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/06\/iOS4-feature-checklist.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3447,"url":"https:\/\/www.amitbhawani.com\/blog\/check-internet-speed-test\/","url_meta":{"origin":1039,"position":3},"title":"Check Internet Speed Test to measure Internet connection bandwidth","author":"Amit Bhawani","date":"February 26, 2009","format":false,"excerpt":"If you are looking for checking your broadband speed to make sure that your ISP is not cheating with you and over billing you with high speed charges and offering you a very low internet speed, then its time you can measure the download and upload speed using a downloadable\u2026","rel":"","context":"In &quot;Tips &amp; Tweaks&quot;","block_context":{"text":"Tips &amp; Tweaks","link":"https:\/\/www.amitbhawani.com\/blog\/category\/tips-tweaks\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/Test-Internet-Connection-Speed.png?fit=543%2C437&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/Test-Internet-Connection-Speed.png?fit=543%2C437&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/Test-Internet-Connection-Speed.png?fit=543%2C437&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":14886,"url":"https:\/\/www.amitbhawani.com\/blog\/desktop-based-stock-trading-software\/","url_meta":{"origin":1039,"position":4},"title":"TradeTiger &#8211; Stock Trading Software for Buying &#038; Selling Shares","author":"Amit Bhawani","date":"September 28, 2010","format":false,"excerpt":"We have been suggesting everyone of you with different Online Stock Trading tips along with the ways to Make money by buying and selling shares. Also the Bombay Stock Exchange now supports Stock Trading via Mobile giving you access to your portfolio anytime anywhere. Before you start get into trading\u2026","rel":"","context":"In &quot;Business&quot;","block_context":{"text":"Business","link":"https:\/\/www.amitbhawani.com\/blog\/category\/business\/"},"img":{"alt_text":"ShareKhan TradeTiger","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/ShareKhan-TradeTiger.png?fit=504%2C266&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":13164,"url":"https:\/\/www.amitbhawani.com\/blog\/dell-laptops-vs-apple-macbook-price-features-comparison\/","url_meta":{"origin":1039,"position":5},"title":"Dell Laptops Vs Apple MacBook Price &#038; Features Comparison","author":"Amit Bhawani","date":"August 8, 2010","format":false,"excerpt":"Apple has always been comparing their products with the Windows based Computers by publishing different videos on their official website which is actually something we would have never expected at-least from a company which prefers selling Quality Products. If Apple is serious about their business they should never criticize their\u2026","rel":"","context":"In &quot;Laptops Guide&quot;","block_context":{"text":"Laptops Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/laptops\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/dell-apple-comparison-chart.jpg?fit=638%2C623&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/dell-apple-comparison-chart.jpg?fit=638%2C623&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/dell-apple-comparison-chart.jpg?fit=638%2C623&ssl=1&resize=525%2C300 1.5x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/posts\/1039","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/comments?post=1039"}],"version-history":[{"count":0,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/posts\/1039\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/media\/18476"}],"wp:attachment":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/media?parent=1039"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/categories?post=1039"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/tags?post=1039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}