Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Plot Data with X, Y values on Chart
I have a group of data with value of X and Y in pairs. Same data may have the
same X and Y values. I have tried to use scatter chart together with the "AttachLabeltoPoints" macro to draw it. However, the labels overlaps for data have same X, Y value. In the example below, A and C overlaps. Therefore, I'd like to ask if it is possible plot them on one graph, where the data fill in one of the corresponding "box". Thanks in advance. For example, Data Name, X-Value, Y-Value A, 1, 3, B, 2, 3, C, 1, 3, On the graph: 3 |A| | | |C|B| | ---------------- 2 | | | | ---------------- 1 | | | | ---------------- 0 |1| 2| 3| |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to plot chart where X axis values START 1 | Charts and Charting in Excel | |||
how do I setup a pie chart that does not plot zero values ? | Charts and Charting in Excel | |||
Unable to Plot Values on Chart | Charts and Charting in Excel | |||
BUG?: Excel scatter chart: will not plot x-values | Excel Discussion (Misc queries) | |||
HOW TO: Plot a Team Name on a chart based on two values | Charts and Charting in Excel |