{"id":10928,"date":"2025-01-15T00:47:32","date_gmt":"2025-01-15T00:47:32","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-tao-bieu-do-du-bao-nhiet-trong-excel\/"},"modified":"2025-01-15T00:47:32","modified_gmt":"2025-01-15T00:47:32","slug":"cach-tao-bieu-do-du-bao-nhiet-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-tao-bieu-do-du-bao-nhiet-trong-excel\/","title":{"rendered":"C\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 d\u1ef1 b\u00e1o nhi\u1ec7t trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch \u0111\u1ec3 t\u1ea1o 1 bi\u1ec3u \u0111\u1ed3 \u0111o nhi\u1ec7t \u0111\u1ed9 kh\u00f4ng ch\u1ec9 v\u1edbi ch\u1ee9c n\u0103ng th\u00f4ng b\u00e1o c\u00e1c m\u1ee9c nhi\u1ec7t cao th\u1ea5p m\u00e0 c\u00f2n th\u1ec3 hi\u1ec7n \u0111\u01b0\u1ee3c nhi\u1ec7t \u0111\u1ed9 cao nh\u1ea5t v\u00e0 th\u1ea5p nh\u1ea5t theo m\u00f9a n\u1eefa. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n s\u1ebd \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng tr\u00ean phi\u00ean b\u1ea3n Excel 2007 v\u00e0 2010, v\u1edbi bi\u1ec3u \u0111\u1ed3 ho\u00e0n ch\u1ec9nh nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9433\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/figure1.png\" width=\"600\" height=\"360\" title=\"figure1\"><\/p>\n<p style=\"text-align: justify\"><strong>S\u1ed1 li\u1ec7u<\/strong><\/p>\n<p style=\"text-align: justify\">Sau khi d\u1ef1 \u0111o\u00e1n m\u1ee9c nhi\u1ec7t \u0111\u1ed9 cao th\u1ea5p c\u0169ng nh\u01b0 \u0111i\u1ec3m nhi\u1ec7t t\u1ed1i \u0111a v\u00e0 t\u1ed1i thi\u1ec3u theo m\u00f9a, ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u A1:F16 nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9434\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/figure2.png\" width=\"600\" height=\"178\" title=\"figure2\"><\/p>\n<p style=\"text-align: justify\"><strong>Bi\u1ec3u \u0111\u1ed3\u00a0c\u01a1 b\u1ea3n<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 b\u1eaft \u0111\u1ea7u l\u1eadp bi\u1ec3u \u0111\u1ed3, b\u1ea1n c\u1ea7n<\/p>\n<ul style=\"text-align: justify\">\n<li>B\u00f4i \u0111en to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong b\u1ea3ng<\/li>\n<li>Ch\u1ecdn tab Insert -&gt; Bi\u1ec3u \u0111\u1ed3 mi\u1ec1n (Area Chart) v\u00e0 ch\u1ecdn Bi\u1ec3u \u0111\u1ed3 mi\u1ec1n d\u1ea1ng ch\u1ed3ng (Stacked Area Chart) (bi\u1ec3u \u0111\u1ed3 th\u1ee9 2 \u1edf h\u00e0ng tr\u00ean c\u00f9ng)<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Khi \u0111\u00f3 m\u1ed9t bi\u1ec3u \u0111\u1ed3 m\u1edbi tr\u00f4ng kh\u00e1 \u201cg\u1edbm ghi\u1ebfc\u201d s\u1ebd hi\u1ec7n ra<\/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-243.gif\" title=\"ex101_92019-nho-243\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9435\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/figure3.png\" width=\"600\" height=\"368\" title=\"figure3\"><\/p>\n<p style=\"text-align: justify\">Click ch\u1ecdn to\u00e0n b\u1ed9 bi\u1ec3u \u0111\u1ed3 v\u00e0 b\u1ea5m v\u00e0o tab Chart Tools -&gt; Design -&gt; Select Data<\/p>\n<p style=\"text-align: justify\">M\u1ed9t c\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i s\u1ebd hi\u1ec7n ra \u0111\u1ec3 gi\u00fap ta c\u00f3 th\u1ec3 thay \u0111\u1ed5i c\u00e1c chu\u1ed7i d\u1eef li\u1ec7u m\u1eb7c \u0111\u1ecbnh. C\u00f3 th\u1ec3 th\u1ea5y th\u1ee9 t\u1ef1 c\u00e1c danh m\u1ee5c d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi theo chi\u1ec1u xu\u1ea5t hi\u1ec7n trong bi\u1ec3u \u0111\u1ed3 (danh m\u1ee5c \u0111\u1ea7u ti\u00ean s\u1ebd \u0111\u01b0\u1ee3c x\u1ebfp d\u01b0\u1edbi c\u00f9ng trong bi\u1ec3u \u0111\u1ed3, sau \u0111\u00f3 danh m\u1ee5c th\u1ee9 2 s\u1ebd \u0111\u01b0\u1ee3c ch\u00e8n l\u00ean tr\u00ean). B\u00e2y gi\u1edd ta s\u1ebd thay \u0111\u1ed5i th\u1ee9 t\u1ef1 \u0111i m\u1ed9t ch\u00fat, sao cho danh m\u1ee5c \u201c\u0110i\u1ec3m nhi\u1ec7t th\u1ea5p nh\u1ea5t theo m\u00f9a\u201d (Seasonal Minimum) \u0111\u01b0\u1ee3c x\u1ebfp \u0111\u1ea7u ti\u00ean, sau \u0111\u00f3 s\u1ebd l\u00e0 \u201c\u0110\u1ed9 ch\u00eanh l\u1ec7ch nhi\u1ec7t \u0111\u1ed9 theo m\u00f9a\u201d (Seasonal Range).<\/p>\n<ul style=\"text-align: justify\">\n<li>T\u00ecm \u0111\u1ebfn danh m\u1ee5c Seasonal Minimum, click ch\u1ecdn v\u00e0o n\u00f3 v\u00e0 b\u1ea5m n\u00fat m\u0169i t\u00ean l\u00ean 2 l\u1ea7n. Khi \u0111\u00f3 danh m\u1ee5c n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c \u0111\u01b0a l\u00ean \u0111\u1ea7u, \u0111\u1ed3ng ngh\u0129a v\u1edbi vi\u1ec7c n\u00f3 s\u1ebd \u0111\u01b0\u1ee3c x\u1ebfp th\u1ea5p nh\u1ea5t trong bi\u1ec3u \u0111\u1ed3 v\u00e0 n\u1eb1m g\u1ea7n tr\u1ee5c ho\u00e0nh l\u1eabn s\u1ed1 0 nh\u1ea5t.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9436 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/figure4.png\" width=\"600\" height=\"328\" title=\"figure4\"><\/p>\n<ul style=\"text-align: justify\">\n<li>Ti\u1ebfp theo, ta c\u1ea7n thi\u1ebft l\u1eadp danh m\u1ee5c Seasonal Range n\u1eb1m ngay tr\u00ean Seasonal Minimum. Click ch\u1ecdn v\u00e0o n\u00f3 v\u00e0 di chuy\u1ec3n m\u0169i t\u00ean l\u00ean t\u01b0\u01a1ng t\u1ef1 sao cho n\u00f3 n\u1eb1m ngay d\u01b0\u1edbi Seasonal Minimum trong danh s\u00e1ch.<\/li>\n<\/ul>\n<p><strong>Xem th\u00eam<\/strong>: T\u1ed5ng h\u1ee3p c\u00e1c b\u00e0i vi\u1ebft\u00a0\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">Excel c\u01a1 ba\u0309n<\/a>\u00a0c\u1ef1c hay<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y bi\u1ec3u \u0111\u1ed3 \u0111\u1eb1ng sau c\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i Data Source, n\u00f3 s\u1ebd tr\u00f4ng gi\u1ed1ng nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9437\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/figure5.png\" width=\"600\" height=\"360\" title=\"figure5\"><\/p>\n<p style=\"text-align: justify\">Sau khi b\u1ea1n \u0111\u00e3 ch\u1ed3ng Seasonal Range l\u00ean tr\u00ean Seasonal Minimum trong bi\u1ec3u \u0111\u1ed3, h\u1ec7 qu\u1ea3 l\u00e0 \u0111\u01b0\u1eddng ranh gi\u1edbi ph\u00eda tr\u00ean c\u1ee7a Seasonal Range s\u1ebd bi\u1ec3u th\u1ecb \u201c\u0110i\u1ec3m nhi\u1ec7t cao nh\u1ea5t theo m\u00f9a\u201d (Seasonal Maximum) v\u00ec th\u1ebf n\u00ean ta c\u00f3 th\u1ec3 x\u00f3a b\u1ecf danh m\u1ee5c n\u00e0y \u0111i.<\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn ph\u1ea7n danh m\u1ee5c Seasonal Maximum trong h\u1ed9p tho\u1ea1i Data Source<\/li>\n<li>Click ch\u1ecdn \u201cRemove\u201d (n\u1eb1m ph\u00eda d\u01b0\u1edbi c\u00e1c d\u1ea5u m\u0169i t\u00ean)<\/li>\n<li>Ch\u1ecdn OK<\/li>\n<\/ul>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd bi\u1ec3u \u0111\u1ed3 s\u1ebd c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9438\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/figure6.png\" width=\"600\" height=\"368\" title=\"figure6\"><\/p>\n<p><strong>G\u1ed9p c\u00e1c bi\u1ec3u \u0111\u1ed3 l\u1ea1i v\u1edbi nhau<\/strong><\/p>\n<p>B\u00e2y gi\u1edd s\u1ebd l\u00e0 l\u00fac \u0111\u1ec3 bi\u1ebfn bi\u1ec3u \u0111\u1ed3 n\u00e0y tr\u1edf n\u00ean sinh \u0111\u1ed9ng h\u01a1n. Ta s\u1ebd thay \u0111\u1ed5i 2 danh m\u1ee5c tr\u00ean \u0111\u1ea7u th\u00e0nh c\u00e1c d\u1ea1ng bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng n\u1eb1m xen k\u1ebd \u1edf gi\u1eefa bi\u1ec3u \u0111\u1ed3 mi\u1ec1n.<\/p>\n<ul>\n<li>Click ch\u1ecdn ph\u1ea7n bi\u1ec3u \u0111\u1ed3 mi\u1ec1n c\u1ee7a danh m\u1ee5c \u201cNhi\u1ec7t \u0111\u1ed9 cao nh\u1ea5t theo d\u1ef1 b\u00e1o\u201d (Forecast High)<\/li>\n<li>Click chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn \u201cChange Series Chart Type\u201d<\/li>\n<li>Ch\u1ecdn bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng (bi\u1ec3u \u0111\u1ed3 \u0111\u1ea7u ti\u00ean ph\u00eda tr\u00ean b\u00ean tr\u00e1i)<\/li>\n<li>Ch\u1ecdn OK<\/li>\n<\/ul>\n<p>Bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng \u0111\u00e3 \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp xong. Ti\u1ebfp theo ta l\u00e0m t\u01b0\u01a1ng t\u1ef1 v\u1edbi danh m\u1ee5c \u201cNhi\u1ec7t \u0111\u1ed9 th\u1ea5p nh\u1ea5t theo d\u1ef1 b\u00e1o\u201d (Forecast Low). M\u1ed9t l\u1ea7n n\u1eefa, bi\u1ec3u \u0111\u1ed3 s\u1ebd c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9444\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/figure7.png\" width=\"600\" height=\"366\" title=\"figure7\"><\/p>\n<p>Ti\u1ebfp theo ta c\u1ea7n \u0111\u1ecbnh d\u1ea1ng l\u1ea1i bi\u1ec3u \u0111\u1ed3 m\u1ed9t ch\u00fat<\/p>\n<ul>\n<li>Click chu\u1ed9t ph\u1ea3i v\u00e0o mi\u1ec1n m\u00e0u x\u00e1m \u0111\u1ea1i di\u1ec7n cho m\u1ee5c Seasonal Minimum<\/li>\n<li>Chuy\u1ec3n t\u1eeb m\u00e0u x\u00e1m th\u00e0nh m\u00e0u tr\u1eafng<\/li>\n<\/ul>\n<p>Khi \u0111\u00f3 c\u1ea3m gi\u00e1c ph\u1ea7n d\u1eef li\u1ec7u n\u00e0y s\u1ebd bi\u1ebfn m\u1ea5t. B\u00e2y gi\u1edd ta h\u00e3y x\u00f3a b\u1ecf c\u1ea3 ph\u1ea7n ch\u00fa th\u00edch c\u1ee7a n\u00f3 n\u1eefa:<\/p>\n<ul>\n<li>Click v\u00e0o ph\u1ea7n ch\u00fa th\u00edch<\/li>\n<li>Click ch\u1ecdn v\u00e0o m\u1ee5c Seasonal Minimum<\/li>\n<li>B\u1ea5m Delete<\/li>\n<\/ul>\n<p>\u0110\u1ec3 \u00fd th\u1ea5y r\u1eb1ng tuy ph\u1ea7n mi\u1ec1n m\u00e0u tr\u1eafng v\u1eabn c\u00f2n hi\u1ec7n tr\u00ean bi\u1ec3u \u0111\u1ed3 nh\u01b0ng ph\u1ea7n ch\u00fa th\u00edch c\u1ee7a n\u00f3 \u0111\u00e3 b\u1ecb l\u01b0\u1ee3c b\u1ecf. Ti\u1ebfp \u0111\u1ebfn ta s\u1ebd ch\u1ecdn 1 m\u00e0u d\u1ecbu h\u01a1n cho ph\u1ea7n Seasonal Range c\u0169ng nh\u01b0 thay th\u1ebf m\u00e0u s\u1eafc ph\u00f9 h\u1ee3p cho t\u1eebng bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng c\u1ee7a c\u00e1c chu\u1ed7i d\u1eef li\u1ec7u d\u1ef1 b\u00e1o nhi\u1ec7t nh\u01b0 sau:<\/p>\n<ul>\n<li>Ch\u1ecdn mi\u1ec1n m\u00e0u xanh \u0111en c\u1ee7a m\u1ee5c Seasonal Range v\u00e0 click chu\u1ed9t ph\u1ea3i v\u00e0o n\u00f3<\/li>\n<li>\u1ede h\u1ed9p tho\u1ea1i hi\u1ec7n ra, chuy\u1ec3n sang m\u00e0u xanh l\u00e1 c\u00e2y nh\u1ea1t<\/li>\n<li>Ch\u1ecdn \u0111\u01b0\u1eddng d\u1ef1 b\u00e1o nhi\u1ec7t \u0111\u1ed9 th\u1ea5p nh\u1ea5t (\u0111\u01b0\u1eddng m\u00e0u da cam) v\u00e0 click chu\u1ed9t ph\u1ea3i v\u00e0o<\/li>\n<li>B\u1ea5m ch\u1ecdn m\u0169i t\u00ean x\u1ed5 xu\u1ed1ng b\u00ean c\u1ea1nh l\u1ef1a ch\u1ecdn \u0110\u01b0\u1eddng k\u1ebb vi\u1ec1n cho h\u00ecnh v\u00e0 click ch\u1ecdn v\u00e0o m\u00e0u xanh \u0111en (nh\u01b0 h\u00ecnh d\u01b0\u1edbi):<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9445\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/figure8.png\" width=\"600\" height=\"407\" title=\"figure8\"><\/p>\n<ul>\n<li>L\u00e0m t\u01b0\u01a1ng t\u1ef1 \u0111\u1ed1i v\u1edbi \u0111\u01b0\u1eddng bi\u1ec3u th\u1ecb d\u1ef1 b\u00e1o nhi\u1ec7t \u0111\u1ed9 cao nh\u1ea5t, thay b\u1eb1ng m\u00e0u \u0111\u1ecf. Khi \u0111\u00f3 ta c\u00f3 bi\u1ec3u \u0111\u1ed3 ho\u00e0n ch\u1ec9nh nh\u01b0 sau:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9446\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/figure9.png\" width=\"600\" height=\"368\" title=\"figure9\"><\/p>\n<p><strong>Thu g\u1ecdn bi\u1ec3u \u0111\u1ed3 thuy\u1ebft tr\u00ecnh<\/strong><\/p>\n<p>Tuy \u0111\u1ebfn l\u00fac n\u00e0y bi\u1ec3u \u0111\u1ed3 tr\u1edf n\u00ean kh\u00e1 ho\u00e0n thi\u1ec7n r\u1ed3i nh\u01b0ng ta v\u1eabn c\u00f3 th\u1ec3 l\u00e0m t\u1ed1t h\u01a1n n\u1eefa b\u1eb1ng c\u00e1ch lo\u1ea1i b\u1ecf \u0111i c\u00e1c \u0111\u01b0\u1eddng k\u1ebb ngang kh\u00f4ng c\u1ea7n thi\u1ebft:<\/p>\n<ul>\n<li>Click v\u00e0o bi\u1ec3u \u0111\u1ed3 (\u0111\u1ec3 l\u1ef1a ch\u1ecdn to\u00e0n b\u1ed9)<\/li>\n<li>Sau \u0111\u00f3 click ch\u1ecdn v\u00e0o 1 \u0111\u01b0\u1eddng k\u1ebb ngang b\u1ea5t k\u00ec<\/li>\n<\/ul>\n<p>Khi \u0111\u00f3 s\u1ebd c\u00f3 nh\u1eefng v\u00f2ng tr\u00f2n nh\u1ecf xu\u1ea5t hi\u1ec7n \u1edf cu\u1ed1i m\u1ed7i \u0111\u01b0\u1eddng k\u1ebb ngang, nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9449\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/figure10.png\" width=\"600\" height=\"368\" title=\"figure10\"><\/p>\n<p>B\u1ea5m ph\u00edm Delete v\u00e0 th\u1ebf l\u00e0 xong.<\/p>\n<p>Ti\u1ebfp \u0111\u1ebfn, ta s\u1ebd ch\u1ec9nh s\u1eeda c\u00e1c tr\u1ee5c m\u1ed7i ch\u00fat. Ch\u1ecdn ph\u1ea7n ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c bi\u1ec3u th\u1ecb tr\u00ean tr\u1ee5c ho\u00e0nh, click chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Format Axis:<\/p>\n<ul>\n<li>Trong tab Axis Options, thay \u0111\u1ed5i v\u1ecb tr\u00ed c\u1ee7a tr\u1ee5c th\u00e0nh \u201cOn Tick Marks\u201d thay v\u00ec \u201cBetween Tick Marks\u201d<\/li>\n<li>Chuy\u1ec3n sang tab Number \u1edf b\u00ean tr\u00e1i<\/li>\n<li>B\u1ecf ch\u1ecdn m\u1ee5c \u201cLinked to Source\u201d<\/li>\n<li>\u1ede \u00f4 Format Code, \u0111i\u1ec1n v\u00e0o \u201cm\/dd\u201d<\/li>\n<li>B\u1ea5m Add<\/li>\n<li>\u0110\u00f3ng h\u1ed9p tho\u1ea1i l\u1ea1i<\/li>\n<\/ul>\n<p>G\u1ea7n \u0111\u01b0\u1ee3c r\u1ed3i, d\u01b0\u1edbi \u0111\u00e2y l\u00e0 th\u00e0nh qu\u1ea3 hi\u1ec7n t\u1ea1i:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9450\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/figure11.png\" width=\"600\" height=\"360\" title=\"figure11\"><\/p>\n<p>Cu\u1ed1i c\u00f9ng, ta c\u00f3 th\u1ec3 chuy\u1ec3n ph\u1ea7n ch\u00fa th\u00edch xu\u1ed1ng ph\u00eda d\u01b0\u1edbi, v\u00e0 th\u00eam v\u00e0o 1 ch\u00fat b\u1ed1 c\u1ee5c cho bi\u1ec3u \u0111\u1ed3:<\/p>\n<ul>\n<li>L\u1ef1a ch\u1ecdn bi\u1ec3u \u0111\u1ed3<\/li>\n<li>Ch\u1ecdn Chart Tools -&gt; Layout tab \u2013&gt; Legend \u2013&gt; Show Legend at Bottom<\/li>\n<li>Ch\u1ecdn Chart Tools \u2013&gt; Axis titles \u2013&gt; Primary Vertical Axis Title \u2013&gt; Rotated Title<\/li>\n<li>Click v\u00e0o \u00f4 c\u00f4ng th\u1ee9c v\u00e0 \u0111i\u1ec1n \u201cTemperature (Celsius)\u201d, sau \u0111\u00f3 b\u1ea5m Enter<\/li>\n<li>Quay l\u1ea1i ph\u1ea7n Chart Tools \u2013&gt; Chart Title \u2013&gt; Above Chart<\/li>\n<li>\u0110i\u1ec1n v\u00e0o thanh c\u00f4ng th\u1ee9c: \u201cTemperature Forecast\u201d<\/li>\n<li>Click chu\u1ed9t ph\u1ea3i v\u00e0o danh m\u1ee5c \u201cForecasted High\u201d , ch\u1ecdn Format Data Series \u2013&gt; Line Style \u2013&gt; Smoothed Line<\/li>\n<li>L\u00e0m t\u01b0\u01a1ng t\u1ef1 \u0111\u1ed1i v\u1edbi danh m\u1ee5c \u201cForecasted Low\u201d<\/li>\n<\/ul>\n<p>Ta c\u00f3 bi\u1ec3u \u0111\u1ed3 ho\u00e0n ch\u1ec9nh nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9451\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/figure1-1.png\" width=\"600\" height=\"360\" title=\"figure1-1\"><\/p>\n<blockquote>\n<p>T\u00ecm hi\u1ec3u ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">Excel k\u1ebf to\u00e1n<\/a><\/p>\n<\/blockquote>\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-243.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10929,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10928","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\/10928","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=10928"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10928\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10929"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10928"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10928"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}