debugging of secondary horizontal and secondary ordinate in Excel drawing and the step method of customizing axis label in Excel

In addition to doing some of the usual charts in the work, there will be a lot of strange chart production requirements.

Today's content mainly records how to debug the secondary and secondary axes of the excle chart, and how to customize the adjustment axis labels

First look at how to do the secondary ordinate, the work of the total two related data but inconsistent units or orders of magnitude inconsistency, this time to combine the two sets of data together will use the secondary ordinate.

For a group of purchase data, to place the number of purchases and the purchase amount in one form

First select the drawing data and then insert the data graph

Select Insert Combo Chart

Then right-click the chart and choose Change Data chart type

Then tick one of the data as the secondary coordinate

Changed data table

Another is the use of the second horizontal axis, this time two kinds of data not only can not share the ordinate, the horizontal axis can not be shared.

Data that needs to be plotted

Select the activity count data first, insert a graph (the scatter chart I inserted)

Right-click the chart, select data

Click Add

Select the added corresponding data, then click OK

Right-click the chart, select Change data table type, select Combo Chart, tick the secondary coordinates

Then click, design, add chart elements, axes, secondary horizontal axis.

Custom axis labels

Right-click the chart, select data, select the series you want to change the axis label, and click Edit. Select the axis coordinates to replace

Its axes can also be modified like this

debugging of secondary horizontal and secondary ordinate in Excel drawing and the step method of customizing axis label in Excel