How to Add a Second Y-Axis on Excel & Make a Second Series at the End of the Chart. Microsoft Excel charts give you a large number of options for displaying the data in your spreadsheet.

Microsoft Excel 2013 charts are dynamic in that they automatically update when the current data changes. However, if you add a series of data points to a spreadsheet, Excel doesn't know to include ...

Image: PixieMe/Adobe Stock. There are lots of ways to highlight a specific element in a Microsoft Excel chart. You might add data labels or use pictures instead of a plain column in a column chart.

Add data labels: Data labels add numeric values to a chart, rather than relying solely on visualization. To add data labels, select the chart, navigate to the Chart Design tab, and click Add Chart ...

It's important that you include the 100% values within your chart's data for reasons that'll become clear soon. This time, ...

Displaying values on a map chart is more meaningful than handing someone a sheet of data. Thanks to Microsoft Excel's Geography data type, creating a map chart is easier than you might think.

To add a total column to your chart, first add the total to your table. To do this, drag your preformatted table handle down ...

As you add data to each cell, the chart updates to display the new data. Even better, Tables bring the useful magic of Filters to your charts. Suppose you have a table with monthly budget figures ...

Not anymore: Excel 2013’s table tools include features that make it easy to link charts and cells, perform searches, and create dynamically updated reports, just like—yes—a relational database.

Select cells A9:B22. Go to Data, click the dropdown arrow next to What-if Analysis within the Forecast group, and choose Data Table. The Data Table window will open, asking for inputs into Row input ...