【Excel 2 Axis Graph】 How to create a graph with axes on the top, bottom, left and right in Excel

未分類
【Excel 2 axis graph】 I introduce how to make a graph with axes on the top, bottom, left and right in Excel with images!

For the presentation of my experiment, I tried to make a graph with scales on the top, bottom, left and right for the first time in a long time and forgot.

It took me about an hour to find out how to do it, which made me very mad, so I’m going to summarize it as a blog post.

The format of the graphs you’re referring to varies from school to school and field to field, so check carefully before you make one!

Postscript

I recently found out about a software program called “Kaleida Graph” that can create beautiful graphs in one shot (though it is expensive).

Kaleida Graph (Hulinks HP)

スポンサーリンク

Preparation of 2-axis graph (most important)

Prepare the data. Basically, the left side is the X axis and the right side is the Y axis.

Copy the contents of the Y-axis to create a dummy column.

Select the table and choose “Insert” to select the graph. The point of this is to select a range with one extra row for the X and Y axis.

This time we chose “Scatter Plot”.

Click on the “+” in the upper right corner of the graph to delete the elements you don’t need. If they are not shown, drag the graph to make them appear.

Add axes up, down, left and right.

Double-click in the graph and select “Series” from “Options” in the “Formatting” window on the right.

Select the bar chart symbol from the series options and change the “Main Axis” to “Axis 2” to get the axes on the right side.

Click on the “+” in the graph and check the box for “Second horizontal axis” from the arrow on the right side of “Axis” to get the axis.

If it’s a two-axis graph, the left and right tick marks will be different, but in this case they are the same, so we will align the numbers.

Click on a number, click on “Axis Options,” click on “Axis Options,” and set the boundary value and units.

Click on a number in the graph and change “Axis Options” -> “Bar Chart Mark” -> “Tick” -> “Tick Type” to inward. Do the same for the other locations.

Adjust axis color, etc. (easy to forget)

In the image, we forgot to set the right vertical axis to inside, but suppose we change all of them to inside.

Click on the part of the number you don’t need and select “Axis Options” -> “Label” -> “None”.

If you are not using a 2-axis graph, you can delete the top and right.

Note that if you select the numbers and press the Delete key, the tick marks will disappear along with the numbers.

Select the remaining part of the number and change the color of the axis and text to black (for some reason the default is gray).

Go to “Axis Options” -> bucket symbol -> “Fill” -> “Axis” -> “Line (single color)” and select black.

Go to “Text Options” -> “Fill Text” -> change the color to black.

Do the same for the numbers below. I forget to do this a lot, so be careful!

The color of the axis label is also slightly off black for some reason, so adjust it.

Click on the axis label, click on “Text Options,” click on “Fill Text,” and change the color to black.

Right-click on the retyped axis label and select “Font”.

Change the font to the one specified and “OK”.

Now that the axes have been changed, the next step is to edit the plot.

Change the plot

Next, adjust the plot on the graph.

Click on the plot and select the bucket symbol -> “Marker Options” -> “Built-in” to select the shape and size.

Continue scrolling down to set the “Fill” and “Border” settings.

Is the black fill common? You can also click on just one plot to change it alone.

Change the options for the series and set the other point to no fill and no line.

Finally, select the entire graph and set the fill and border to none to complete the graph.

コメント

タイトルとURLをコピーしました