{"id":7035,"date":"2024-08-13T16:22:48","date_gmt":"2024-08-13T13:22:48","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=7035"},"modified":"2024-08-13T16:22:48","modified_gmt":"2024-08-13T13:22:48","slug":"pravylo-pidsvitky-kolorovi-linijni-diagramy","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/stvorennya-interaktyvnogo-deshborda\/pidsvitka\/pravylo-pidsvitky-kolorovi-linijni-diagramy\/","title":{"rendered":"Format Rule: Bar Color Range"},"content":{"rendered":"<p>\u201cBar Color Ranges\u201d allow you to visualize numeric values using bars whose colors are contained in the specified color set:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_9_1-2.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7050\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_9_1-2.png\" alt=\"\" width=\"413\" height=\"392\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_9_1-2.png 413w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_9_1-2-300x285.png 300w\" sizes=\"(max-width: 413px) 100vw, 413px\" \/><\/a><\/p>\n<p>This dialog allows you to change the following options specific to \u201cBar Color Ranges\u201d:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_9_2-2.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7049\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_9_2-2.png\" alt=\"\" width=\"284\" height=\"642\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_9_2-2.png 284w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_9_2-2-199x450.png 199w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_9_2-2-133x300.png 133w\" sizes=\"(max-width: 284px) 100vw, 284px\" \/><\/a><\/p>\n<p>The following options will be available in the appeared window:<\/p>\n<ul>\n<li>Format style \u2013 the \u201cFormat Style\u201d combo box allows you to change the color set used to apply formatting;<\/li>\n<li>Use % ranges \u2013 the \u201cUse % ranges\u201d check box specifies whether the percent or absolute scale is used to generate ranges;<\/li>\n<li>Range field with specifies values:<\/li>\n<\/ul>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_9_3-2.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7048\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_9_3-2.png\" alt=\"\" width=\"240\" height=\"98\" \/><\/a><\/p>\n<p>Use the \u00abAdd\u00bb and \u00abDelete\u00bb buttons to add new ranges or delete the selected range respectively. Note that new range is added below the selected range:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_9_4-2.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7047\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_9_4-2.png\" alt=\"\" width=\"250\" height=\"150\" \/><\/a><\/p>\n<p>To change the icon displayed for values corresponding to the specified range, click the button next to the required icon and select a new icon:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_9_5-2.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7046\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_9_5-2.png\" alt=\"\" width=\"257\" height=\"243\" \/><\/a><\/p>\n<ul>\n<li>Intersection mode \u2013 the level at which the highlight will be The levels can be as follows:\n<ul>\n<li>Auto \u2013 identifies the default For the Pivot dashboard item, Auto identifies the \u201cFirst Level\u201d;<\/li>\n<li>First level \u2013 first level values are used to apply conditional formatting;<\/li>\n<li>Last level \u2013 the last level values are used to apply conditional formatting;<\/li>\n<\/ul>\n<\/li>\n<li>All levels \u2013 all pivot data cells are used to apply conditional formatting;<\/li>\n<li>Specific level \u2013 values from the specific level are used to apply conditional<\/li>\n<li>Row\/Column dimension &#8211; if you specified the Intersection mode as \u201cSpecific Level\u201d, use the \u201cRow dimension\u201d and \u201cColumn dimension\u201d combo boxes to set the specific level;<\/li>\n<li>Apply to \u2013 to which element (measure, hierarchy) of the Pivot table the conditional formatting should be applied;<\/li>\n<li>Apply to row\/column \u2013 apply to the entire row \/ to the entire column;<\/li>\n<li>Allow negative axis \u2013 the \u201cAllow negative axis\u201d option allows you to specify whether negative data bars are displayed in the direction opposite to the positive data bars;<\/li>\n<li>Draw axis \u2013 the \u201cDraw axis\u201d option specifies whether to draw the vertical axis between positive and negative data bars;<\/li>\n<li>Show bar only \u2013 the \u201cShow bar\u201d only option specifies whether to show bars without corresponding values.<\/li>\n<\/ul>\n<p><\/p>","protected":false},"featured_media":0,"parent":6908,"menu_order":527,"template":"","manuals":[18],"class_list":["post-7035","manual","type-manual","status-publish","hentry","manuals-bat-desktop"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/7035","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual"}],"about":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/types\/manual"}],"up":[{"embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/6908"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=7035"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=7035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}