How To Change Range In Excel Chart. Click the move up or move. double click the horizontal axis to format it.
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.