{"id":10041,"date":"2025-01-07T18:15:30","date_gmt":"2025-01-07T18:15:30","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/07\/huong-dan-thiet-lap-sparkline-bieu-thi-du-lieu-hieu-qua-trong-excel\/"},"modified":"2025-01-07T18:15:30","modified_gmt":"2025-01-07T18:15:30","slug":"huong-dan-thiet-lap-sparkline-bieu-thi-du-lieu-hieu-qua-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/07\/huong-dan-thiet-lap-sparkline-bieu-thi-du-lieu-hieu-qua-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp Sparkline bi\u1ec3u th\u1ecb d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3 trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Sparkline l\u00e0 m\u1ed9t d\u1ea1ng bi\u1ec3u \u0111\u1ed3 thu g\u1ecdn t\u1ed5ng h\u1ee3p v\u00e0 bi\u1ec3u th\u1ecb d\u1eef li\u1ec7u trong m\u1ed9t \u00f4 \u0111\u01a1n nh\u1ea5t. Trong b\u00e0i vi\u1ebft sau, h\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u c\u00e1ch thi\u1ebft l\u1eadp sparkline hi\u1ec7u qu\u1ea3:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-677d6f4210bd4\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/thiet-lap-sparkline-excel.html#Thiet_lap_sparkline\" title=\"Thi\u1ebft l\u1eadp sparkline\">Thi\u1ebft l\u1eadp sparkline<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/thiet-lap-sparkline-excel.html#Thay_doi_va_ap_dung_style_cho_sparkline\" title=\"Thay \u0111\u1ed5i v\u00e0 \u00e1p d\u1ee5ng style cho sparkline\">Thay \u0111\u1ed5i v\u00e0 \u00e1p d\u1ee5ng style cho sparkline<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/thiet-lap-sparkline-excel.html#Xoa_mot_hoac_mot_nhom_sparkline\" title=\"X\u00f3a m\u1ed9t ho\u1eb7c m\u1ed9t nh\u00f3m sparkline\">X\u00f3a m\u1ed9t ho\u1eb7c m\u1ed9t nh\u00f3m sparkline<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Thiet_lap_sparkline\"><\/span><strong>Thi\u1ebft l\u1eadp sparkline<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>Sparkline bao g\u1ed3m m\u1ed9t m\u1ed9t danh s\u00e1ch c\u00e1c \u0111i\u1ec3m \u0111\u00e1nh d\u1ea5u. D\u1ef1a v\u00e0o t\u1eebng lo\u1ea1i sparkline, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn \u0111\u00e1nh d\u1ea5u theo \u00fd mu\u1ed1n:<br \/>\nFirst point (\u0110i\u1ec3m \u0111\u1ea7u)<\/li>\n<li>Last point (\u0110i\u1ec3m cu\u1ed1i)<\/li>\n<li>High point (\u0110i\u1ec3m cao)<\/li>\n<li>Low point (\u0110i\u1ec3m th\u1ea5p)<\/li>\n<li>Negative point (\u0110i\u1ec3m \u00e2m)<\/li>\n<\/ul>\n<p><em>\u0110\u1ec3 t\u1ea1o m\u1ed9t ho\u1eb7c nhi\u1ec1u sparkline:<\/em><\/p>\n<ol>\n<li>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n t\u1ed5ng h\u1ee3p.<\/li>\n<li>Trong th\u1ebb <strong>Insert<\/strong>, nh\u00f3m <strong>Sparklines<\/strong>, click v\u00e0o lo\u1ea1i sparkline mu\u1ed1n t\u1ea1o.<\/li>\n<li>T\u1ea1i h\u1ed9p tho\u1ea1i <strong>Create Sparklines<\/strong>, h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n l\u00e0 ch\u00ednh x\u00e1c. \u1ede m\u1ee5c <strong>Location Range<\/strong>, nh\u1eadp v\u00e0o ho\u1eb7c ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u hi\u1ec3n th\u1ecb. \u0110\u1ed1i v\u1edbi v\u00f9ng d\u1eef li\u1ec7u, l\u01b0u \u00fd d\u1eef li\u1ec7u hi\u1ec3n th\u1ecb theo chi\u1ec1u d\u1ecdc hay ngang ph\u1ee5 thu\u1ed9c v\u00e0o s\u1ed1 l\u01b0\u1ee3ng \u00f4 nh\u1eadp v\u00e0o t\u1ea1i <strong>Location Range.<\/strong><\/li>\n<li>Trong th\u1ebb ng\u1eef c\u1ea3nh <strong>Design<\/strong>, nh\u00f3m <strong>Show<\/strong>, ch\u1ecdn nh\u1eefng thu\u1ed9c t\u00ednh \u0111\u00e1nh d\u1ea5u mu\u1ed1n hi\u1ec3n th\u1ecb.<\/li>\n<\/ol>\n<figure id=\"attachment_21329\" aria-describedby=\"caption-attachment-21329\" style=\"width: 902px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-21329\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-cach-tao-sparkline.png\" width=\"902\" height=\"533\" title=\"mos-excel-2010-cach-tao-sparkline\"><figcaption id=\"caption-attachment-21329\" class=\"wp-caption-text\">C\u00e1c b\u01b0\u1edbc t\u1ea1o sparkline<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Thay_doi_va_ap_dung_style_cho_sparkline\"><\/span><strong>Thay \u0111\u1ed5i v\u00e0 \u00e1p d\u1ee5ng style cho sparkline<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><em>\u0110\u1ec3 thay \u0111\u1ed5i ki\u1ec3u sparkline:<\/em><\/p>\n<ul>\n<li>Trong th\u1ebb <strong>Design<\/strong>, nh\u00f3m <strong>Type<\/strong>, ch\u1ecdn lo\u1ea1i sparkline b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i.<\/li>\n<\/ul>\n<p><em>\u0110\u1ec3 \u00e1p d\u1ee5ng style cho sparkline:<\/em><\/p>\n<p>T\u1ea1i\u00a0th\u1ebb <strong>Design<\/strong> l\u00e0m m\u1ed9t trong nh\u1eefng c\u00e1ch sau:<\/p>\n<ul>\n<li>Trong nh\u00f3m <strong>Style<\/strong>, ch\u1ecdn style b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng.<\/li>\n<li>Trong nh\u00f3m <strong>Style<\/strong>, m\u1ee5c <strong>Sparkline Color<\/strong>, ch\u1ecdn m\u00e0u b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng.<\/li>\n<li>M\u1ee5c <strong>Marker Color, <\/strong>ch\u1ecdn m\u00e0u ph\u00f9 h\u1ee3p cho c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng: <strong>Negative Points, Markers, High Point\u2026<\/strong><\/li>\n<\/ul>\n<figure id=\"attachment_21330\" aria-describedby=\"caption-attachment-21330\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-21330\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-style-1024x127-1.png\" width=\"1024\" height=\"127\" title=\"mos-excel-2010-style-1024x127-1\"><figcaption id=\"caption-attachment-21330\" class=\"wp-caption-text\">Style trong sparkline<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Xoa_mot_hoac_mot_nhom_sparkline\"><\/span><strong>X\u00f3a m\u1ed9t ho\u1eb7c m\u1ed9t nh\u00f3m sparkline<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><em>\u0110\u1ec3 x\u00f3a sparkline t\u00f9y ch\u1ecdn:<\/em> \u0110\u1ea7u ti\u00ean b\u1ea1n ch\u1ecdn m\u1ed9t ho\u1eb7c nhi\u1ec1u Sparkline mu\u1ed1n x\u00f3a. Sau \u0111\u00f3 trong th\u1ebb ng\u1eef c\u1ea3nh <strong>Design<\/strong>, nh\u00f3m <strong>Group<\/strong>, click v\u00e0o m\u0169i t\u00ean <strong>Clear <\/strong>v\u00e0 ch\u1ecdn <strong>Clear Selected Sparklines.<\/strong><\/p>\n<p><em>\u0110\u1ec3 x\u00f3a nh\u00f3m sparkline:<\/em> Ch\u1ecdn m\u1ed9t ho\u1eb7c nhi\u1ec1u sparkline trong c\u00f9ng nhomas b\u1ea1n mu\u1ed1n x\u00f3a. Sau \u0111\u00f3 trong th\u1ebb ng\u1eef c\u1ea3nh <strong>Design<\/strong>, nh\u00f3m <strong>Group<\/strong>, click v\u00e0o m\u0169i t\u00ean <strong>Clear <\/strong>v\u00e0 ch\u1ecdn <strong>Clear Selected Sparklines Group.<\/strong><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-126.gif\" title=\"ex101_92019-nho-126\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21331\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-xoa-sparkline.png\" width=\"859\" height=\"533\" title=\"mos-excel-2010-xoa-sparkline\"><\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t. V\u00e0 \u0111\u1eebng qu\u00ean theo d\u00f5i nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> trong series MOS nh\u00e9.<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-126.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10042,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10041","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10041","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=10041"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10041\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10042"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10041"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10041"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10041"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}