{"id":6214,"date":"2024-12-21T14:12:01","date_gmt":"2024-12-21T14:12:01","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/tao-mot-bieu-do-trong-excel-tu-hai-hoac-nhieu-trang-khac-nhau\/"},"modified":"2024-12-21T14:12:01","modified_gmt":"2024-12-21T14:12:01","slug":"tao-mot-bieu-do-trong-excel-tu-hai-hoac-nhieu-trang-khac-nhau","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/tao-mot-bieu-do-trong-excel-tu-hai-hoac-nhieu-trang-khac-nhau\/","title":{"rendered":"T\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 trong Excel t\u1eeb hai ho\u1eb7c nhi\u1ec1u trang kh\u00e1c nhau"},"content":{"rendered":"
\n

Khi t\u1ea1o bi\u1ec3u \u0111\u1ed3 trong Excel, d\u1eef li\u1ec7u ngu\u1ed3n kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng n\u1eb1m tr\u00ean c\u00f9ng m\u1ed9t trang t\u00ednh. May m\u1eafn l\u00e0 Microsoft Excel cho ph\u00e9p v\u1ebd bi\u1ec3u \u0111\u1ed3 t\u1eeb d\u1eef li\u1ec7u trong hai ho\u1eb7c nhi\u1ec1u b\u1ea3ng t\u00ednh kh\u00e1c nhau. Gi\u1edd \u0111\u00e2y H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 trong Excel t\u1eeb nhi\u1ec1u ngu\u1ed3n.\u00a0<\/em><\/p>\n

L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 t\u1eeb nhi\u1ec1u trang t\u00ednh trong Excel<\/strong><\/p>\n

Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 v\u00e0i b\u1ea3ng t\u00ednh v\u1edbi d\u1eef li\u1ec7u doanh thu trong nh\u1eefng n\u0103m kh\u00e1c nhau v\u00e0 b\u1ea1n mu\u1ed1n t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 d\u1ef1a tr\u00ean nh\u1eefng d\u1eef li\u1ec7u \u0111\u00f3 \u0111\u1ec3 h\u00ecnh dung xu h\u01b0\u1edbng chung.<\/p>\n

    \n
  1. T\u1ea1o bi\u1ec3u \u0111\u1ed3 d\u1ef1a tr\u00ean trang \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea1n.<\/strong><\/li>\n<\/ol>\n

    \u0110\u1ec3 v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel<\/strong><\/a> tr\u01b0\u1edbc ti\u00ean b\u1ea1n h\u00e3y m\u1edf b\u1ea3ng t\u00ednh Excel \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea1n, ch\u1ecdn d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n v\u1ebd trong bi\u1ec3u \u0111\u1ed3, v\u00e0o tab Insert\u00a0 >\u00a0Charts<\/em><\/strong>\u00a0<\/em>, ch\u1ecdn lo\u1ea1i bi\u1ec3u \u0111\u1ed3 b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n.\u00a0Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta s\u1ebd t\u1ea1o bi\u1ec3u \u0111\u1ed3 Stack Column<\/em><\/strong>:<\/p>\n

    \"Creating<\/p>\n

      \n
    1. Th\u00eam d\u1eef li\u1ec7u th\u1ee9 hai t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c.<\/strong><\/li>\n<\/ol>\n

      Nh\u1ea5p v\u00e0o bi\u1ec3u \u0111\u1ed3 b\u1ea1n v\u1eeba t\u1ea1o \u0111\u1ec3 k\u00edch ho\u1ea1t\u00a0tab\u00a0Chart Tools<\/em><\/strong> tr\u00ean thanh c\u00f4ng c\u1ee5 c\u1ee7a Excel, v\u00e0o\u00a0tab\u00a0Design\u00a0<\/em><\/strong>v\u00e0 nh\u1ea5p v\u00e0o n\u00fat\u00a0Select Data<\/em><\/strong>.<\/p>\n

      Ho\u1eb7c nh\u1ea5p v\u00e0o\u00a0\u00a0n\u00fat \u00a0Chart Filters<\/em><\/strong>\u00a0 \u00a0\u1edf b\u00ean ph\u1ea3i bi\u1ec3u \u0111\u1ed3, sau \u0111\u00f3 nh\u1ea5p v\u00e0o\u00a0li\u00ean k\u1ebft\u00a0Select Data\u2026<\/em><\/strong> \u1edf cu\u1ed1i.<\/p>\n

      Trong\u00a0c\u1eeda s\u1ed5\u00a0Select Data Sourceu<\/em><\/strong>\u00a0, nh\u1ea5p\u00a0v\u00e0o<\/em>\u00a0n\u00fat\u00a0Add<\/em><\/strong>.<\/p>\n

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

      \"Click<\/p>\n

      B\u00e2y gi\u1edd ch\u00fang ta s\u1ebd th\u00eam\u00a0chu\u1ed7i d\u1eef li\u1ec7u th\u1ee9 hai<\/strong>\u00a0d\u1ef1a tr\u00ean d\u1eef li\u1ec7u n\u1eb1m tr\u00ean m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c.\u00a0\u0110\u00e2y l\u00e0 ph\u1ea7n ch\u00ednh, v\u00ec v\u1eady h\u00e3y \u0111\u1ea3m b\u1ea3o th\u1ef1c hi\u1ec7n \u0111\u00fang theo c\u00e1c h\u01b0\u1edbng d\u1eabn.<\/p>\n

      Nh\u1ea5p\u00a0v\u00e0o<\/em>\u00a0n\u00fat\u00a0Add<\/em><\/strong>\u00a0<\/em>\u0111\u1ec3 m\u1edf\u00a0h\u1ed9p tho\u1ea1i\u00a0Edit Series<\/em><\/strong>, nh\u1ea5p v\u00e0o n\u00fat\u00a0CollapseDialog<\/em><\/strong>\u00a0b\u00ean c\u1ea1nh\u00a0Series values\u00a0<\/strong>\u00a0.<\/p>\n

      \"Click<\/p>\n

      H\u1ed9p tho\u1ea1i\u00a0Edit Series<\/em><\/strong>\u00a0s\u1ebd thu g\u1ecdn l\u1ef1a ch\u1ecdn l\u1ea1i.\u00a0Nh\u1ea5p v\u00e0o tab c\u1ee7a b\u1ea3ng c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u kh\u00e1c b\u1ea1n mu\u1ed1n \u0111\u01b0a v\u00e0o bi\u1ec3u \u0111\u1ed3 Excel (c\u1eeda s\u1ed5\u00a0\u00a0Edit Series<\/strong>\u00a0<\/em>\u00a0s\u1ebd v\u1eabn hi\u1ec3n th\u1ecb tr\u00ean m\u00e0n h\u00ecnh khi b\u1ea1n di chuy\u1ec3n gi\u1eefa c\u00e1c trang t\u00ednh).<\/p>\n

      Tr\u00ean b\u1ea3ng t\u00ednh th\u1ee9 hai, ch\u1ecdn m\u1ed9t c\u1ed9t ho\u1eb7c m\u1ed9t d\u00e3y d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n th\u00eam v\u00e0o bi\u1ec3u \u0111\u1ed3 Excel, nh\u1ea5p v\u00e0o\u00a0bi\u1ec3u t\u01b0\u1ee3ng\u00a0Expand Dialog<\/em><\/strong>\u00a0<\/em>\u00a0\u0111\u1ec3 tr\u1edf v\u1ec1\u00a0c\u1eeda s\u1ed5\u00a0Edit Series<\/em><\/strong> v\u1edbi k\u00edch th\u01b0\u1edbc \u0111\u1ea7y \u0111\u1ee7\u00a0.<\/p>\n

      \"Select<\/p>\n

      V\u00e0 b\u00e2y gi\u1edd, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat\u00a0Collapse Dialog<\/em><\/strong> \u1edf b\u00ean ph\u1ea3i c\u1ee7a Series name<\/strong>\u00a0v\u00e0 ch\u1ecdn m\u1ed9t \u00f4 ch\u1ee9a v\u0103n b\u1ea3n b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng cho t\u00ean chu\u1ed7i.\u00a0Nh\u1ea5p v\u00e0o\u00a0Expand Dialog<\/em><\/strong> \u0111\u1ec3 tr\u1edf l\u1ea1i\u00a0c\u1eeda s\u1ed5\u00a0Edit Series<\/em><\/strong>.<\/p>\n

      \u0110\u1ea3m b\u1ea3o c\u00e1c tham chi\u1ebfu trong\u00a0h\u1ed9p\u00a0Series name<\/em><\/strong>\u00a0<\/em>v\u00e0\u00a0Series value<\/strong><\/em> ch\u00ednh x\u00e1c, nh\u1ea5n OK<\/em>\u00a0.
      \n\"Add<\/p>\n

      Nh\u01b0 v\u1eady, ch\u00fang ta \u0111\u00e3 li\u00ean k\u1ebft series name t\u1edbi \u00f4 B1, \u0111\u00f3 l\u00e0 t\u00ean c\u1ed9t.\u00a0Thay v\u00ec t\u00ean c\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp t\u00ean chu\u1ed7i c\u1ee7a ri\u00eang b\u1ea1n trong d\u1ea5u ngo\u1eb7c k\u00e9p, v\u00ed d\u1ee5: =\u201dSecond data series<\/em>\u201c.<\/p>\n

      Series name s\u1ebd xu\u1ea5t hi\u1ec7n trong ch\u00fa th\u00edch c\u1ee7a bi\u1ec3u \u0111\u1ed3, v\u00ec v\u1eady b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n \u0111\u01b0a ra m\u1ed9t s\u1ed1 t\u00ean c\u00f3 \u00fd ngh\u0129a v\u00e0 mang t\u00ednh m\u00f4 t\u1ea3 cho d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.<\/p>\n

      L\u00fac n\u00e0y, k\u1ebft qu\u1ea3 s\u1ebd tr\u00f4ng gi\u1ed1ng nh\u01b0 sau:<\/p>\n

      \"The<\/p>\n

        \n
      1. Th\u00eam nhi\u1ec1u series name (t\u00f9y ch\u1ecdn)<\/strong><\/li>\n<\/ol>\n

        N\u1ebfu b\u1ea1n mu\u1ed1n v\u1ebd bi\u1ec3u \u0111\u1ed3 t\u1eeb nhi\u1ec1u trang t\u00ednh, h\u00e3y l\u1eb7p l\u1ea1i quy tr\u00ecnh \u0111\u01b0\u1ee3c m\u00f4 t\u1ea3 trong b\u01b0\u1edbc 2 cho m\u1ed7i chu\u1ed7i d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n th\u00eam v\u00e0o.\u00a0Khi ho\u00e0n t\u1ea5t, nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0OK<\/em>\u00a0tr\u00ean\u00a0h\u1ed9p tho\u1ea1i\u00a0Select Data Source<\/em><\/strong>.<\/p>\n

        Trong v\u00ed d\u1ee5 n\u00e0y, t\u00f4i \u0111\u00e3 th\u00eam\u00a0chu\u1ed7i d\u1eef li\u1ec7u th\u1ee9 3, d\u01b0\u1edbi \u0111\u00e2y bi\u1ec3u \u0111\u1ed3 Excel c\u1ee7a t\u00f4i:<\/p>\n

        \"An<\/p>\n

          \n
        1. T\u00f9y ch\u1ec9nh v\u00e0 c\u1ea3i ti\u1ebfn bi\u1ec3u \u0111\u1ed3 (t\u00f9y ch\u1ecdn)<\/strong><\/li>\n<\/ol>\n

          Khi t\u1ea1o bi\u1ec3u \u0111\u1ed3 trong Excel 2013 v\u00e0 2016, th\u00f4ng th\u01b0\u1eddng c\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a bi\u1ec3u \u0111\u1ed3 nh\u01b0 ti\u00eau \u0111\u1ec1 v\u00e0 ch\u00fa th\u00edch \u0111\u01b0\u1ee3c Excel t\u1ef1 \u0111\u1ed9ng th\u00eam.\u00a0\u0110\u1ed1i v\u1edbi bi\u1ec3u \u0111\u1ed3 do d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u b\u1ea3ng, ti\u00eau \u0111\u1ec1 v\u00e0 ch\u00fa th\u00edch kh\u00f4ng \u0111\u01b0\u1ee3c th\u00eam m\u1eb7c \u0111\u1ecbnh, nh\u01b0ng ch\u00fang ta c\u00f3 th\u1ec3 kh\u1eafc ph\u1ee5c \u0111i\u1ec1u n\u00e0y.<\/p>\n

          Ch\u1ecdn \u0111\u1ed3 th\u1ecb c\u1ee7a b\u1ea1n, nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0Chart Elements<\/em><\/strong>\u00a0(d\u1ea5u c\u1ed9ng xanh) \u1edf g\u00f3c tr\u00ean b\u00ean ph\u1ea3i v\u00e0 ch\u1ecdn c\u00e1c t\u00f9y ch\u1ecdn b\u1ea1n mu\u1ed1n:<\/p>\n

          \"Adding<\/p>\n

          L\u1eadp bi\u1ec3u \u0111\u1ed3 t\u1eeb b\u1ea3ng t\u1ed5ng h\u1ee3p<\/strong><\/p>\n

          Gi\u1ea3i ph\u00e1p \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y \u1edf tr\u00ean ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng n\u1ebfu m\u1ee5c nh\u1eadp c\u1ee7a b\u1ea1n xu\u1ea5t hi\u1ec7n theo\u00a0c\u00f9ng th\u1ee9 t\u1ef1<\/strong>\u00a0trong t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng t\u00ednh. N\u1ebfu kh\u00f4ng, bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n s\u1ebd b\u1ecb r\u1ed1i tung.<\/p>\n

          Trong v\u00ed d\u1ee5 n\u00e0y, th\u1ee9 t\u1ef1 c\u00e1c m\u1ee5c (Oranges,\u00a0Apples,\u00a0Lemons, Grapes)<\/em> gi\u1ed1ng h\u1ec7t nhau trong c\u1ea3 3 trang.\u00a0N\u1ebfu b\u1ea1n \u0111ang t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 t\u1eeb c\u00e1c b\u1ea3ng t\u00ednh l\u1edbn v\u00e0 b\u1ea1n kh\u00f4ng ch\u1eafc ch\u1eafn v\u1ec1 th\u1ee9 t\u1ef1 c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c m\u1ee5c, b\u1ea1n c\u1ea7n t\u1ea1o ra m\u1ed9t\u00a0b\u1ea3ng t\u00f3m t\u1eaft<\/strong>, sau \u0111\u00f3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 t\u1eeb b\u1ea3ng \u0111\u00f3.\u00a0\u0110\u1ec3 k\u00e9o d\u1eef li\u1ec7u ph\u00f9 h\u1ee3p \u0111\u1ebfn m\u1ed9t b\u1ea3ng t\u00f3m t\u1eaft, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng\u00a0h\u00e0m VLOOKUP<\/em><\/strong>\u00a0ho\u1eb7c\u00a0Merge Tables Wizard<\/em><\/strong>.<\/p>\n

          V\u00ed d\u1ee5, n\u1ebfu c\u00e1c b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c \u0111\u1ec1 c\u1eadp trong v\u00ed d\u1ee5 n\u00e0y c\u00f3 th\u1ee9 t\u1ef1 c\u00e1c m\u1ee5c kh\u00e1c nhau, ch\u00fang ta c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t b\u1ea3ng t\u00f3m t\u1eaft b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n

          =VLOOKUP(A3,\u20192014\u2032!$A$2:$B$5, 2,FALSE)<\/strong><\/p>\n

          V\u00e0 c\u00f3 k\u1ebft qu\u1ea3 sau:<\/p>\n

          \"Creating<\/p>\n

          V\u00e0 sau \u0111\u00f3, ch\u1ec9 c\u1ea7n ch\u1ecdn b\u1ea3ng t\u00f3m t\u1eaft, \u0111i t\u1edbi\u00a0tab\u00a0Insert<\/em><\/strong>\u00a0>\u00a0Chart groups<\/em><\/strong>\u00a0v\u00e0 ch\u1ecdn lo\u1ea1i bi\u1ec3u \u0111\u1ed3 b\u1ea1n mu\u1ed1n.<\/p>\n

          S\u1eeda \u0111\u1ed5i bi\u1ec3u \u0111\u1ed3 Excel \u0111\u01b0\u1ee3c t\u1ea1o t\u1eeb nhi\u1ec1u trang t\u00ednh<\/strong><\/p>\n

          Sau khi t\u1ea1o m\u1ed9t bi\u1ec3u \u0111\u1ed3 d\u1ef1a tr\u00ean d\u1eef li\u1ec7u t\u1eeb hai ho\u1eb7c nhi\u1ec1u trang, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n n\u00f3 \u0111\u01b0\u1ee3c v\u1ebd theo c\u00e1ch kh\u00e1c nhau.\u00a0V\u00e0 b\u1edfi v\u00ec vi\u1ec7c t\u1ea1o c\u00e1c bi\u1ec3u \u0111\u1ed3 nh\u01b0 v\u1eady t\u1ed1n nhi\u1ec1u th\u1eddi gian h\u01a1n t\u1ea1o m\u1ed9t \u0111\u1ed3 th\u1ecb t\u1eeb m\u1ed9t trang t\u00ednh trong Excel, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n ch\u1ec9nh s\u1eeda bi\u1ec3u \u0111\u1ed3 hi\u1ec7n t\u1ea1i thay v\u00ec t\u1ea1o bi\u1ec3u \u0111\u1ed3 m\u1edbi t\u1eeb \u0111\u1ea7u.<\/p>\n

          N\u00f3i chung, tu\u1ef3 ch\u1ec9nh cho c\u00e1c bi\u1ec3u \u0111\u1ed3 Excel d\u1ef1a tr\u00ean nhi\u1ec1u trang c\u0169ng gi\u1ed1ng nh\u01b0 \u0111\u1ed1i v\u1edbi c\u00e1c bi\u1ec3u \u0111\u1ed3 Excel th\u00f4ng th\u01b0\u1eddng.\u00a0B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c\u00a0tab\u00a0Charts Tools<\/em><\/strong>\u00a0tr\u00ean thanh c\u00f4ng c\u1ee5 ho\u1eb7c nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o danh s\u00e1ch t\u00f9y ch\u1ecdn ho\u1eb7c c\u00e1c n\u00fat t\u00f9y ch\u1ec9nh bi\u1ec3u \u0111\u1ed3 \u1edf g\u00f3c tr\u00ean c\u00f9ng b\u00ean ph\u1ea3i c\u1ee7a bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 thay \u0111\u1ed5i c\u00e1c y\u1ebfu t\u1ed1 bi\u1ec3u \u0111\u1ed3 c\u01a1 b\u1ea3n nh\u01b0 ti\u00eau \u0111\u1ec1 bi\u1ec3u \u0111\u1ed3, ti\u00eau \u0111\u1ec1 tr\u1ee5c, ch\u00fa th\u00edch c\u1ee7a bi\u1ec3u \u0111\u1ed3, c\u00e1c ki\u1ec3u bi\u1ec3u \u0111\u1ed3 v\u00e0 h\u01a1n.<\/p>\n

          Ch\u1ec9nh s\u1eeda data series b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u1ed9p tho\u1ea1i Select Data Source\u00a0<\/strong><\/p>\n

          M\u1edf\u00a0h\u1ed9p tho\u1ea1i\u00a0Select Data Source\u00a0<\/em><\/strong> (\u00a0tab\u00a0Design>\u00a0Select Data<\/em><\/strong>).<\/p>\n

          \u0110\u1ec3\u00a0thay \u0111\u1ed5i data series<\/strong>, h\u00e3y nh\u1ea5p chu\u1ed9t v\u00e0o n\u00f3, sau \u0111\u00f3 nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0Edit\u00a0<\/strong>v\u00e0 s\u1eeda \u0111\u1ed5i\u00a0Series Name\u00a0or\u00a0Series Values<\/em><\/strong>\u00a0<\/em>nh\u01b0 ch\u00fang ta \u0111\u00e3 l\u00e0m khi\u00a0th\u00eam m\u1ed9t chu\u1ed7i d\u1eef li\u1ec7u v\u00e0o bi\u1ec3u \u0111\u1ed3\u00a0.<\/p>\n

          \u0110\u1ec3 thay \u0111\u1ed5i\u00a0th\u1ee9 t\u1ef1 c\u1ee7a chu\u1ed7i<\/strong>\u00a0trong bi\u1ec3u \u0111\u1ed3, h\u00e3y ch\u1ecdn m\u1ed9t chu\u1ed7i v\u00e0 s\u1eed d\u1ee5ng c\u00e1c m\u0169i t\u00ean l\u00ean v\u00e0 xu\u1ed1ng \u0111\u1ec3 di chuy\u1ec3n chu\u1ed7i \u0111\u00f3 l\u00ean ho\u1eb7c xu\u1ed1ng.<\/p>\n

          \"Editing<\/p>\n

          \u0110\u1ec3\u00a0\u1ea9n data series<\/strong>, b\u1ea1n ch\u1ec9 c\u1ea7n b\u1ecf ch\u1ecdn n\u00f3 trong\u00a0danh s\u00e1ch\u00a0Legend Entries (Series)<\/em><\/strong>\u00a0\u1edf ph\u00eda b\u00ean tay tr\u00e1i c\u1ee7a\u00a0h\u1ed9p tho\u1ea1i\u00a0Select Data Source<\/em><\/strong>.<\/p>\n

          \u0110\u1ec3\u00a0x\u00f3a\u00a0<\/strong>m\u1ed9t chu\u1ed7i d\u1eef li\u1ec7u nh\u1ea5t \u0111\u1ecbnh kh\u1ecfi bi\u1ec3u \u0111\u1ed3 v\u0129nh vi\u1ec5n, h\u00e3y ch\u1ecdn chu\u1ed7i \u0111\u00f3 v\u00e0 nh\u1ea5p v\u00e0o n\u00fat\u00a0Remove\u00a0<\/strong>ph\u00eda d\u01b0\u1edbi.<\/p>\n

          \u1ea8n ho\u1eb7c hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng n\u00fat Chart Filters<\/strong><\/p>\n

          M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 qu\u1ea3n l\u00fd chu\u1ed7i d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong bi\u1ec3u \u0111\u1ed3 Excel c\u1ee7a b\u1ea1n l\u00e0 s\u1eed d\u1ee5ng\u00a0n\u00fat Chart Filters<\/strong> \u00a0.\u00a0N\u00fat n\u00e0y xu\u1ea5t hi\u1ec7n \u1edf b\u00ean ph\u1ea3i bi\u1ec3u \u0111\u1ed3 c\u1ee7a b\u1ea1n ngay khi b\u1ea1n nh\u1ea5p v\u00e0o n\u00f3.<\/p>\n

          \u0110\u1ec3\u00a0\u1ea9n d\u1eef li\u1ec7u nh\u1ea5t \u0111\u1ecbnh<\/strong>\u00a0, h\u00e3y nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0Chart Filters<\/em><\/strong>\u00a0<\/em>\u00a0v\u00e0 b\u1ecf ch\u1ecdn chu\u1ed7i d\u1eef li\u1ec7u ho\u1eb7c danh m\u1ee5c t\u01b0\u01a1ng \u1ee9ng.<\/p>\n

          \u0110\u1ec3\u00a0ch\u1ec9nh s\u1eeda chu\u1ed7i d\u1eef li\u1ec7u<\/strong>\u00a0, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat\u00a0Edit Series<\/em><\/strong>\u00a0\u1edf b\u00ean ph\u1ea3i t\u00ean chu\u1ed7i.\u00a0C\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i\u00a0Select Data Source<\/em><\/strong>\u00a0s\u1ebd xu\u1ea5t hi\u1ec7n v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n nh\u1eefng thay \u0111\u1ed5i c\u1ea7n thi\u1ebft \u1edf \u0111\u00f3.\u00a0\u0110\u1ec3 n\u00fat\u00a0Edit Series<\/em><\/strong> xu\u1ea5t hi\u1ec7n, b\u1ea1n ch\u1ec9 c\u1ea7n di chu\u1ed9t qua t\u00ean h\u00e0ng b\u1eb1ng chu\u1ed9t.\u00a0Ngay khi b\u1ea1n th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y, chu\u1ed7i t\u01b0\u01a1ng \u1ee9ng s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u tr\u00ean bi\u1ec3u \u0111\u1ed3, v\u00ec v\u1eady b\u1ea1n s\u1ebd th\u1ea5y ch\u00ednh x\u00e1c ph\u1ea7n n\u00e0o s\u1ebd thay \u0111\u1ed5i.<\/p>\n

          \"EditingCh\u1ec9nh s\u1eeda chu\u1ed7i d\u1eef li\u1ec7u b\u1eb1ng c\u00f4ng th\u1ee9c<\/strong><\/p>\n

          M\u1ed7i chu\u1ed7i d\u1eef li\u1ec7u trong bi\u1ec3u \u0111\u1ed3 Excel \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1edfi c\u00f4ng th\u1ee9c.\u00a0V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n ch\u1ecdn m\u1ed9t trong c\u00e1c chu\u1ed7i trong bi\u1ec3u \u0111\u1ed3 m\u00e0 ch\u00fang ta \u0111\u00e3 t\u1ea1o ra v\u1eeba n\u00e3y, c\u00f4ng th\u1ee9c chu\u1ed7i s\u1ebd tr\u00f4ng nh\u01b0 sau:<\/p>\n

          =SERIES(\u20182013\u2032!$B$1,\u20192013\u2032!$A$2:$A$5,\u20192013\u2019!$B$2:$B$5,1)<\/strong>
          \n\"TheM\u1ed7i c\u00f4ng th\u1ee9c h\u00e0ng data series c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c chia th\u00e0nh b\u1ed1n ph\u1ea7n c\u01a1 b\u1ea3n:<\/p>\n

          =SERIES([Series Name], [X Values], [Y Values], [Plot Order])<\/strong><\/p>\n

          V\u00ec v\u1eady, c\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang ta c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c gi\u1ea3i th\u00edch theo c\u00e1ch sau:<\/p>\n