If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I make my data points not overlap in a scatter plot?
|
#2
|
|||
|
|||
How do I make my data points not overlap in a scatter plot?
Excel plots the data you give it. If two points have the same X and Y
values, they will be plotted in the same location in the chart. If you want the points not to obscure each other, you need to offset them slightly. Excel has no built-in functionality to generate this offset, so you'll have to work out your own algorithm and write your own formulas. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "sfdc" wrote in message ... |
#3
|
|||
|
|||
How do I make my data points not overlap in a scatter plot?
sfdc -
In Excel, one (tedious) way is to sort the XY pairs on the worksheet, identify the duplicates, and for each duplicate pair add or subtract a small number for either the X or Y value. It's a manual method for what's sometimes called "jittering." - Mike www.mikemiddleton.com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
A scatter plot with a 2 column data source | SamB | Charts and Charting | 4 | August 23rd, 2007 11:44 PM |
Maximum number of data points for an xy scatter chart? | Rich F | Charts and Charting | 7 | July 11th, 2007 03:06 PM |
Macro to add labels to data points in an xy scatter chart | Scott Wagner | Charts and Charting | 2 | December 17th, 2005 01:46 AM |
Label XY scatter plot points by frequency of occurence (no pivot t | Chris Gregory | Charts and Charting | 3 | September 21st, 2005 01:05 AM |
Scatter plot changes to line plot with data gaps | Jim | Charts and Charting | 14 | October 8th, 2003 05:10 PM |