How To Change Range In Excel Chart at Gloria Hamilton blog

How To Change Range In Excel Chart. Click the move up or move. double click the horizontal axis to format it.

Excel Change X Axis Scale tabfasr
Excel Change X Axis Scale tabfasr - image credit : tabfasr663.weebly.com

Under legend entries (series), click edit. You can use this same approach to add a new data series. Click the design tab, click the select data in the data group.

Excel Change X Axis Scale tabfasr

To give a better picture of the sales results, you could show what the sales target range was, for each month of the year. For your convenience, make the name of the dynamic range match the. In the dialog box, locate the button in the center labeled switch row/column. To give a better picture of the sales results, you could show what the sales target range was, for each month of the year.