Hi,
In order to jitter the data points you would need to add or subtract a
constant from each points X value.
This present a Problem though. You have a value X axis so moving a point
left or right will give it an incorrect value when reading the chart.
Jittering of the points works best when the x axis is categorical.
Cheers
Andy
zeimi wrote:
Hi,
I could use some help with my Line with Markers -chart. My four different
series overlap each other a little, which isn't that much of a problem until
I add error bars, which are almost impossible to format so that you can know
for sure which error bars belong to which data series.
Is it possible to move a data series (including its error bars) right or
left just a few pixels so the error bars are distinguishable from each other?
I've seen this done in some published charts, but can't find a way to do it.
Using google I found an example of what I need:
http://www.emeraldinsight.com/fig/2180130203005.png
Any help would be greatly appreciated.
Best Regards,
Sami Hyvönen
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info