![]() Using the name box the new name dialog box or the name manager.Ĭhange series data in excel with help from a software expert in this free video clip. To change the data range for the data series in the series values box type a data range for the data series or enter the values you want.Ĭant change series names on certain charts nor change series order in legend. Press return to apply your new chart name. Now you return to the select data series dialog box please click the ok button to save the change. Improve Your X Y Scatter Chart With Custom Data Labels ![]() ![]() Additionally since a named range does not change when a formula is copied to other cells it provides an alternative to using absolute cell references in formulas. ![]() Changing series data in excel requires you to first open the spreadsheet that you plan on working in.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |