LostinExcel80
New Member
- Joined
- Apr 10, 2020
- Messages
- 11
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
I would like to make a Bubble chart with the following but is is pairing rows together, is there a way to add this quickly for 100's of entries?
.=SERIES('Sheet2 (2)'!$A$3,'Sheet2 (2)'!$B$2:$C$2,'Sheet2 (2)'!$B$3:$C$3,1,'Sheet2 (2)'!$B$4:$C$4)
There are hundreds of them so manual fixing it is out of the question. What I need it to be is:
=SERIES('Sheet2 (2)'!$A$1,'Sheet2 (2)'!$B$2,'Sheet2 (2)'!$C$26,1,'Sheet2 (2)'!$D$2)
Thank you
.=SERIES('Sheet2 (2)'!$A$3,'Sheet2 (2)'!$B$2:$C$2,'Sheet2 (2)'!$B$3:$C$3,1,'Sheet2 (2)'!$B$4:$C$4)
There are hundreds of them so manual fixing it is out of the question. What I need it to be is:
=SERIES('Sheet2 (2)'!$A$1,'Sheet2 (2)'!$B$2,'Sheet2 (2)'!$C$26,1,'Sheet2 (2)'!$D$2)
Name of plot | Y | X | Z (bubble size) |
Name1 | 1 | 500 | 50 |
Name2 | 1 | 700 | 20 |
Name3 | 5 | 455 | 30 |
ect | 8 | 454 | 46 |
Thank you