Change Data Series In Chart. On the worksheet click in the formula bar and then type an equal sign. You can modify a charts data references numbers dates or durations at any time.
Data series are listed on the left. In the Format sidebar click the Style tab. To change the bounds of your Y axis you can useAxes xlValueMinimumScale Axes xlValueMaximumScale.
Data series are listed on the left.
Click Edit make your changes and click OK. In the Select Data Source dialog box in the Legend Entries. This formula has conventional cell addresses. You can also right-click the chart area or plot area click Change Chart Type and then continue with step 3.