Column chart with % and currency

Here is one way of getting what you want.

1. Add three columns to your chart, format two as percentages and the other as currency:

2. Insert a chart (doesn't really matter what kind for now)

3. Right-click on it and choose "Select Data..." from the pop-up menu

4. Click on "Switch Row/Column so that the column headers (demand, export, etc...) are on the left hand side

5. Move the "filler" series up until they are just below the "demand" series

6. Click "OK", then right-click on the chart and select "Change Chart Type..." from the pop-up menu

7. Select Combo chart as the chart type

8. Select "Clustered Columns for all Series, and check "Secondary Axis for the first three.

9. Click "OK"

10. In the legend, select and delete the legend entries for the filler series

And you're done