offset data markers
 

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.

offset data markers
 

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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Gybeset wrote:
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.