{"id":15119,"date":"2020-03-04T20:03:16","date_gmt":"2020-03-04T20:03:16","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/wp\/?p=15119"},"modified":"2022-08-07T04:38:04","modified_gmt":"2022-08-07T04:38:04","slug":"corona-virus-statistics-graphs-using-web-query-in-excel","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/","title":{"rendered":"Corona Virus Map Graphs – Using Web Query in Excel"},"content":{"rendered":"[et_pb_section fb_built=”1″ _builder_version=”4.16″ global_colors_info=”{}” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]\r\n

This post is about how to extract Corona Virus Affected Statistics from
https:\/\/www.worldometers.info\/coronavirus\/<\/a> in Excel using WebQuery and create your own Graph, metrics etc. Once you receive the data from Internet through WebQuery it is up to you how you want to do the visualization of that data.<\/p>\r\n\r\n\r\n\r\n

Also this article talks about – How to Refresh any WebQuery using Excel VBA so that you can simply create a Refresh button to load the latest data from the internet.<\/p>\r\n\r\n\r\n\r\n

This article also talks about how to apply data filter on the Extracted data table via WebQuery using Excel VBA. <\/p>\r\n\r\n\r\n\r\n

So let’s begin with !! First and foremost, Don’t panic <\/strong>by seeing the news\/ rumors and Myths spreading around. Although you got to be careful with your basic hygiene like washing your hands at least for 20 seconds, using Hand Sanitizers, etc. Try not to travel to those places where more people are affected. You can read more about this Virus and guidelines you can read FAQs about Corona on WHO website<\/a> and also your local Health Advisory offices and websites. Please take care of you and your loved ones. Stay calm stay safe.<\/strong><\/p>\r\n\r\n\r\n\r\n

Coming back to the article, this article will cover following topics:<\/p>\r\n\r\n\r\n\r\n

  1. How to Fetch Data from any website in Excel using WebQuery<\/li>
  2. How to Refresh or Run the WebQeury every time by Clicking on a Button<\/li>
  3. How to Filter a data Table by a selected value from a ListBox<\/li>
  4. Download FREE Excel Workbook with Corona Virus Statistics extracted from Web<\/a><\/li><\/ol>\r\n\r\n\r\n\r\n

    Let’s start then, to create a Simple WebQuery, in your Excel WorkBook go to Data -> From Web as show in the below picture<\/p>\r\n\r\n\r\n

    \"From

    From Web – To Fetch Data from Internet<\/p><\/div>\r\n\r\n\r\n

    Click on From Web and provide the Web URL, where you want to fetch the data from as shown in the below Picture<\/p>\r\n\r\n\r\n\"Web\r\n\r\n\r\n

    Once you click on Excel will try to connect to the URL and parse the whole HTML documents available on that URL and categorize it based on simple HTML document, Table etc.<\/p>\r\n\r\n\r\n

    \"Data

    Data Table extracted from the Website URL provided above<\/p><\/div>\r\n\r\n\r\n

    You can also apply different type of Transformations on the Data you receive from web in a tabular format. As shown in the below picture you will see so many – mostly self explanatory – options available to apply transformation on the data received. <\/p>\r\n\r\n\r\n\r\n

    For example, <\/strong> for the Corona Virus Statistics table, I wanted to remove the last row which is a Total Row on the website because I wanted to calculate the default Total from the Excel Table. If I do not remove the last row then the total applied on the table will be doubled.<\/p>\r\n\r\n\r\n

    \"Extracted

    Extracted Data Table – Transformation Logic<\/p><\/div>\r\n\r\n\r\n

    Once transformation is done [of course an optional step], table will be extracted in a normal Excel Table like below shown in the picture<\/p>\r\n\r\n\r\n

    \"Data

    Data Table for Graph<\/p><\/div>\r\n\r\n\r\n

    Every time you want to refresh this data from the website, you need to click on the refresh button highlighted below on the right hand side <\/p>\r\n\r\n\r\n

    \"Existing

    Existing Queries in Excel<\/p><\/div>\r\n\r\n\r\n

    Excel VBA code to refresh Web data<\/h2>\r\n\r\n\r\n\r\n

    Basically to refresh the data from a web connection can be done following way<\/p>\r\n\r\n\r\n\r\n

    Refreshing a specific Connection by Connection Name<\/h4>\r\n\r\n\r\n\r\n
    Sub cbRefreshResult()\r\n    Dim wb As Workbook\r\n    Set wb = ThisWorkbook\r\n    wb.Connections(\"Query - Table 0\").Refresh\r\nEnd Sub<\/code><\/pre>\r\n\r\n\r\n\r\n
    Refreshing all the connections in a Workbook<\/h4>\r\n\r\n\r\n\r\n
    Sub cbRefreshResults()\r\n    Dim wb As Workbook\r\n    Set wb = ThisWorkbook\r\n    Dim con As WorkbookConnection\r\n    For Each con In wb.Connections\r\n        con.Refresh\r\n    Next con\r\nEnd Sub<\/code><\/pre>\r\n\r\n\r\n\r\n
    While refreshing you will notice that, your program will end immediately even though the data is still being refreshed. Basically by default Refresh of the data is done in background. In case you want to display a message to the user only when actually refresh is complete, then you need to disable the background processing.<\/p>\r\n\r\n\r\n\r\n
    How to disable background Query running<\/h4>\r\n\r\n\r\n\r\n
    You can disable it simply by executing this statement before executing the refresh method  – con.OLEDBConnection.BackgroundQuery = False<\/p>\r\n\r\n\r\n\r\n
    Sub cbRefreshResults()\r\n    Dim wb As Workbook\r\n    Set wb = ThisWorkbook\r\n    Dim con As WorkbookConnection\r\n\r\n    For Each con In wb.Connections\r\n        ' get the original value\r\n        bBackground = con.OLEDBConnection.BackgroundQuery\r\n        'Temporarily disable background-refresh\r\n        con.OLEDBConnection.BackgroundQuery = False\r\n        'Refresh this connection\r\n        con.Refresh\r\n        'Set background-refresh value back to original value\r\n        con.OLEDBConnection.BackgroundQuery = bBackground\r\n    Next con\r\n    MsgBox \"Data Is Refreshed from following site \" & vbNewLine & vbNewLine & \"https:\/\/www.worldometers.info\/coronavirus\/\" & vbNewLine & \" Time : \" & VBA.Now\r\nEnd Sub<\/code><\/pre>\r\n\r\n\r\n\r\n
    In the above code, Data Refreshed message will be shown on the screen only when data is loaded completely.<\/p>\r\n\r\n\r\n\r\n
    Thank you so much for reading this article. If you like this article, feel free to share it with your friends, colleagues, everyone… Stay Safe and healthy and keep learning<\/strong><\/p>\r\n[\/et_pb_text][et_pb_cta _builder_version=”4.17.6″ _module_preset=”a50a16dd-d05f-4ea2-acab-1468d2e4010e” title=”Download Excel Live Graph for Corona Virus Affected Statistics” button_text=”Download Now” button_url=”\/excel\/wp-content\/downloads\/CoronaVirusGraph.xlsm” hover_enabled=”0″ sticky_enabled=”0″]DOWNLOAD – EXCEL WITH CORONAVIRUS MAP GRAPH AND WEB QUERY.\n\nYou can refresh the graph with the latest data with one click. Enjoy and stay safe.\n\n
    \"Corona
    Corona Demographics Graph in Excel VBA<\/p><\/div>\n\n[\/et_pb_cta][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/span>","protected":false},"excerpt":{"rendered":"
    This post is about how to extract Corona Virus Affected Statistics from https:\/\/www.worldometers.info\/coronavirus\/ in Excel using WebQuery and create your own Graph, metrics etc. Once you receive the data from Internet through WebQuery it is up to you how you want to do the visualization of that data. Also this article talks about – How […]<\/p>\n","protected":false},"author":45,"featured_media":242578,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"\r\n
    This post is about how to extract Corona Virus Affected Statistics from  
    https:\/\/www.worldometers.info\/coronavirus\/<\/a>  in Excel using WebQuery and create your own Graph, metrics etc. Once you receive the data from Internet through WebQuery it is up to you how you want to do the visualization of that data.<\/p>\r\n\r\n\r\n\r\n
    Also this article talks about - How to Refresh any WebQuery using Excel VBA so that you can simply create a Refresh button to load the latest data from the internet.<\/p>\r\n\r\n\r\n\r\n
    This article also talks about how to apply data filter on the Extracted data table via WebQuery using Excel VBA. <\/p>\r\n\r\n\r\n\r\n
    So let's begin with !! First and foremost, Don't panic <\/strong>by seeing the news\/ rumors and Myths spreading around. Although you got to be careful with your basic hygiene like washing your hands at least for 20 seconds, using Hand Sanitizers, etc. Try not to travel to those places where more people are affected. You can read more about this Virus and guidelines you can read FAQs about Corona on WHO website<\/a> and also your local Health Advisory offices and websites. Please take care of you and your loved ones. Stay calm stay safe.<\/strong><\/p>\r\n\r\n\r\n\r\n
    Coming back to the article, this article will cover following topics:<\/p>\r\n\r\n\r\n\r\n
    1. How to Fetch Data from any website in Excel using WebQuery<\/li>
    2. How to Refresh or Run the WebQeury every time by Clicking on a Button<\/li>
    3. How to Filter a data Table by a selected value from a ListBox<\/li>
    4. Download FREE Excel Workbook with Corona Virus Statistics extracted from Web<\/a><\/li><\/ol>\r\n\r\n\r\n\r\n
      Let's start then, to create a Simple WebQuery, in your Excel WorkBook go to Data -> From Web as show in the below picture<\/p>\r\n\r\n\r\n[caption id=\"attachment_15122\" align=\"aligncenter\" width=\"571\"]\"From From Web - To Fetch Data from Internet[\/caption]\r\n\r\n\r\n
      Click on From Web and provide the Web URL, where you want to fetch the data from as shown in the below Picture<\/p>\r\n\r\n\r\n\"Web\r\n\r\n\r\n
      Once you click on Excel will try to connect to the URL and parse the whole HTML documents available on that URL and categorize it based on simple HTML document, Table etc.<\/p>\r\n\r\n\r\n[caption id=\"attachment_242598\" align=\"aligncenter\" width=\"873\"]\"Data Data Table extracted from the Website URL provided above[\/caption]\r\n\r\n\r\n
      You can also apply different type of Transformations on the Data you receive from web in a tabular format. As shown in the below picture you will see so many - mostly self explanatory - options available to apply transformation on the data received. <\/p>\r\n\r\n\r\n\r\n
      For example, <\/strong> for the Corona Virus Statistics table, I wanted to remove the last row which is a Total Row on the website because I wanted to calculate the default Total from the Excel Table. If I do not remove the last row then the total applied on the table will be doubled.<\/p>\r\n\r\n\r\n[caption id=\"attachment_242599\" align=\"aligncenter\" width=\"1090\"]\"Extracted Extracted Data Table - Transformation Logic[\/caption]\r\n\r\n\r\n
      Once transformation is done [of course an optional step], table will be extracted in a normal Excel Table like below shown in the picture<\/p>\r\n\r\n\r\n[caption id=\"attachment_242600\" align=\"aligncenter\" width=\"873\"]\"Data Data Table for Graph[\/caption]\r\n\r\n\r\n
      Every time you want to refresh this data from the website, you need to click on the refresh button highlighted below on the right hand side <\/p>\r\n\r\n\r\n[caption id=\"attachment_242595\" align=\"aligncenter\" width=\"1023\"]\"Existing Existing Queries in Excel[\/caption]\r\n\r\n\r\n
      Excel VBA code to refresh Web data<\/h2>\r\n\r\n\r\n\r\n
      Basically to refresh the data from a web connection can be done following way<\/p>\r\n\r\n\r\n\r\n
      Refreshing a specific Connection by Connection Name<\/h4>\r\n\r\n\r\n\r\n
      Sub cbRefreshResult()\r\n    Dim wb As Workbook\r\n    Set wb = ThisWorkbook\r\n    wb.Connections(\"Query - Table 0\").Refresh\r\nEnd Sub<\/code><\/pre>\r\n\r\n\r\n\r\n
      Refreshing all the connections in a Workbook<\/h4>\r\n\r\n\r\n\r\n
      Sub cbRefreshResults()\r\n    Dim wb As Workbook\r\n    Set wb = ThisWorkbook\r\n    Dim con As WorkbookConnection\r\n    For Each con In wb.Connections\r\n        con.Refresh\r\n    Next con\r\nEnd Sub<\/code><\/pre>\r\n\r\n\r\n\r\n
      While refreshing you will notice that, your program will end immediately even though the data is still being refreshed. Basically by default Refresh of the data is done in background. In case you want to display a message to the user only when actually refresh is complete, then you need to disable the background processing.<\/p>\r\n\r\n\r\n\r\n
      How to disable background Query running<\/h4>\r\n\r\n\r\n\r\n
      You can disable it simply by executing this statement before executing the refresh method  - con.OLEDBConnection.BackgroundQuery = False<\/p>\r\n\r\n\r\n\r\n
      Sub cbRefreshResults()\r\n    Dim wb As Workbook\r\n    Set wb = ThisWorkbook\r\n    Dim con As WorkbookConnection\r\n\r\n    For Each con In wb.Connections\r\n        ' get the original value\r\n        bBackground = con.OLEDBConnection.BackgroundQuery\r\n        'Temporarily disable background-refresh\r\n        con.OLEDBConnection.BackgroundQuery = False\r\n        'Refresh this connection\r\n        con.Refresh\r\n        'Set background-refresh value back to original value\r\n        con.OLEDBConnection.BackgroundQuery = bBackground\r\n    Next con\r\n    MsgBox \"Data Is Refreshed from following site \" & vbNewLine & vbNewLine & \"https:\/\/www.worldometers.info\/coronavirus\/\" & vbNewLine & \" Time : \" & VBA.Now\r\nEnd Sub<\/code><\/pre>\r\n\r\n\r\n\r\n
      In the above code, Data Refreshed message will be shown on the screen only when data is loaded completely.<\/p>\r\n\r\n\r\n\r\n
      Thank you so much for reading this article. If you like this article, feel free to share it with your friends, colleagues, everyone... Stay Safe and healthy and keep learning<\/strong><\/p>\r\n","_et_gb_content_width":"","footnotes":""},"categories":[1246,1675,1681],"tags":[],"class_list":["post-15119","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-macro","category-excel-macro-for-beginners","category-personal"],"yoast_head":"\nCorona Virus Map Graphs - Using Web Query in Excel - Let's excel in Excel<\/title>\n<meta name=\"description\" content=\"Download Excel file with Live data from Internet about Corona Virus affected statistics. Map Graph for COVID-19 virus affected area. Refresh Webquery using Excel VBA\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Corona Virus Map Graphs - Using Web Query in Excel\" \/>\n<meta property=\"og:description\" content=\"Download Excel file with Live data from Internet about Corona Virus affected statistics. Map Graph for COVID-19 virus affected area. Refresh Webquery using Excel VBA\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-04T20:03:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-07T04:38:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2020\/03\/CoronaVirus-Demographics-1.gif\" \/>\n\t<meta property=\"og:image:width\" content=\"922\" \/>\n\t<meta property=\"og:image:height\" content=\"542\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/gif\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Corona Virus Map Graphs – Using Web Query in Excel\",\"datePublished\":\"2020-03-04T20:03:16+00:00\",\"dateModified\":\"2022-08-07T04:38:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/\"},\"wordCount\":922,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2020\/03\/CoronaVirus-Demographics-1.gif\",\"articleSection\":[\"Excel Macro\",\"Excel Macro Tutorial\",\"Personal\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/\",\"name\":\"Corona Virus Map Graphs - Using Web Query in Excel - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2020\/03\/CoronaVirus-Demographics-1.gif\",\"datePublished\":\"2020-03-04T20:03:16+00:00\",\"dateModified\":\"2022-08-07T04:38:04+00:00\",\"description\":\"Download Excel file with Live data from Internet about Corona Virus affected statistics. Map Graph for COVID-19 virus affected area. Refresh Webquery using Excel VBA\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2020\/03\/CoronaVirus-Demographics-1.gif\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2020\/03\/CoronaVirus-Demographics-1.gif\",\"width\":922,\"height\":542,\"caption\":\"Corona Demographics Graph in Excel VBA\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Corona Virus Map Graphs – Using Web Query in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Corona Virus Map Graphs - Using Web Query in Excel - Let's excel in Excel","description":"Download Excel file with Live data from Internet about Corona Virus affected statistics. Map Graph for COVID-19 virus affected area. Refresh Webquery using Excel VBA","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:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"Corona Virus Map Graphs - Using Web Query in Excel","og_description":"Download Excel file with Live data from Internet about Corona Virus affected statistics. Map Graph for COVID-19 virus affected area. Refresh Webquery using Excel VBA","og_url":"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2020-03-04T20:03:16+00:00","article_modified_time":"2022-08-07T04:38:04+00:00","og_image":[{"width":922,"height":542,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2020\/03\/CoronaVirus-Demographics-1.gif","type":"image\/gif"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Corona Virus Map Graphs – Using Web Query in Excel","datePublished":"2020-03-04T20:03:16+00:00","dateModified":"2022-08-07T04:38:04+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/"},"wordCount":922,"commentCount":3,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2020\/03\/CoronaVirus-Demographics-1.gif","articleSection":["Excel Macro","Excel Macro Tutorial","Personal"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/","url":"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/","name":"Corona Virus Map Graphs - Using Web Query in Excel - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2020\/03\/CoronaVirus-Demographics-1.gif","datePublished":"2020-03-04T20:03:16+00:00","dateModified":"2022-08-07T04:38:04+00:00","description":"Download Excel file with Live data from Internet about Corona Virus affected statistics. Map Graph for COVID-19 virus affected area. Refresh Webquery using Excel VBA","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2020\/03\/CoronaVirus-Demographics-1.gif","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2020\/03\/CoronaVirus-Demographics-1.gif","width":922,"height":542,"caption":"Corona Demographics Graph in Excel VBA"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2020\/03\/corona-virus-statistics-graphs-using-web-query-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"Corona Virus Map Graphs – Using Web Query in Excel"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/15119"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=15119"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/15119\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/242578"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=15119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=15119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=15119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}