Scatter / Bubble Chart

gzpaitch

New Member
Joined
Oct 31, 2015
Messages
2
Hello,
How are you doing?

I got an internship during the summer and one of the tasks that I had was to plot some data in Scatter / Bubble Chart, however, I still struggling with it.

Just to give a short background about the data: The data were collected in a small-scale fisheries community in American Samoa through a survey. This surveys had two question that I need to turn into only one plot. Those questions are similar, but the first one ask about "total CATCH" and the second one ask about "amount o TIME". I need to relate both answers in only one plot, for example:

- Answer 1: 24) Much more / 25) More
- Answer 2: 24) Much more / 25) Less
- Answer 3: 24) Less / 25) More
- Answer 4: 24) Much more / 25) Less

According to these answers, I should have:
- One ball in the intersection between "Much more catch and More time"
- One ball in the intersection between "Less catch and More time"
- One ball in the intersection between "Much more catch and Less time"
- Two balls in the intersection between "Much more catch and Less time"

The image bellow is an extract of the survey question and the exact plot that I want. See that the catch is in the Y axis and the time in the X axis.

I forgot to mention that each (5 years ago, 10 years ago, 20 years ago, Started fishing) will be one plot, so I will have one plot for 5 years ago, one plot for 10 years ago, and so on.


2d9u2gy.jpg



Hopefully, you will understand my question! It is extremely difficult to explain it! haha

Thank you so much for your help! You will help me tremendously!


Regards,
Gustavo Z.
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,223,214
Messages
6,170,771
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top