1. Dual Axis Excel Chart
2. Excel Charts Secondary Axis

Dual Axis Excel Chart

Had the same trouble, but in 2013/2016 there is no 'Layout' tab under Chart Tools anymore. I FINALLY found a solution: Chart Tools - Add Chart Element - Axis - Secondary Horizontal This will separate out the x-axis so that your secondary axis will appear above the chart grid itself. Right click on that new x-axis and select 'Format Axis'. Under Axis Options, and Axis Position, you will see the On Tick Marks or Between Tick Marks options. Choose the On Tick Marks.

Excel Charts Secondary Axis

Then you can go back and turn off the Secondary Horizontal option. Avb top shot pegasus driver for mac. This will bring you back to just one normal X-Axis and your lines/areas will stretch from one end of the chart to the other!