Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Series Markers Wavequation Excel Discussion (Misc queries) 1 May 29th 09 10:27 PM
Custom Data Markers KBICarl Charts and Charting in Excel 1 March 19th 09 06:46 PM
Custom Data Markers KBICarl Charts and Charting in Excel 0 March 19th 09 04:36 PM
Data Markers ivy_gayle Charts and Charting in Excel 1 January 3rd 07 08:36 AM
Too many markers on line chart makes it a thick line and individual markers cannot be seen denzel Excel Discussion (Misc queries) 2 August 2nd 06 04:06 PM


All times are GMT +1. The time now is 07:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"