Select Data For Chart In Excel For Mac. A chart can be a fantastic way to visually represent a series of data. On the ribbon click Chart Design and then click Select Data.
After you select your data on the Insert tab select Recommended Charts. If it uses columns as series then you can add only columns. Visualize the cells coming together to form a rectangle.
If you need to depict chart data based on non-adjacent cells use the Ctrl key to select these cells.
Enter and Select the Tutorial Data. How do I change the data source for an existing pivot table. You must select data that is contiguous and adjacent. Select the range of data for the pivot table and click on the OK button.