excel2010 bi-directional bar chart making

This tutorial introduces you to the excel2010 excel2010 bidirectional bar chart production method.

1. Selected work area

2. Click Insert--> Chart, select bar chart

3. For the beautiful can be the middle vertical bar can be removed

4. The method is to select the vertical bar, right click--> Delete

5. Next to the legend, select the legend, right-click--> format legend--> legend options--> (legend position)

6. We select a column to create the secondary axis, where you choose the blue

7. Right-click the Blue area--> set the data series format--> the secondary axis

Click Close After