Forum Discussion

Peter Havord

Copper Contributor

Jun 06, 2018

Add second x axis to Excel 2016

Hi, I use Excel 2016 and want to add a second x axis. How do I do this ?

Charts & Visualizing Data

Security Policy

SergeiBaklan

Diamond Contributor

Jun 06, 2018

Hi Peter,

Format one of your series to plot on secondary axis, both vertical and horizontal secondary axis will be available, you may hide vertical and show only horizontal

Peter Havord
Copper Contributor
Jun 06, 2018
Can you please provide a click by click guide ?
SergeiBaklan wrote:
Hi Peter,

Format one of your series to plot on secondary axis, both vertical and horizontal secondary axis will be available, you may hide vertical and show only horizontal
- SergeiBaklan
  Diamond Contributor
  Jun 06, 2018
  Please check, for example, here https://www.youtube.com/watch?v=84Al7vxBJCU
  - Chilli7
    Brass Contributor
    Jan 17, 2019
    How do I make a clustered column chart with two axis?
    
    As soon as I add a 2nd axis excel 2016 converts the chart type to combo. And the plotted columns of each series overlap each other instead of being on next to the other.
    How do I make the 2axis variant look like the 1axis variant (except the scaling)?
    
    Regards
    Chilli