{"id":11692,"date":"2025-01-15T04:51:22","date_gmt":"2025-01-15T04:51:22","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-tao-bieu-do-chung-khoan-trong-excel\/"},"modified":"2025-01-15T04:51:22","modified_gmt":"2025-01-15T04:51:22","slug":"cach-tao-bieu-do-chung-khoan-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-tao-bieu-do-chung-khoan-trong-excel\/","title":{"rendered":"C\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 ch\u1ee9ng kho\u00e1n trong Excel"},"content":{"rendered":"
\n

<\/h2>\n

Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 ch\u1ee9ng kho\u00e1n bi\u1ec3u th\u1ecb \u0111\u01b0\u1ee3c m\u1ecdi chi ti\u1ebft c\u1ee7a ch\u1ee9ng kho\u00e1n.<\/p>\n

T\u1ea1o bi\u1ec3u \u0111\u1ed3 ch\u1ee9ng kho\u00e1n trong Excel<\/strong><\/p>\n

Nh\u00ecn chung,\u00a0m\u1ed9t b\u1ea3ng ch\u1ee9ng kho\u00e1n bao g\u1ed3m ng\u00e0y b\u1ea3o hi\u1ec3m c\u1ed5 phi\u1ebfu, kh\u1ed1i l\u01b0\u1ee3ng c\u1ed5 phi\u1ebfu, gi\u00e1 m\u1edf c\u1eeda ch\u1ee9ng kho\u00e1n, gi\u00e1 \u0111\u00f3ng c\u1eeda, m\u1ee9c gi\u00e1 cao nh\u1ea5t v\u00e0 gi\u00e1 th\u1ea5p nh\u1ea5t.\u00a0<\/span><\/p>\n

\"doc-stock-chart-1\"<\/p>\n

Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u1ea7n t\u1ea1o bi\u1ec3u \u0111\u1ed3 Volume-Open-High-Low-Close<\/strong><\/em>.<\/p>\n

1. Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u, nh\u1ea5n Insert > Other Charts > Volume-Open-High-Low-Close<\/strong><\/em>.<\/p>\n

\"doc-stock-chart-2\"<\/p>\n

M\u1eb9o.\u00a0<\/strong>Trong Excel 2013, nh\u1ea5n m\u0169i t\u00ean Insert > See All Charts<\/strong><\/em>, trong h\u1ed9p tho\u1ea1i Insert Chart<\/strong><\/em>, ch\u1ecdn\u00a0Stock > Volume-Open-High-Low-Close <\/strong><\/em>trong th\u1ebb All Charts<\/strong><\/em>, nh\u1ea5n OK \u0111\u1ec3 \u0111\u00f3ng h\u1ed9p tho\u1ea1i.<\/p>\n

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

<\/p>\n

2. Bi\u1ec3u \u0111\u1ed3 ch\u1ee9ng kho\u00e1n b\u1ea3o g\u1ed3m t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u ch\u1ee9ng kho\u00e1n \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o Excel.<\/p>\n

\"doc-stock-chart-4\"<\/p>\n

Trong b\u1ed1 c\u1ee5c bi\u1ec3u \u0111\u1ed3 m\u1eb7c \u0111\u1ecbnh, c\u00e1c d\u1eef li\u1ec7u c\u00f3 th\u1ec3 ch\u1ed3ng ch\u00e9o. \u0110\u1ec3 quan s\u00e1t bi\u1ec3u \u0111\u1ed3 ti\u1ec7n h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecbnh d\u1ea1ng tr\u1ee5c Y.<\/p>\n

3. Nh\u1ea5p ph\u1ea3i v\u00e0o tr\u1ee5c Y, ch\u1ecdn Format Axis\u00a0<\/strong><\/em>t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/p>\n

\"doc-stock-chart-5\"<\/p>\n

4. Trong h\u1ed9p tho\u1ea1i\u00a0Format Axis<\/strong><\/em>, \u0111\u00e1nh d\u1ea5u ch\u1ecdn\u00a0Fixed\u00a0<\/strong><\/em>trong ph\u1ea7n\u00a0Maximum<\/strong><\/em>, g\u00f5 s\u1ed1 l\u1edbn h\u01a1n v\u00e0o \u00f4 \u0111\u1ebfn khi d\u1eef li\u1ec7u kh\u00f4ng b\u1ecb ch\u1ed3ng ch\u00e9o n\u1eefa.<\/p>\n

\"doc-stock-chart-6\"<\/p>\n

M\u1eb9o.\u00a0<\/strong>Trong Excel 2013, c\u00e0i \u0111\u1eb7t l\u1ea1i gi\u00e1 tr\u1ecb Maximum\u00a0<\/strong><\/em>trong b\u1ea3ng Format Axis<\/strong><\/em>.<\/p>\n

\"doc-stock-chart-7\"<\/p>\n

5. \u0110\u00f3ng h\u1ed9p tho\u1ea1i. B\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y bi\u1ec3u \u0111\u1ed3 ch\u1ee9ng kho\u00e1n nh\u01b0 sau:<\/p>\n

\"doc-stock-chart-8\"<\/p>\n

M\u1eb9o.\u00a0<\/strong>C\u00f3 4 lo\u1ea1i bi\u1ec3u \u0111\u1ed3 ch\u1ee9ng kho\u00e1n trong Excel, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 ph\u00f9 h\u1ee3p theo \u00fd m\u00ecnh.<\/p>\n

<\/h2>\n<\/div>\n
\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11693,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11692","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\/11692","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=11692"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11692\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11693"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}