ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   A strange kind of graphic (https://www.excelbanter.com/excel-programming/350213-strange-kind-graphic.html)

filo666

A strange kind of graphic
 
Hi, I need a suggestion to make a graphic, basically it's a scatter graphic
(you give 2 values and it put the a point in (x,y), but the problem is I have
values in different places, I mean:
A B C D E
1
1 2
2 1 3 1
3 2 4 1 2
4 3 5 2 3
5 4 6 3 4

So for example, if in the A test some one score 3, then a point is draw in
the A,3
if someone score 1 in B, then a point is draw in B,1 then at the end I need
a line that cross all the points and make a graphic.

Please help because i dont have any idea how to make what I want.
Any suggestions will be appreciated
TIA



All times are GMT +1. The time now is 04:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com