Can you somehow keep the formatting (marker color, line type, x-axis values) while changing the data range/series for input for an excel table? By default it seems to regress to blue lines in standard formatting.
Asked
Active
Viewed 114 times
1 Answers
0
I would select the data line in the graph and in the formula bar directly change the range for the y values.
Or, if I wanted the change to be "easier" I would edit the data in the range of cells used for the y values on the sheet.
You might find this answer I did a while back useful: https://stackoverflow.com/a/71870957/4961700
Solar Mike
- 7,156
- 4
- 17
- 32