CACH VE DO THI TRONG EXCEL

CACH VE DO THI TRONG EXCEL - Cchvthtrongexcel...

Info icon This preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
C á ch v   đồ  th  trong excel   B n ph i c ó  m t b ng g m 2 c t: m t c t l à  c á c gi á  tr  c a tr c ho à nh, m t c t l à  c á c gi á  tr  c tr c tung. Sau  đó  b ô đ en 2 c t n à y v à   n v à o n ú t chart wizard (c ó  h ì nh  đồ  th  c t) tr ê n thanh  c ô ng c ; ho c n ế u kh ô ng th ì  ch n Insert-> Chart. Ch n ki đồ  th , trong tr ườ ng h p c a b n l à   ki u XY (scatter)  n ok l à   đồ  th  hi n ra. Mu n hi n h  s  t ươ ng quan th ì  click chu t ph i v à o m đ i m b t k ì  trong  đồ  th , ch n add  trendline, ch n tab options ---> ch n Display R-squared value on chart. N ế u b n mu n hi n c   ph ươ ng tr ì nh tuy ế n t í nh ra th ì  ch n c á i m  ngay ph í a tr ê n: Display equation on chart   X - V  BI ĐỒ  TRONG EXCEL  1- C á c d ng bi đồ    D ng thanh,c t: bi u th  s  t ươ ng quan gi a c á c ph n v i ¬  nhau.  D ng  đườ ng,v ù ng: bi u th  s  thay  đổ i d  li u theo th i gian. ¬ ¬  D ng tr ò n: bi u th  t ươ ng quan gi ĩ a m t ph n d  li u.  2 – Ph ươ ng ph á p v  bi đồ   a - V  bi đồ  d ù ng Sheet d  li Ch n v ù ng d  li u c n v  bi đồ  (c ó  th  ch n c  c á c ti ê đề   đầ u h à ng v à   đầ u c t). Nh p chu t t i ph í m Chart Wizard tr ê n thanh c ô ng c . Di chu t t i v  tr í  c đặ t bi đồ , b m v à  k é o chu để   đị nh h ướ ng v  k í ch th ướ c khung bi đồ .
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern