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.

Click "Developer" from Excel's ribbon. Click "Insert" from the Controls group, and click the scroll bar icon. Click and drag over the chart to add a scroll bar.

Microsoft Excel's Data Validation tool lets you add a drop-down list to a cell based on existing data in a column. However, how this works depends on whether the source data is part of a formatted ...

When plotted on an Excel Scatter Chart, these data points will form a total of four circles, effectively converting a scatter chart into a bull’s-eye chart. Your updated table containing the ...

On the tab in the Data group, click the Switch Row / Column button. The rows are switch to columns. We hope this tutorial helps you understand how to switch rows and columns in an Excel Chart.

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

Inserting a blank row between existing rows of data in an Excel spreadsheet can be a tedious task if you insert each row individually. Fortunately, if you know this trick, inserting rows between ...

To change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name, follow this procedure: Open the Excel spreadsheet to find the chart ...

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.

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it. $3,500 iPhone possible?

Step 3: Input Duration Data. The next step is to add another series to your Excel chart to reflect each task’s duration. To do this: Right-click on the chart and select “Select data” from ...