Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Series Markers | Excel Discussion (Misc queries) | |||
Custom Data Markers | Charts and Charting in Excel | |||
Custom Data Markers | Charts and Charting in Excel | |||
Data Markers | Charts and Charting in Excel | |||
Too many markers on line chart makes it a thick line and individual markers cannot be seen | Excel Discussion (Misc queries) |