offset data markers

  • Thread starter Thread starter Gybeset
  • Start date Start date
G

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace Series Marker With Double Headed Arrow 1
How do I adjust marker spacing in Excel scatter plot? 1
For "Marker Line Style" see Point.Format.Line.Weight 2
chart markers 1
evenly spaced markers on log scale 1
How do I change the order of the line versus the marker for a scat 4
Markers making things too busy 1
Zero length string on chart 1

Back
Top