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| |
All times are GMT +1. The time now is 08:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com