{"id":27726,"date":"2021-07-27T13:39:28","date_gmt":"2021-07-27T06:39:28","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=27726"},"modified":"2021-11-12T16:15:54","modified_gmt":"2021-11-12T09:15:54","slug":"cach-ve-bieu-do-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/cach-ve-bieu-do-trong-excel\/","title":{"rendered":"C\u00e1ch V\u1ebd Bi\u1ec3u \u0110\u1ed3 Trong Excel \u0110\u1eb9p v\u00e0 \u0110\u01a1n Gi\u1ea3n Nh\u1ea5t 2021"},"content":{"rendered":"

N\u1ebfu b\u1ea1n l\u00e0 d\u00e2n v\u0103n ph\u00f2ng v\u00e0 th\u01b0\u1eddng xuy\u00ean ph\u1ea3i s\u1eed d\u1ee5ng \u0111\u1ebfn c\u00e1c c\u00f4ng c\u1ee5 so\u1ea1n th\u1ea3o v\u0103n b\u1ea3n th\u00ec c\u00f3 l\u1ebd kh\u00f4ng \u00edt l\u1ea7n ph\u1ea3i th\u1ef1c hi\u1ec7n thao t\u00e1c v\u1ebd bi\u1ec3u \u0111\u1ed3. \u0110\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi m\u1edbi ti\u1ebfp c\u1eadn \u0111\u1ebfn Word, PowerPoint hay Excel th\u00ec vi\u1ec7c v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u00f2n kh\u00f3 kh\u0103n. \u1ede b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Ben Computer s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel<\/a><\/strong><\/span> (2010, 2016,….).<\/p>\n

H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel c\u01a1 b\u1ea3n\u00a0<\/strong><\/span><\/h2>\n

Trong ph\u1ea7n m\u1ec1m Excel c\u00f3 nhi\u1ec1u lo\u1ea1i bi\u1ec3u \u0111\u1ed3 kh\u00e1c nhau, t\u00f9y theo m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng c\u1ee7a m\u1ed7i ng\u01b0\u1eddi s\u1ebd l\u1ef1a ch\u1ecdn lo\u1ea1i bi\u1ec3u \u0111\u1ed3 ph\u00f9 h\u1ee3p. Nh\u1eefng bi\u1ec3u \u0111\u1ed3 c\u01a1 b\u1ea3n th\u01b0\u1eddng d\u00f9ng c\u00f3 th\u1ec3 k\u1ec3 \u0111\u1ebfn: Column, Line, Pie, Bar, Area,…<\/p>\n

\u0110\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3, c\u00e1c b\u1ea1n l\u00e0m theo c\u00e1c b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n sau \u0111\u00e2y:<\/p>\n

    \n
  1. \n
      \n
    1. \u0110\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 b\u1ea1n c\u1ea7n c\u00f3 s\u1eb5n m\u1ed9t b\u1ea3ng th\u1ed1ng k\u00ea s\u1ed1 li\u1ec7u, nh\u1eadp b\u1ea3ng s\u1ed1 li\u1ec7u v\u00e0o b\u1ea3ng Excel.<\/li>\n
    2. B\u00f4i \u0111en b\u1ea3ng s\u1ed1 li\u1ec7u =><\/strong> tr\u00ean thanh menu, ch\u1ecdn Insert =>\u00a0<\/strong>b\u00ean d\u01b0\u1edbi xu\u1ea5t hi\u1ec7n khung Chart => <\/strong>ch\u1ecdn m\u0169i t\u00ean m\u1edf r\u1ed9ng g\u00f3c ph\u1ea3i khung => <\/strong>Khung Insert Chart <\/strong>hi\u1ec7n ra.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

      Ch\u1ecdn bi\u1ec3u \u0111\u1ed3 ph\u00f9 h\u1ee3p theo t\u1eebng lo\u1ea1i bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea trong khung v\u1edbi h\u00ecnh d\u1ea1ng m\u1eabu. \u1ede \u0111\u00e2y c\u00f3 r\u1ea5t nhi\u1ec1u d\u1ea1ng bi\u1ec3u \u0111\u1ed3 \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn nh\u01b0: bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n, h\u00ecnh c\u1ed9t, bi\u1ec3u \u0111\u1ed3 ngang,….<\/p>\n

      \"C\u00e1ch<\/p>\n

      S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 t\u1ea1o bi\u1ec3u \u0111\u1ed3 trong Excel \u0111\u01a1n gi\u1ea3n d\u00e0nh cho d\u00e2n v\u0103n ph\u00f2ng<\/em><\/p>\n

      1. C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel<\/strong><\/h3>\n

      \u0110\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t tr\u00ean Excel, b\u1ea1n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

      B\u01b0\u1edbc 1:<\/strong> B\u00f4i \u0111en v\u00e0 ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n t\u1ea1o.<\/p>\n

      B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn th\u1ebb Insert tr\u00ean thanh c\u00f4ng c\u1ee5 => Ch\u1ecdn Chart => Ch\u1ecdn bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t<\/p>\n

      B\u01b0\u1edbc 3:<\/strong> B\u1ea1n \u0111\u1eb7t t\u00ean cho bi\u1ec3u \u0111\u1ed3 b\u1eb1ng c\u00e1ch nh\u1ea5n v\u00e0o Chart Title<\/strong> v\u00e0 nh\u1eadp t\u00ean mu\u1ed1n \u0111\u1eb7t.<\/p>\n

      \"C\u00e1ch
      Bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel<\/figcaption><\/figure>\n

      2. C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng trong Excel\u00a0<\/strong><\/h3>\n

      \u0110\u1ec3 v\u1ebd bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng tr\u00ean c\u00f4ng c\u1ee5 Excel b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau \u0111\u00e2y: Ch\u1ecdn Design<\/strong> tr\u00ean thanh c\u00f4ng c\u1ee5\u00a0 => Ch\u1ecdn Change Chart Type <\/strong>=> Ch\u1ecdn Line <\/strong>tr\u00ean danh m\u1ee5c bi\u1ec3u \u0111\u1ed3 hi\u1ec3n th\u1ecb => Ch\u1ecdn lo\u1ea1i bi\u1ec3u \u0111\u1ed3 m\u00e0 b\u1ea1n mu\u1ed1n t\u1ea1o => nh\u1ea5n Enter <\/strong>v\u00e0 OK.\u00a0<\/strong><\/p>\n

      \"C\u00e1ch
      Bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng trong Excel<\/figcaption><\/figure>\n

      3. C\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 mi\u1ec1n tr\u00ean Excel<\/strong><\/h3>\n

      \u0110\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 mi\u1ec1n, b\u1ea1n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau: Ch\u1ecdn Insert => Ch\u1ecdn\u00a0Recommended Charts<\/strong> => Ch\u1ecdn All Charts => <\/strong>Ch\u1ecdn\u00a0bi\u1ec3u \u0111\u1ed3 mi\u1ec1n<\/strong> => Ch\u1ecdn ph\u00e2n lo\u1ea1i bi\u1ec3u \u0111\u1ed3 mi\u1ec1n <\/strong>=> Ch\u1ecdn lo\u1ea1i bi\u1ec3u \u0111\u1ed3 b\u1ea1n mu\u1ed1n t\u1ea1o => Nh\u1ea5n OK.\u00a0<\/strong><\/p>\n

      \"C\u00e1ch
      Bi\u1ec3u \u0111\u1ed3 mi\u1ec1n trong Excel<\/figcaption><\/figure>\n

      4. C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 tr\u00f2n trong Excel\u00a0<\/strong><\/h3>\n

      \u0110\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 tr\u00f2n tr\u00ean Excel, b\u1ea1n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc: Ch\u1ecdn Insert<\/strong> => Ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n trong m\u1ee5c Chart<\/strong> => Ch\u1ecdn lo\u1ea1i bi\u1ec3u \u0111\u1ed3 m\u00e0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb => Nh\u1ea5n OK.<\/strong><\/p>\n

      \"C\u00e1ch
      Bi\u1ec3u \u0111\u1ed3 tr\u00f2n trong Excel<\/figcaption><\/figure>\n

      B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Random trong Excel<\/a><\/strong><\/span><\/p><\/blockquote>\n

      C\u00e1ch ch\u1ec9nh s\u1eeda bi\u1ec3u \u0111\u1ed3 trong ph\u1ea7n m\u1ec1m Excel<\/strong><\/h2>\n

      Sau khi ch\u00e8n bi\u1ec3u \u0111\u1ed3 th\u00e0nh c\u00f4ng, bi\u1ec3u \u0111\u1ed3 v\u1eabn ch\u01b0a th\u1ef1c s\u1ef1 ho\u00e0n h\u1ea3o m\u00e0 c\u1ea7n ch\u1ec9nh s\u1eeda th\u00eam, sau \u0111\u00e2y l\u00e0 nh\u1eefng b\u01b0\u1edbc ch\u1ec9nh s\u1eeda c\u01a1 b\u1ea3n m\u00e0 m\u1ecdi ng\u01b0\u1eddi th\u01b0\u1eddng quan t\u00e2m \u0111\u1ebfn:<\/p>\n