The geography data feature is now enabled for the text you have selected. Click on the list icon to see the data types. Select the data type you want to fill in the sheet.

Select a range of data, click the Conditional Formatting item in the Ribbon, and click Icon Sets, then one of the simple options under Directional. Now each data cell displays an arrow icon.

How to Change Series Data in Excel. ... Mouse over the icons to display the commands. Select "Chart Filters," and then choose "Select Data" to open the Select Data Source dialog box.

Beginner: Replacing Columns With Basic Images . This Excel sheet lists the heights of three well-known buildings. To create a column chart, I will select the data, click "Insert," and choose the ...

This icon indicates that Excel is now treating the cell's contents as geographic data. [Click on image for larger view.] Figure 3: The cell is now being treated as geographic data.

We now need to select the Exchange Data in a bid to populate the cells with relevant information. Select one of the currency pair cells. Click on the Insert Data icon that appears at the right.

Click OK, and Excel will select the current data range (the current region). In this context, current region means contiguous data, but the block of contiguous data can contain blanks.

To add more data to the Y axis in a line chart, add additional numbers in cells below your existing data. Right-click the chart, choose "Select Data" and highlight all entries in the single column.