offset data markers

[Gybeset]

Anyone know whether you can / how to offset data markers in a "line with
markers" excel chart? I have a series of comparative data that mostly
overlaps and I want to spread the data points horizontally by a few points...
thanks.

 

[Jon Peltier]

First, use an XY chart. You can use a format that has lines and markers.
The XY chart treats the X values as real continuously variable values,
instead of discrete non-numeric categories.

Second, in the worksheet, add the offset to the range used to plot the X
values.

- Jon