Naming Basics Best practice recommendations are to create a chart placing independent variables on the horizontal, x-axis and dependent variables on the vertical, y-axis. For example, in a chart that displays population fluctuations by year, population numbers go on the x-axis and years go on the y-axis. Along with a descriptive name or title for each axis, points on each axis should have an identifier that if appropriate, includes units of measurements. Charts that contain more than one set of data should always display each set using a different color and include a chart legend in addition to axis names and labels. Data Label Modifications Enabling data label modification options involves alternate steps depending on whether you want to modify some or all data labels. To change all data labels, click anywhere in the chart. To modify all labels on either the x or y-axis, click anywhere within the data series.
Unprotect excel workbook for mac. Option 1 – Unprotect all Worksheets Open a workbook and start the Visual Basic Editor (Alt + F11).
To modify a single data label, click on the data label. Click Design on the main menu, then Layout and finally Data Labels to access options for the group or individual label.