Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i prevent a row from moving, like subheader that is visibl | New Users to Excel | |||
OFFSET Charts - moving data length | Charts and Charting in Excel | |||
How do I prevent Crtl+End moving to a cleared cell? | Excel Worksheet Functions | |||
prevent display of data series dropping to graph x axis for null d | Charts and Charting in Excel | |||
Moving data: vertical to horizontally laid cells | Excel Discussion (Misc queries) |