View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier[_2_] Jon Peltier[_2_] is offline
external usenet poster
 
Posts: 461
Default 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.