{"id":5905,"date":"2024-12-21T11:16:16","date_gmt":"2024-12-21T11:16:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-ve-dang-bieu-do-combo-trong-excel-2010\/"},"modified":"2024-12-21T11:16:16","modified_gmt":"2024-12-21T11:16:16","slug":"huong-dan-cach-ve-dang-bieu-do-combo-trong-excel-2010","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-ve-dang-bieu-do-combo-trong-excel-2010\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd d\u1ea1ng bi\u1ec3u \u0111\u1ed3 combo trong Excel 2010"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Combo Chart l\u00e0 d\u1ea1ng bi\u1ec3u\u00a0\u0111\u1ed3 c\u00f3 2 tr\u1ee5c tung v\u00e0 1 tr\u1ee5c ho\u00e0nh tr\u00ean c\u00f9ng 1 tr\u1ee5c t\u1ecda\u00a0\u0111\u1ed9. V\u1edbi combo chart ch\u00fang ta c\u00f3 th\u1ec3 bi\u1ec3u di\u1ec5n\u00a0\u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u d\u1ea1ng bi\u1ec3u\u00a0\u0111\u1ed3\u00a0\u0111\u1eb9p v\u00e0 chuy\u00ean nghi\u1ec7p. Nh\u01b0ng trong phi\u00ean b\u1ea3n Microsoft\u00a0Excel 2010 ch\u00fang ta th\u1ea5y kh\u00f4ng c\u00f3 ph\u1ea7n combo chart, m\u00e0 ch\u1ec9 c\u00f3 t\u1eeb phi\u00ean b\u1ea3n 2013, 2016,\u00a0Office 365. V\u1eady n\u1ebfu b\u1ea1n\u00a0\u0111ang s\u1eed d\u1ee5ng\u00a0Excel 2010 th\u00ec ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.<\/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-6766a37f9b039\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-dang-bieu-combo-trong-excel-2010.html#Nguyen_tac_cua_bieu_do_Combo\" title=\"Nguy\u00ean t\u1eafc c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3 Combo\">Nguy\u00ean t\u1eafc c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3 Combo<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-dang-bieu-combo-trong-excel-2010.html#Cach_thay_doi_du_lieu_ve_truc_tung_thu_2\" title=\"C\u00e1ch thay\u00a0\u0111\u1ed5i d\u1eef li\u1ec7u v\u1ec1 tr\u1ee5c tung th\u1ee9 2\">C\u00e1ch thay\u00a0\u0111\u1ed5i d\u1eef li\u1ec7u v\u1ec1 tr\u1ee5c tung th\u1ee9 2<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-ve-dang-bieu-combo-trong-excel-2010.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Nguyen_tac_cua_bieu_do_Combo\"><\/span>Nguy\u00ean t\u1eafc c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3 Combo<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Bi\u1ec3u\u00a0\u0111\u1ed3 combo (hay c\u00f2n g\u1ecdi l\u00e0 combo chart) l\u00e0 d\u1ea1ng bi\u1ec3u\u00a0\u0111\u1ed3 c\u00f3 1 tr\u1ee5c ho\u00e0nh v\u00e0 2 tr\u1ee5c tung tr\u00ean c\u00f9ng 1 tr\u1ee5c t\u1ecda\u00a0\u0111\u1ed9.<\/p>\n<p>Th\u00f4ng th\u01b0\u1eddng khi v\u1ebd bi\u1ec3u\u00a0\u0111\u1ed3\u00a0trong\u00a0excel th\u00ec kh\u00f4ng c\u00f3 s\u1eb5n tr\u1ee5c tung th\u1ee9 2, m\u00e0 ng\u01b0\u1eddi d\u00f9ng ph\u1ea3i t\u1ef1\u00a0\u0111i\u1ec1u ch\u1ec9nh thi\u1ebft l\u1eadp cho d\u1eef li\u1ec7u. Trong c\u00e1c phi\u00ean b\u1ea3n\u00a0Excel 2013 tr\u1edf\u00a0\u0111i,\u00a0Excel cho ph\u00e9p v\u1ebd tr\u1ef1c ti\u1ebfp d\u1ea1ng bi\u1ec3u\u00a0\u0111\u1ed3 Combo n\u00e0y.<\/p>\n<p>Tr\u1ee5c tung th\u1ee9 1\u00a0\u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 <strong>Primary\u00a0Axis.<\/strong><\/p>\n<p>Tr\u1ee5c tung th\u1ee9 2\u00a0\u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 <strong>Secondary\u00a0Axis<\/strong>.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_thay_doi_du_lieu_ve_truc_tung_thu_2\"><\/span>C\u00e1ch thay\u00a0\u0111\u1ed5i d\u1eef li\u1ec7u v\u1ec1 tr\u1ee5c tung th\u1ee9 2<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd d\u1ef1a tr\u00ean n\u1ed9i dung c\u1ee7a b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dinh-dang-bieu-theo-dieu-kien-cho-bieu-do-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n cho bi\u1ec3u \u0111\u1ed3 tr\u00ean Excel<\/a><\/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\/2024\/12\/ex101_92019-nho-525.gif\" title=\"ex101_92019-nho-525\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Khi c\u00e1c b\u1ea1n th\u1ef1c hi\u1ec7n tr\u00ean\u00a0Excel 2010, ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m theo h\u01b0\u1edbng d\u1eabn trong b\u00e0i vi\u1ebft tr\u00ean t\u1edbi giai\u00a0\u0111o\u1ea1n v\u1ebd\u00a0\u0111\u01b0\u1ee3c bi\u1ec3u\u00a0\u0111\u1ed3 2 c\u1ed9t\u00a0\u0111\u1ee9ng c\u1ea1nh nhau nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23319\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ve-bieu-do-2-cot-canh-nhau.png\" width=\"1195\" height=\"337\" title=\"ve-bieu-do-2-cot-canh-nhau\"><\/p>\n<p>\u00a0<\/p>\n<p>Y\u00eau c\u1ea7u ti\u1ebfp theo l\u00e0 th\u1ec3 hi\u1ec7n n\u1ed9i dung c\u1ed9t DT Max l\u00ean tr\u1ee5c tung th\u1ee9 2\u00a0\u0111\u1ec3 l\u00e0m cho 2 c\u1ed9t m\u00e0u cam v\u00e0 m\u00e0u xanh (gi\u00e1 tr\u1ecb 680) s\u1ebd l\u1ed3ng l\u00ean nhau tr\u00ean c\u00f9ng 1 \u0111i\u1ec3m g\u1ed1c, thay v\u00ec\u00a0\u0111\u1ee9ng c\u1ea1nh nhau.<\/p>\n<p>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: B\u1ea5m ch\u1ecdn bi\u1ec3u\u00a0\u0111\u1ed3. Khi\u00a0\u0111\u00f3 xu\u1ea5t hi\u1ec7n th\u1ebb <strong>Chart Tools<\/strong> tr\u00ean thanh c\u00f4ng c\u1ee5.<\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: B\u1ea5m ch\u1ecdn m\u1ee5c <strong>Format<\/strong> trong Chart Tools. Ch\u00fa\u00a0\u00fd ph\u1ea7n b\u00ean tr\u00e1i c\u1ee7a Format c\u00f3 nh\u00f3m <strong>Current Selection<\/strong><\/p>\n<p>B\u01b0\u1edbc 3: B\u1ea5m ch\u1ecdn v\u00e0o m\u1ee5c Plot\u00a0Area (c\u00f3 n\u00fat\u00a0m\u0169i t\u00ean h\u01b0\u1edbng xu\u1ed1ng trong\u00a0\u00f4 h\u00ecnh ch\u1eef nh\u1eadt).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23320\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/format-current-selection.png\" width=\"871\" height=\"199\" title=\"format-current-selection\"><\/p>\n<p>Khi b\u1ea5m v\u00e0o m\u1ee5c n\u00e0y s\u1ebd x\u1ed5 xu\u1ed1ng 1 danh s\u00e1ch c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ee7a bi\u1ec3u\u00a0\u0111\u1ed3. L\u00fac n\u00e0y ch\u00fang ta ch\u1ecdn\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n bi\u1ec3u di\u1ec5n tr\u00ean tr\u1ee5c tung th\u1ee9 2 (s\u1ed1 1)\u00a0r\u1ed3i b\u1ea5m v\u00e0o Format Selection (s\u1ed1 2)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23321\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/format-object-chart.png\" width=\"360\" height=\"453\" title=\"format-object-chart\"><\/p>\n<p>Xu\u1ea5t hi\u1ec7n th\u1ebb Format Data Series. Trong th\u1ebb n\u00e0y ch\u00fang ta ch\u1ecdn Secondary\u00a0Axis l\u00e0 xong (s\u1ed1 3).<\/p>\n<p><strong>Ch\u00fa\u00a0\u00fd:<\/strong><br \/>\nGiao di\u1ec7n c\u1ee7a h\u00ecnh\u00a0\u1ea3nh ch\u1ee5p\u00a0\u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n trong\u00a0Excel\u00a0Office 365, nh\u01b0ng th\u1ee9 t\u1ef1 th\u1ef1c hi\u1ec7n \u00e1p d\u1ee5ng trong\u00a0Excel 2010.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 v\u1eady trong\u00a0Excel 2010 ch\u00fang ta v\u1eabn c\u00f3 th\u1ec3 v\u1ebd\u00a0\u0111\u01b0\u1ee3c combo chart m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng ph\u1ea3i kh\u00f4ng n\u00e0o. Tuy kh\u00f4ng d\u1ec5 nh\u01b0\u00a0\u1edf phi\u00ean b\u1ea3n 2013, 2016,\u00a0Office 365 nh\u01b0ng phi\u00ean b\u1ea3n 2010 kh\u00e1 ph\u1ed5 bi\u1ebfn, do\u00a0\u0111\u00f3 ch\u00fang ta h\u00e3y ghi nh\u1edb c\u00e1ch l\u00e0m n\u00e0y\u00a0\u0111\u1ec3 kh\u00f4ng ph\u1ea3i m\u1ea5t c\u00f4ng chuy\u1ec3n sang phi\u00ean b\u1ea3n kh\u00e1c nh\u00e9.<\/p>\n<p>\u0110\u1ec3 gi\u00fap c\u00e1c b\u1ea1n hi\u1ec3u th\u00eam v\u1ec1 t\u00ednh\u00a0\u1ee9ng d\u1ee5ng c\u1ee7a Combo Chart, ch\u00fang ta c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-do-cot-ket-hop-duong-bieu-dien-tren-excel-chi-tiet-nhat.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng bi\u1ec3u di\u1ec5n tr\u00ean Excel chi ti\u1ebft nh\u1ea5t<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-hinh-tron-thuc-hien-ke-hoach-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n % th\u1ef1c hi\u1ec7n k\u1ebf ho\u1ea1ch tr\u00ean Excel<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-do-hinh-cot-co-gia-tri-am-duong-khac-mau-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t c\u00f3 gi\u00e1 tr\u1ecb \u00e2m d\u01b0\u01a1ng kh\u00e1c m\u00e0u tr\u00ean Excel<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tu-dong-gan-logo-tren-bieu-do-hinh-cot.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ef1 \u0111\u1ed9ng g\u1eafn logo tr\u00ean bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t<\/a><\/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\/2024\/12\/ex101_92019-nho-525.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5906,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5905","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\/5905","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=5905"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5905\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5906"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5905"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5905"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}