How to Add Zoom & Scroll to an Excel Chart. ... How to Add a Chart to Another Chart in Excel. ... Replace "A1" in the formula with the first cell from the second range.

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.

To get you started using charts, here are the most common types of charts used in Excel and when you’d want to use them: Column and bar charts: These chart types are very similar, with column ...