Scatter plot with one independent variable and two dependent

**Steingar** · 04-21-2020, 01:09 AM

Hi there. I'm trying to create a scatter plot which has has one independent variable with two dependent variables measured on the x and y axis respectively.

Here's an example of a table with data arranged in a way I want to graph:

pic2.PNG

I want to create a scatter plot with each point being representative of column 1 (i.e. the month), the x-axis being column 2 (Temp) and y-axis being column 3 (rainfall). It'd be ideal if I could hover over each point which would show what each one represents (i.e. the month). Here is what it would look like ideally:

pic1.PNG

Now, the above graph I had to do by manually creating each series one by one in 'Select Data', which is tedious, especially if I want to create a large scatter plot with hundreds of variables.

Therefore, can anyone advise how to create something like this simply and quickly?

**MrShorty** · 04-21-2020, 09:17 AM

I would use a technique like this: https://peltiertech.com/conditional-...-excel-charts/ Note that most of the work is in the spreadsheet adding the additional columns for each month/data series.

**ThxAlot** · 04-21-2020, 04:03 PM

Hi, there

The Table does the trick for your

All you need to do is just to convert the data range into a table and all new data you append in the table will be automatically plotted in the chart.