HOSP 187 Chapter Notes - Chapter 17: Dialog Box, Linked Data, Scatter Plot

• School: University of Delaware
• Department: Hotel, Restaurant and Institutional Management
• Course: HOSP 187
• Professor: Zjisk

Document Summary

Charting 101: the process of drawing number of a graph is called plotting, here are some tips, structure you data in a simple grid of rows and columns, do(cid:374)"t i(cid:374)(cid:272)lude (cid:271)la(cid:374)k (cid:272)ells (cid:271)et(cid:449)ee(cid:374) (cid:396)o(cid:449)s o(cid:396) (cid:272)olu(cid:373)(cid:374)s. Creating a chart with the ribbon: select range of cells that includes the data you want to chart, including the column and row headings and any chart title, head to the (cid:396)i(cid:271)(cid:271)o(cid:374)"s i(cid:374)se(cid:396)t (cid:272)ha(cid:396)ts se(cid:272)tio(cid:374). You"ll see a sepa(cid:396)ate (cid:271)utto(cid:374) fo(cid:396) ea(cid:272)h type of chart. Click the chart you want: click the subtype you want. The chart tools ribbon tabs: design, let"s you (cid:272)ha(cid:374)ge chart type and linked data that chart uses, layout, let"s you (cid:272)o(cid:374)figu(cid:396)e i(cid:374)di(cid:448)idual pa(cid:396)ts of (cid:272)ha(cid:396)t, format, let"s you fo(cid:396)(cid:373)at i(cid:374)di(cid:448)idual (cid:272)ha(cid:396)t ele(cid:373)e(cid:374)ts. Creating a standalone chart: right click the chart, and then choose move chart, choose new sheet and then enter name for new worksheet, click ok.