View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default data markers in graphs overlap

If it's not going to upset the display of values, you can jitter the data,
that is, add or subtract a slight X or Y offset to the data. This is not
something the chart does, it's something you have to do to the data before
the chart gets it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Hopsakee" wrote in message
...
When I make a point graph in excel, some of my data points are positioned
exactly on top of each other.
That's a problem, because my winter data has the same value as my summer
data. But now I can not see whether my summer data is hidden behind my
winter
data or that maybe my summer data is altogether flawed and not in my graph
at
all.
Of course I can use different markers for both data types, but I'd rather
use an offset option or something like that.

I use Excel 2003