Berikut adalah artikel dengan panjang lebih dari 1000 kata yang membahas cara membuat scatter plot warna pada Microsoft Excel:

Membuat Scatter Plot Warna dengan Label

Saya ingin mengetahui bagaimana cara membuat scatter plot warna pada Microsoft Excel. Saya memiliki tabel data yang memiliki kolom untuk atribut dan dua kolom lainnya untuk X dan Y. Saya ingin memplot mereka dalam bentuk scatter, tetapi dengan warna yang spesifik untuk setiap atribut.

Saya ingin memiliki semua titik dengan label "A" berwarna A, semua titik dengan label "B" berwarna B, dan semua titik dengan label "C" berwarna C. Bagaimana saya dapat melakukan ini secara otomatis? Data set dan jumlah label saya sangat banyak!

Penggunaan Paste Special

First, create a scatter plot on just one of the attributes (A, for example). Then, copy the X and Y data (not the labels) for the next attribute, select the chart object, then use Home>Paste>Paste Special from the ribbon to paste the copied data as a new series.

Menggunakan Select Data Source

Alternatively, we could also use Select Data Source. Go to Insert > Choose one Scatter Graphic in Charts group, then we will get a blank chart. Right click this blank chart > Select Data Source > click Add > Enter the Series Name, such as Label A, select the data range for that series.

Membuat Scatter Plot Warna dengan Conditional Colouring

In this tutorial, we will see how to add conditional colouring to scatterplots in Excel. I came across this trick when I was creating scatterplots for an article on Gestalt laws. I wanted the dots on the plot to be in 3 different colours based on which group they belonged to.

Here is how to do this.

Langkah-Langkah

Step 1: Preparing the data Take the Y column and break it down into 3 columns A, B and C depending on the group the data point belongs to. To do this, we use the excel IF condition: IF (Condition, Value if True, Value if False) The condition we use is “label of the column = the group name”.For example, for the first data point, in column A, we check if A = C. If the condition is true we populate the column A with the Y value 25. Else we add an NA() to the column.

Step 2: Draw the scatterplot Select Insert and pick an empty scatterplot. Then select the columns X, A, B,C

Click OK. Here is the scatterplot with 3 groups in different colours.

Edit Warna

To edit the colours, select the chart -> Format -> Select Series A from the drop down on top left.

In the format pane, select the fill and border colours for the marker.

Repeat these steps for Series B and Series C. Here is our final scatterplot.

Membuat Scatter Plot Warna dengan Label

I have three columns of data. Two columns contain numerical data, which I want to plot on the x- and y-axis of a scatterplot. That part's easy. It's the next part that trips me up. I have a third column which contains categorical data. I want to use the values in this column to color-code all the "points" on the scatterplot.

For example, in the attached screenshot, I would like the points in categories "A", "B", and "C" to each be assigned a color.