Creating charts based on worksheet data in Microsoft Excel 2019

In this section, we will learn how to create a chart from worksheetdata; plot non-contiguous data; select, resize, delete, and change chartoptions and layouts; view the Sunburst and Funnel charts; look at how tochange chart placement. You will also be shown how to change the charttitles, add a series, and change chart elements manually.

We use charts to make information more appealing, clearer, and easierto read. A chart is a graphical representation of worksheet information.It is important to get used to the names of the different elements of achart so that you know which part you are changing when presented withoptions while editing. An example chart and its elements are shown inthe following screenshot:

ms office 866

Charts automatically link to data on the worksheet. When we makechanges to the information on the worksheet, the chart automaticallyupdates:

  1. Open the SSGCharts.xlsx workbook.
  2. Select the data on the worksheet from which you would like to createa chart.
  3. Click on the Insert tab, and thenlocate the Chart group.
  4. You will notice a RecommendedCharts icon that offers charts appropriate to the selected dataon the worksheet.
  5. Alongside the Recommended Charticon, you will be able to select from specific chart categories thathouse further examples of chart types of the same chart category, aswell as Maps, PivotCharts, 3D Maps, Sparklines, and Filters.
  6. If you choose the RecommendedChart icon, you will also have access to all the charts availableby clicking on the All Charts tab atthe top of the dialog box—this is the most comprehensive list of charts,with subcategories and even previews of row-/column-switchedcharts.
  7. After selecting worksheet data and browsing chart types, you willnotice that Excel displays a preview of the chart applied to theworksheet data within the dialog box (or directly on the worksheet,should you have selected any of the char-type, drop-down categories onthe Chart group).
  8. Click on the OK command to placethe selected chart on the worksheet alongside your data, as illustratedin the following screenshot:
ms office 524
  1. Notice that the Chart Tools contextual menu is now visible, as thechart is selected on the worksheet, and that the Design and Format tabs are accessible in order tocustomize the chart further.
  2. Once clicking off the chart back onto the worksheet, the Chart Tools contextual menu willdisappear.
Double-clicking on a chart element will open the Format Chart pane to the right of theworksheet, with the icons applicable to the element you have clicked onin order to format them quickly, as illustrated in the followingscreenshot:

ms office 841

Leave a Comment