Steps to make a bar chart of different widths in an Excel chart

How to create an unequal width column chart in Excel chart

The technique used here is mainly the universal scatter plot.

Let’s first observe the characteristics of the chart:

This chart satisfies the quantitative relationship regardless of height or width. It is a bit difficult to implement a regular bar chart...

Crack:

Any two points in the coordinate system can naturally construct a fixed rectangle, so columns with unequal widths also have such vertices.

tidy:

A histogram has thus become a structure supported by scatter points, and the parameters of the four points we need can be easily solved.

Data construction:

X value, that is, the horizontal distance is obtained by accumulation;

Y value is the year-on-year sales, plus the length-to-width ratio

The proportions here are up to your liking, and you can also use the golden section.

Insert a blank scatter plot:

Right-click on the scatter plot and select data.

In the Select Data dialog box, click the Add button.

Add X-axis and Y-axis data respectively.

Insert rectangle, set to no fill:

Use the points of the scatter plot as the vertex corners, align and expand them in order to make four rectangles...

Then you can take away the scatter plot and use these 4 rectangles to directly make a column chart of unequal width.

Finish.

For drawings, you are not limited to making them with chart tools. You can also use drawing to splice them. Finally, a little subversion is also a new idea.

What to do if the histogram indicator is a wide column but actually a narrow column

Enter some simple data casually, click Insert - Column Chart in the menu bar, and select the first subgraph

In this way, you can see the column chart you made, but the width of the columns of the column chart added by default may not be beautiful enough, so we need to modify it when we beautify the column chart

Select the column of the column chart, right-click in the pop-up selection box, and select the last item to set the data series format

In the pop-up Format Drawing Area dialog box, you can see the category spacing in the first series option

Increase the value from the default 150 to 200, click Close, and you can see that the column width of the column chart has become narrower. On the contrary, if we decrease the value from 150 to 100, you will find that the column width of the column chart has become narrower. The pillars have become wider

In this way, we can adjust the width of the columns in the column chart by adjusting the appropriate value, and then beautify the bar chart we prepared

Excel Tips:[4]How to modify the width of the histogram columns

The above is the detailed content of Steps to make a bar chart of different widths in an Excel chart. For more information, please follow other related articles on the PHP Chinese website!