<\/p>

<\/ul><\/div>\n
\n

\n\n\n\n\n\n\n<\/div>\n

Imi\u0119 i nazwisko (wymagane)
\n <\/span> <\/label><\/p>\n

Adres email (wymagane)
\n <\/span> <\/label>
\nPlease leave this field empty.<\/label><\/span><\/p>\n

<\/p>\n

Δ<\/textarea><\/label><input type=\"hidden\" id=\"ak_js\" name=\"_wpcf7_ak_js\" value=\"235\"\/><script>document.getElementById( \"ak_js\" ).setAttribute( \"value\", ( new Date() ).getTime() );<\/script><\/p><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div><\/form><\/div>[\/vc_column_text]<div class=\"hr-thin style-dashed accent-border-color\" style=\"width: 100%;border-top-width: 1px;\"><\/div>[\/vc_column][\/vc_row][vc_row][vc_column][vc_empty_space][vc_column_text]W odr\u0119bnym arkuszu programu Excel przygotuj dane, kt\u00f3rych dotyczy\u0107 ma wykres (np. procentowy post\u0119p zada\u0144 lub udzia\u0142 danego produktu we wszystkich produktach firmy).[\/vc_column_text][vc_empty_space][vc_single_image image=”46980″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]Aby usprawni\u0107 sobie wyb\u00f3r zadania lub produktu ka\u017cd\u0105 powsta\u0142\u0105 tabel\u0119 zdefiniuj poprzez znajduj\u0105cy si\u0119 w zak\u0142adce \u201eFormu\u0142y\u201d \u201emenad\u017cer nazw\u201d, lub wpisuj\u0105c w panel nazwy \u2013 nadan\u0105 nazw\u0119 tabeli z danymi) (<a href=\"http:\/\/tmproject.pl\/definiowanie-nazw-ms-excel\/\">Instrukcj\u0119 znajdziesz tutaj<\/a>).[\/vc_column_text][vc_empty_space][vc_single_image image=”46981″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]W arkuszu, gdzie ma znajdowa\u0107 si\u0119 wykres wybierz kom\u00f3rk\u0119, w kt\u00f3rej zdefiniujesz wyb\u00f3r odpowiedniego zadania\/produktu \u2013 u\u017cyj w tym celu listy rozwijanej (<a href=\"http:\/\/tmproject.pl\/rozwijana-lista-ms-excel\/\">Lista rozwijana \u2013 instrukcja<\/a>).[\/vc_column_text][vc_empty_space][vc_single_image image=”46982″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]Od teraz w kom\u00f3rce pojawi\u0142a si\u0119 lista, z kt\u00f3rej u\u017cytkownik mo\u017ce wybra\u0107 interesuj\u0105ce go zadanie.[\/vc_column_text][vc_empty_space][vc_single_image image=”46983″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]Przed stworzeniem samego wykresu nale\u017cy jeszcze wpisa\u0107 formu\u0142\u0119, dzi\u0119ki kt\u00f3rej b\u0119dzie mo\u017cliwe wyszukanie odpowiedniej warto\u015bci post\u0119pu procentowego dla wybranego zadania.[\/vc_column_text][vc_empty_space][vc_column_text]W tym celu w wybranej kom\u00f3rce nale\u017cy zamie\u015bci\u0107 formu\u0142\u0119 WYSZUKAJ.PIONOWO[\/vc_column_text][vc_empty_space][vc_single_image image=”46984″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]Pami\u0119taj! \ud83d\ude42<\/p>\n<p>Aby odpowiedni wy\u015bwietli\u0107 warto\u015bci liczba powinna by\u0107 sformatowana jako %<\/p>\n<p> <\/p>\n<p>Formu\u0142a:<\/p>\n<p>=WYSZUKAJ.PIONOWO(E3;Dane!B2:C8;2;PRAWDA)<\/p>\n<p> <\/p>\n<p>Od teraz wybieraj\u0105c zadanie z listy rozwijanej otrzymasz jego procentowy post\u0119p[\/vc_column_text][vc_empty_space][vc_single_image image=”46985″ img_size=”full” alignment=”center”][vc_empty_space]<div class=\"hr-thin style-dotted accent-border-color\" style=\"width: 100%;border-top-width: 1px;\"><\/div>[vc_empty_space height=”10px”][vc_column_text]<\/p>\n<p style=\"text-align: center;\"><strong>Wykres<\/strong><\/p>\n<p>[\/vc_column_text][vc_empty_space height=”10px”]<div class=\"hr-thin style-dotted accent-border-color\" style=\"width: 100%;border-top-width: 1px;\"><\/div>[vc_empty_space][vc_column_text]W arkuszu wybierz tabel\u0119 zawieraj\u0105c\u0105 10×10 kom\u00f3rek \u2013 tu b\u0119dzie znajdowa\u0142 si\u0119 Tw\u00f3j wykres. Nast\u0119pnie wybranym kom\u00f3rkom wybierz obramowanie, aby odr\u00f3\u017cni\u0107 je od reszty arkusza.[\/vc_column_text][vc_empty_space][vc_single_image image=”46986″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]W ka\u017cdej kom\u00f3rce stworzonej tabeli wpisz warto\u015bci odpowiadaj\u0105ce post\u0119powi procentowemu (1-100%).[\/vc_column_text][vc_empty_space][vc_single_image image=”46987″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]A\u017c do pe\u0142nego zape\u0142nienia tabeli:[\/vc_column_text][vc_empty_space][vc_single_image image=”46988″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]W kom\u00f3rkach, w kt\u00f3rych ma znajdowa\u0107 si\u0119 panel wyboru zada\u0144\/produkt\u00f3w\/element\u00f3w kt\u00f3rych post\u0119p lub podzia\u0142 chcesz wy\u015bwietla\u0107 wpisz nag\u0142\u00f3wek.[\/vc_column_text][vc_empty_space][vc_single_image image=”46989″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]Zaznacz obszar tabeli[\/vc_column_text][vc_empty_space][vc_single_image image=”46990″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]Nast\u0119pnie z panelu Formatowanie warunkowe wybierz opcj\u0119 Nowa regu\u0142a[\/vc_column_text][vc_empty_space][vc_single_image image=”46991″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]Wybierz opcj\u0119 Formatuj tylko kom\u00f3rki zawieraj\u0105ce -> warto\u015b\u0107 kom\u00f3rki mi\u0119dzy -> 0 i kom\u00f3rka, w kt\u00f3rej u\u017cyta zosta\u0142a formu\u0142a WYSZUKAJ.PIONOWO (czyli procentowy post\u0119p danego zadania)[\/vc_column_text][vc_empty_space][vc_single_image image=”46992″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]Nast\u0119pnie w opcji \u201eFormatuj\u201d wybierz kolor t\u0142a, jak chcesz by mia\u0142 wykres. Wa\u017cne jest, \u017ce aby formatowanie (kolor) czcionki by\u0142 taki sam jak t\u0142o \u2013 sprawi to \u017ce nie b\u0119d\u0105 one widoczne na wykresie.[\/vc_column_text][vc_empty_space][vc_single_image image=”46971″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]Zapisz zmiany edytora regu\u0142 formatowania[\/vc_column_text][vc_empty_space][vc_single_image image=”46972″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]Tak powinien wygl\u0105da\u0107 Tw\u00f3j wykres je\u017celi u\u017cy\u0142e\u015b naszych przyk\u0142adowych danych:[\/vc_column_text][vc_empty_space][vc_single_image image=”46973″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]Okre\u015bli\u0142e\u015b ju\u017c warto\u015bci formatowane. Teraz powiniene\u015b sformatowa\u0107 r\u00f3wnie\u017c widok wyj\u015bciowy wykresu. Aby to zrobi\u0107 zaznacz ca\u0142y obszar wykresu i wybierz jego wype\u0142nienie.[\/vc_column_text][vc_empty_space][vc_single_image image=”46974″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]Oraz taki sam kolor czcionki:[\/vc_column_text][vc_empty_space][vc_single_image image=”46975″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]Ostatnim etapem formatowania wykresu jest opcjonalna zmiana koloru samej tabeli.[\/vc_column_text][vc_empty_space][vc_single_image image=”46976″ img_size=”full” alignment=”center”][vc_empty_space][vc_single_image image=”46977″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]Je\u017celi chcesz aby wy\u015bwietla\u0142 si\u0119 na nim post\u0119p:[\/vc_column_text][vc_empty_space][vc_single_image image=”46978″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]Z zak\u0142adki \u201eWstawianie\u201d wybierz \u201ePole tekstowe\u201d i umie\u015b\u0107 je w wybrany miejscu<\/p>\n<p>Nast\u0119pnie wybierz je i w pasku formu\u0142 wybierz kom\u00f3rk\u0119, w kt\u00f3rej za pomoc\u0105 funkcji WYSZUKAJ.PIONOWO uzyska\u0142e\u015b procentowy post\u0119p zada\u0144.[\/vc_column_text][vc_empty_space][vc_single_image image=”46979″ img_size=”full” alignment=”center”][vc_empty_space][vc_column_text]Gotowe! :)[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_empty_space]<div class=\"hr-thin style-dashed accent-border-color\" style=\"width: 100%;border-top-width: 1px;\"><\/div>[vc_column_text]Jeszcze nie spr\u00f3bowa\u0142e\u015b?<\/p>\n<p>Zr\u00f3b to koniecznie! :)[\/vc_column_text][vc_empty_space][vc_column_text]<div role=\"form\" class=\"wpcf7\" id=\"wpcf7-f47001-o2\" lang=\"pl-PL\" dir=\"ltr\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/wp-json\/wp\/v2\/posts\/46968#wpcf7-f47001-o2\" method=\"post\" class=\"wpcf7-form init\" novalidate=\"novalidate\" data-status=\"init\">\n<div style=\"display: none;\">\n<input type=\"hidden\" name=\"_wpcf7\" value=\"47001\" \/>\n<input type=\"hidden\" name=\"_wpcf7_version\" value=\"5.4.2\" \/>\n<input type=\"hidden\" name=\"_wpcf7_locale\" value=\"pl_PL\" \/>\n<input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f47001-o2\" \/>\n<input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/>\n<input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/>\n<\/div>\n<p><label> Imi\u0119 i nazwisko (wymagane)<br \/>\n <span class=\"wpcf7-form-control-wrap your-name\"><input type=\"text\" name=\"your-name\" value=\"\" size=\"40\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" \/><\/span> <\/label><\/p>\n<p><label> Adres email (wymagane)<br \/>\n <span class=\"wpcf7-form-control-wrap your-email\"><input type=\"email\" name=\"your-email\" value=\"\" size=\"40\" class=\"wpcf7-form-control wpcf7-text wpcf7-email wpcf7-validates-as-required wpcf7-validates-as-email\" aria-required=\"true\" aria-invalid=\"false\" \/><\/span> <\/label><br \/>\n<span id=\"wpcf7-6639699c9accd-wrapper\" class=\"wpcf7-form-control-wrap honeypot-468-wrap\" style=\"display:none !important; visibility:hidden !important;\"><label for=\"wpcf7-6639699c9accd-field\" class=\"hp-message\">Please leave this field empty.<\/label><input id=\"wpcf7-6639699c9accd-field\" class=\"wpcf7-form-control wpcf7-text\" type=\"text\" name=\"honeypot-468\" value=\"\" size=\"40\" tabindex=\"-1\" autocomplete=\"new-password\" \/><\/span><\/p>\n<p><input type=\"submit\" value=\"Wy\u015blij\" class=\"wpcf7-form-control wpcf7-submit\" \/><\/p>\n<p style=\"display: none !important;\"><label>Δ<textarea name=\"_wpcf7_ak_hp_textarea\" cols=\"45\" rows=\"8\" maxlength=\"100\"><\/textarea><\/label><input type=\"hidden\" id=\"ak_js\" name=\"_wpcf7_ak_js\" value=\"154\"\/><script>document.getElementById( \"ak_js\" ).setAttribute( \"value\", ( new Date() ).getTime() );<\/script><\/p><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div><\/form><\/div>[\/vc_column_text]<div class=\"hr-thin style-dashed accent-border-color\" style=\"width: 100%;border-top-width: 1px;\"><\/div>[\/vc_column][\/vc_row]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[vc_row][vc_column][vc_empty_space][vc_column_text]Wykres wafelkowy jest kolejnym elementem, kt\u00f3ry mo\u017cesz u\u017cy\u0107 w swoim dashboardzie. Jest naprawd\u0119 efektywny i prosty w wykonaniu. Sprawd\u017a sam ! :)[\/vc_column_text][vc_empty_space][vc_single_image image=”46978″ img_size=”full” alignment=”center”][\/vc_column][\/vc_row][vc_row][vc_column][vc_empty_space][vc_column_text]Pobierz przyk\u0142adowy arkusz Excel i instrukcj\u0119 i spr\u00f3buj sam! :)[\/vc_column_text][vc_empty_space][vc_column_text][\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_empty_space][vc_column_text]W odr\u0119bnym arkuszu programu Excel przygotuj dane, kt\u00f3rych dotyczy\u0107 ma wykres (np. procentowy post\u0119p zada\u0144 lub udzia\u0142 danego produktu we wszystkich produktach…<\/p>\n","protected":false},"author":5,"featured_media":46996,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[257],"tags":[],"_links":{"self":[{"href":"https:\/\/tmproject.pl\/wp-json\/wp\/v2\/posts\/46968"}],"collection":[{"href":"https:\/\/tmproject.pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tmproject.pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tmproject.pl\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/tmproject.pl\/wp-json\/wp\/v2\/comments?post=46968"}],"version-history":[{"count":6,"href":"https:\/\/tmproject.pl\/wp-json\/wp\/v2\/posts\/46968\/revisions"}],"predecessor-version":[{"id":47002,"href":"https:\/\/tmproject.pl\/wp-json\/wp\/v2\/posts\/46968\/revisions\/47002"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tmproject.pl\/wp-json\/wp\/v2\/media\/46996"}],"wp:attachment":[{"href":"https:\/\/tmproject.pl\/wp-json\/wp\/v2\/media?parent=46968"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tmproject.pl\/wp-json\/wp\/v2\/categories?post=46968"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tmproject.pl\/wp-json\/wp\/v2\/tags?post=46968"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}