An excel program for a master s answer

What are you trying to answer?

This is an auto-recorded macro that just copies and pastes data between a few **s.

I'm also a newbie, so I studied together and helped you translate. You should have recorded this yourself, a lot of superfluous things)

range("a3:m26").select

Select the A3 to M26 region.

Duplicate the selection area.

down:=-6

The scrolling window slides down 6 lines; It's useless, it should be recorded during recording.

windows("").activate

Select the file. down:=-9

The scrolling window slides down 9 rows.

range("a3").select

Select the A3 region.

paste:=xlpasteformulas, operation:=xlnone, _

skipblanks:=false, transpose:=false

Paste the content you copied earlier into the selection area.

down:=21

Scroll through the window. windows("").activate

Select the file. range("j30:m32").select

Select the J30 to M32 region.

false to copy the selected region.

windows("").activate

Select the file. range("j30:m32").select

Select the J30 to M32 region.

paste:=xlpasteformulas, operation:=xlnone, _

skipblanks:=false, transpose:=false

Paste the content you copied earlier into the selection area.

sheets("Record").select

Switch to the Records workbook.

windows("").activate

Toggle files. windows("").activate

Toggle files. Close the file. end sub

The steps are as follows:

Select the three columns of data: Project, Budget, and Total. Menu bar [Insert], [Recommended Charts], [All Charts], [Bar Charts], get the following chart.

Select the series of orange columns, right-click [Set Data Series Format], the series is drawn on the [Secondary Axis], select the upper secondary axis and delete the button, the effect is as follows:

Select the series of blue columns, right-click [Set Data Series Format], adjust the [Gap Width] to 70% (adjust according to your actual needs), and narrow the gap, as shown below

Finally, the fill color of the blue column series was adjusted to no fill, the border was changed to black, and the longest three orange columns were filled with red (left-click on the column first, and then left-click once to select a column). The final product is as follows: