![]() ![]() Creating a chart in Excel starts by entering the data on a worksheet. Then only by selecting the chart type according to your requirement, data can be automatically plotted into a chart. Excel defines the orientation of the data series based on the number of worksheet rows and columns in the chart. After the creation of chart, Excel gives the liberty to modify the chart as and when required. Here we will briefly define the process of creating and working with charts in MS Excel. Step 1: Create A Basic Chart Data, in most cases, can be arranged in rows or columns on a worksheet to transform into a chart. ![]() However, some chart types (such as pie, bubble & ) require a specific data arrangement. Excel automatically determines the best way to plot the data in the chart. • Select the cells that contain the data that you want to use for the chart. • On the Insert tab, in the Charts group, do one of the following: • Click the chart type, and then click a chart subtype that you want to use. • To see all available chart types, click a chart type, and then click All Chart Types. • By default, the chart is placed on the worksheet as an embedded chart; however, the location of the chart can be replaced in a separate chart sheet. • To name the chart, select the chart; Type a new name in the Chart Name text box in the properties group under Layout tab. Step 2: Change the Layout or Style of a Chart Excel provides the flexibility and user friendliness of modifying the chart layout and style ever after creation. To the ease of user, any predefined layout and style can be applied to a chart. Change can be made automatically or manually. Apply an Automated Predefined Chart Layout (or Style) • Click the chart that needs to be formatted by using a predefined chart layout (or style). • Select the chart layout or chart style that you want to use from the Chart Layouts (or Chart Layouts) group in the Design tab Change the Layout of Chart Elements Manually • Click the chart to display the Chart Tools. • On the Format tab, in the Current Selection group, click the arrow next to the Chart Area box, and then click the chart element that you want. • On the Layout tab, in the Labels, Axes, or Background group, click the chart element that you want to change, and then click the layout option that you want. Change The Format Of Chart Elements Manually • Click a chart to display the Chart Tools. • On the Format tab, do any of the following: • For any selected chart element: Click Format Selection in the Current Selection group, and then select the formatting options that you want. • For the shape of a selected chart element: Click the desired style, or click Shape Fill, Shape Outline, or Shape Effects, in the Shape Styles group, and then select the formatting options that you want. • For the text in a selected chart element by using WordArt, in the WordArt Styles group, click the style that you want, or click Text Fill, Text Outline, or Text Effects, and then select the formatting options that you want. Script Center Microsoft Office Office Space Tips and Tricks. Office Space Tips and Tricks Creating Line Charts in Microsoft Excel. Creating Line Charts in. Try Microsoft Edge A fast and secure browser that's designed for Windows 10 No thanks Get started. Office templates & themes. Weekly Meal Planner Excel. Today’s author, Ben Rampson, a Program Manager on the Excel team. Customers who author charts in presentations and reports often spend a significant amount of. Graphing Charts in Microsoft Excel Theresa A Scott, MS. – A line chart in which the area below the line has been colored in. – Can be stacked. Step 3: Add Or Remove Titles Or Data Labels Titles and Data labels are used to make the charts easy to understand. Chart and axis titles can also be linked to corresponding text in worksheet cells by creating a reference to relevant cells. Linked titles will be automatically updated in the chart whenever there is a change in corresponding text. Add A Chart Title • Click the chart to which you want to add a title and see the Layout tab • In the Labels group, click Chart Title and choose Centered Overlay Title or Above Chart. • Enter the name in the text box appearing in the chart. Add Axis Titles • Click Axis Titles on the Layout tab, in the Labels group. • Here you can: • Add a title to a primary horizontal (category) axis • Add a title to primary vertical (value) axis • Add a title to a depth (series) axis • Type and format the text that you want in the Axis Title Add Data Labels • You can also easily: • Add a data label to all data points of all data series; • Add a data label to all data points of a data series; • Add a data label to a single data point in a data series • On the Layout tab, in the Labels group, click Data Labels, and then click the display option that you want. Link a Title to a Worksheet Cell • Click the chart or axis title that you want to link to a worksheet cell. • On the worksheet, click in the formula bar, and then type an equal sign (=). • Select the worksheet cell that contains the data or text that you want to display in your chart. • Press ENTER. Step 4: Show or Hide a Legend When you create a chart, the legend appears, but you can hide the legend or change its location after you create the chart.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |