Microsoft Office 2016: The Complete Guide (2015)
PUTTING IN AND ADJUSTING CHARTS
Adding Charts to Word
The steps are as follows:
Select Ctrl+End to get to the end of the file.
Inside the Illustrations group, go onto the Insert Tab and select the Chart button.
To the left of the panel of the Insert Chart dialog box, select every category to browse the selection of charts that you can use in Word. Now go back to the Column category.
Inside the selection which is located above the panel, select the fourth thumbnail 3-D Clustered Column to temporarily view the chart type then select OK to put in the general three-dimensional clustered column chart which will be at the bottom of the document then open to the supplementary Excel Worksheet.
Select the Select All option in the upper-left section of the Excel worksheet, subsequent to that, click the Delete key to erase the temporary data found in the worksheet, thereby clearing the worksheet. The columns in the temporary chart found in the document will be gone, with the highlighted guidelines behind.
Select the second cell found in row 1(cell B1) type in “Monday” then select the tab key to insert the heading (that is in the worksheet and on the chart) and go onto the following cell.
From cells C1 go straight E1, type in “Tuesday, Wednesday and Thursday” selecting Tab after every insert to get to the next cell. Please note that after inserting December, it will be located on the outskirts if the highlighted guides and it is not visible on the inside of the document.
Place the blue handle at the lower right-hand section of cell D5, the instance when the cursor changes to a diagonal double-headed arrow the cursor changes to a diagonal double-headed arrow pull it one cell to the right and one cell upwards. This results in the adjustment of the definition of the cells to A1:E4.
Select cell A2, type Minimum, and then click the Enter option.
Select Enter to descend the column or you can click Shift+Enter to ascend the column. Select Tab to go to the right of the same row or Shift+Tab to go to the left.
Inside cells A3 and A4, input “Mean” as well as “Highest” respectively.
Place the cursor to the border located amongst the headers of columns A and B, after the cursor changes to a double-headed arrow, double-click to modify the width of every highlighted column in order to provide a more custom fit for data inputted in the cell.
Highlight from column A to E by pressing and pulling the left key on the mouse across each header. Then place the cursor to the boarders between two randomly selected columns. After which you should double-click to modify the width of all the highlighted columns to accommodate all inputted data.
Inside cells B2, type 37, then click Tab. Please aware that a related column will now be visible.
Inside cells C2 to E2, type 54, 53 and 29, selecting Tab to reposition from cell to cell, providing that the late number already typed in, select Enter. Please note that cell B3 is now activated.
Type in the data below inside the worksheet. While at the same time paying attention to the fact that as data is being typed in that chart columns and scale adjusts to mirror the data.
Inside the Chart in Microsoft Word panel, select the Close button.
Select a blank area of the chart. Afterwards on the Design tool tab, in the data group, select Switch Row/Column in order to assign the temperatures more plausibly according to each month.
On the charts select Chart Title to choose that feature, type in Jamaica’s Atmospheric Temperatures, now select a blank area on the page in order to see the results.
Making Adjustments to Charts
Open the document, and then adhere to the subsequent steps.
Inside the Type group, located on the Design tool tab, select the Change Chart Type option to make available the Change Chart Type dialog box, making the thumbnail of the chart type, 3-D clustered column visible.
Select line located inside the category list. From the selection of styles located at the top of the right panel, double-click the fourth thumbnail to transform the column chart to a line chart. This displays information colored lines instead of columns.
To the right of the chart, inside the document select the Chart Styles option. An array of Style or Color can be found at the top of the window from which you are able to choose.
Place the cursor and select each thumbnail to temporarily view the chart style in the Style gallery.
Select the second thumbnail Style 2, to modify the information markers which are circles which indicate the definite data points.
Inside the Chart Styles panel, select color to see both the Monochromatic and Colorful palettes selections centered on existing theme. Browse through the gallery make note of the various shades available and make a choice based of your preference.
Below the Monochromatic palette, select the light-to-dark gradient. Select Chart Styles option in order to exit the gallery.
Place the cursor at a region of the chart between the axes that entails the data markers. The moment when the Screen tip shows that you indicating to the plot area. Select it.
Inside the Shape Styles group, found on the Format tool tab, select the Shape Fill arrow, then select the initial swatch in the red swatch found in the Theme Colors Palette.
Select the Chart Elements arrow found at the top of the Current Selection group for the list of elements of the current chart to be visible.
Select Series Maximum located in Chart Elements to highlight the data points of the first line on the chart.
Select the Format Selection option to show the Series Option page from the Format Data Series window.
Select the Fill and Line option found at the top of the Format Data Series panel to show the Line varieties.
Select the Outline color button after which select the blue swatch in the Standard Colors palette.
Press Marker to allow Marker Options, Fill and Border categories which is found close to the top of the panel to now become accessible.
Select Solid Fill found in the Fill category. Press the Fill Color option, after that, select the green swatch inside the Standard Colors palette.
Exit out of the Format Data Series and select a blank region of the chart area to make the data series available. On the right-hand side of the chart select the Chart Elements option.
Modifying Visible Chart Characteristics
To accomplish this the following steps are required:
Make the Data Labels, Guidelines and Elements selection boxes blank to erase features from the chart. Click the Axis Titles as well as Data Table selection boxes, and select the arrow. This arrow is now visible to the right of the Data Table as a form of validation that the With Legends Key choice is selected.
Note: You are able to present definite group of chart elements by selecting an already formatted layout from the Quick Layouts selection on the Design tool tab.
Select the Chart Elements to exit the list. And just like that your data is presented.
Select the Axis Title placeholder to the left to select it. After which type in “Degrees Celsius” to substitute the placeholder text. Replace the Axis Title below with “Days of The Week”.
Saving the Chart Element as a Template
Press the right mouse key and then select Save as Template option to open the Save Chart Template dialog box to make the contained information of the Charts folder visible.
Type in “Jamaica’s Daily Temperature Chart” inside the File name box and select Save.
Select the Change Chart Title options. Then inside the left panel of the Change Chart Title dialog box select Templates to validate that your modified chart is currently available as a template.
Select Cancel to exit the dialog box inside the Change Chart Type dialog box in default of establishing a fresh chart.
Utilizing Already Inputted Data in Charts
To accomplish this following rules are required:
Go through the document for the chart to be visible on the screen. Select an empty region of the chart area for the Chart Tool tabs to be seen.
Select the Edit Data arrow inside the Data group on the Design tool tab then from that option list select Edit Data in Excel 2013 for the chart data found in the Excel worksheet to be visible.
Make the Open page of the Backstage view visible inside the Excel window select Computer inside the left panel of the Open page after which you should select the browse option in the right panel. Go through the Chapter08 practice file which is located inside the Open dialog box and double-click the Temperature workbook to get it in a new Excel workbook.
Select the Arrange All button which is found inside the Temperature workbook located on the View tab in the Windows group. Now go to the Arrange Windows dialog box, select Horizontal then select Ok. This is to ensure that you assemble the Temperature worksheet at the top of the chart worksheet. Causing you to see them both at the same time.
Arrange the worksheet so that you can see both cell B4 and cell M7. Select cell M7 to select range B4:M7.
Select the Copy button found in the Temperature workbook found on the Home Tab in the Clipboard group.
Select the title bar of the Chart in Microsoft Word to activate it, select cell B1 then go to Home tab inside the Clipboard group, select the Paste button in order to paste the previously copied information in the chart data worksheet.
Go now to the document and select an empty space of the chart area. Press the Select Data button found inside the data group on the Design tool tab. In order to activate the chart worksheet and also open the Select Data Source dialog box. Position the Select Data Source dialog box until you see the worksheet information.
Note: it is now possible to send information into your chart from external sources such as an internet page and other files. To do this, make the Excel worksheet you are currently using visible. After which go onto the Excel Data tab, inside the Get External Data Group and select the option for your data source then go through the contents of the source.
Drag the worksheet to highlight cells, to modify the range in the Chart Data Range box so you now have =Sheet1!$A$M$4 to communicate to Excel to employ the numerical values in A1:M4 on sheet 1 of the worksheet you are working on.
Select Ok option inside the Select Data Source dialog box then exit the chart worksheet for the revised chart to be visible. This results in you being urged to save this chart worksheet in the form of a file.