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
|
|||
|
|||
X axis scatter dot-plot
Is there some way or an add-in in Excel 2000 to create a
scatter dot-plot (X axis=categories, Y axis= numbers) where dots with the same Y value would not overlap (by moving overlapped dots along the X axis within each category)(eventually along with a box-whisker plot) ? |
#2
|
|||
|
|||
There are a few tricks involved here. First, you need a way to offset
the points depending on how many share the same Y value, and which one of those the current point is. This usually entails a helper column with the offset calculations. The second trick is that a category axis is incompatible with the ability to offset points in this manner. But you could combine a Scatter chart (for your markers) with a line chart (or other chart that uses a category axis). Your X values would be the integer number of the category (count them, 1-2-3...) plus or minus the offset. Alternatively, you could use a dummy series along the X axis with data labels serving as the category labels, as in this example: http://peltiertech.com/Excel/Charts/ArbitraryAxis.html I know I've worked out such examples in these newsgroups in the past. You could search the archives at http://www.google.com/advanced_group_search - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ wrote: Is there some way or an add-in in Excel 2000 to create a scatter dot-plot (X axis=categories, Y axis= numbers) where dots with the same Y value would not overlap (by moving overlapped dots along the X axis within each category)(eventually along with a box-whisker plot) ? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
problems with scatter plot | lynn | Charts and Charting | 1 | March 3rd, 2004 03:19 PM |
Scatter Plot with 2 Y axes ? | MWE | Charts and Charting | 2 | January 22nd, 2004 08:56 PM |
Modification of Excel's Chart Tips in a Scatter Plot | George Elkins | Charts and Charting | 2 | November 14th, 2003 09:10 PM |
Scatter plot changes to line plot with data gaps | Jim | Charts and Charting | 14 | October 8th, 2003 05:10 PM |