Chart filters in excel for mac

broken image
broken image

Be sure to include the cells with the labels in the selection area.Ĭlick on the 'Charts' tab in the ribbon and select a chart type from the 'Insert Chart' group.

broken image

Select all the cells with data you want to include. Each data series needs to be in its own column or row and the number of cells used for each data series needs to be identical. Sales data broken down by month would be an example of a data series. Gather your data, making sure you organize it by the appropriate axes.