{"id":1694,"date":"2022-07-18T09:12:00","date_gmt":"2022-07-18T14:12:00","guid":{"rendered":"http:\/\/xlfxs.com\/?p=1694"},"modified":"2022-07-18T09:12:00","modified_gmt":"2022-07-18T14:12:00","slug":"dynamic-text-in-shapes","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1694","title":{"rendered":"Shapes with dynamic output"},"content":{"rendered":"\n<p>A trick learned awhile ago. Creating shapes connected to cell, that updated automatically.<\/p>\n\n\n\n<p>When following steps attached, you will be able to connect any shape to any cell in away making it &#8220;linked&#8221;, so when cell changes the shape will also get updated.<\/p>\n\n\n\n<p>Used it to enlarge or track user attention to a certain value, or sometimes to format certain text in a free way outside cells limitations.<\/p>\n\n\n\n<!--more-->\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large is-style-default\"><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-1.png\"><img decoding=\"async\" data-id=\"1695\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-1.png\" alt=\"\" class=\"wp-image-1695\"\/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-2.png\"><img decoding=\"async\" data-id=\"1697\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-2.png\" alt=\"\" class=\"wp-image-1697\"\/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-3.png\"><img decoding=\"async\" data-id=\"1696\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-3.png\" alt=\"\" class=\"wp-image-1696\"\/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-4.png\"><img decoding=\"async\" data-id=\"1698\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-4.png\" alt=\"\" class=\"wp-image-1698\"\/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-5.png\"><img decoding=\"async\" data-id=\"1699\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-5.png\" alt=\"\" class=\"wp-image-1699\"\/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-6.png\"><img decoding=\"async\" data-id=\"1700\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-6.png\" alt=\"\" class=\"wp-image-1700\"\/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-7.png\"><img decoding=\"async\" data-id=\"1701\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-7.png\" alt=\"\" class=\"wp-image-1701\"\/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-8.png\"><img decoding=\"async\" data-id=\"1702\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-8.png\" alt=\"\" class=\"wp-image-1702\"\/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-9.png\"><img decoding=\"async\" data-id=\"1703\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-9.png\" alt=\"\" class=\"wp-image-1703\"\/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-10.png\"><img decoding=\"async\" data-id=\"1704\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes-10.png\" alt=\"\" class=\"wp-image-1704\"\/><\/a><\/figure>\n<\/figure>\n\n\n\n<p>See it in action &#8230;<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link\" href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/DynamicShapes.xlsx\" style=\"border-radius:3px\">Download<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link\" href=\"https:\/\/1drv.ms\/x\/s!An4iomsT7EVO65MzpS_ZRaJk4rIEhA?e=kLAaZs\" style=\"border-radius:3px\" target=\"_blank\" rel=\"noreferrer noopener\">Excel Online<\/a><\/div>\n<\/div>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>A trick learned awhile ago. Creating shapes connected to cell, that updated automatically. When following steps attached, you will be able to connect any shape to any cell in away making it &#8220;linked&#8221;, so when cell changes the shape will also get updated. Used it to enlarge or track user attention to a certain value,&#8230;<\/p>\n<p class=\"more-link-wrap\"><a href=\"https:\/\/xlfxs.com\/?p=1694\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &ldquo;Shapes with dynamic output&rdquo;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":1699,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25,28,5],"tags":[125,157,185,186],"class_list":["post-1694","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-user-tips","category-graphics","category-non-functions","tag-dynamic","tag-link","tag-shape","tag-shapes"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1694","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1694"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1694\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1699"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1694"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}