In the Format Data Series pane, click Secondary Axis and change the Gap Width to 500%, as shown in Figure G. Doing so reduces the bar’s width so it looks less like a column and more like a line.

Learning how to perform statistical data analysis in Microsoft Excel can help you improve your analytics and reporting. This guide takes you ...

Microsoft launches the new COPILOT function for Excel, letting users analyze data with simple text prompts. Microsoft is ...

This 3-day hands-on workshop will show you how to use Microsoft® Excel for making sense of data. You will enhance your data analysis skills and learn how to interpret Excel output.

By default, Excel will use the first column for the X coordinate and the second for the Y coordinate. To add additional data for the Y axis, you need corresponding data for the X axis as well.

Select “Data Analysis” from the Analysis group. If you don’t see it, you may need to add the Analysis ToolPak add-in. Choose “Regression” from the list of analysis tools and click “OK”.