Jun 06 2018
01:10 AM
- last edited on
Jul 25 2018
09:52 AM
by
TechCommunityAP
Jun 06 2018
01:10 AM
- last edited on
Jul 25 2018
09:52 AM
by
TechCommunityAP
Hi,
I use Excel 2016 and want to add a second x axis. How do I do this ?
Jun 06 2018 03:34 AM
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
Jun 06 2018 04:16 AM
Can you please provide a click by click guide ?
@Sergei Baklan 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
Jan 17 2019 02:26 AM - edited Jan 17 2019 02:42 AM
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
Mar 16 2019 07:13 AM
@Chilli7 - I was looking for an answer to the same question - it seems that this a bug as the clustered column chart now fully overlaps and obscures the shorted bar. I have work around this by changing the Gap Width on one series (to make its column wider than the other) and making the Fill transparent. Not ideal but at least both series are visible. :\
Hope MS fixes the bug or we find a better solution.
Jan 08 2020 08:29 AM
Jan 08 2020 08:42 AM
@Peter Havord I found a workaround for the bug in the Excel menus. The help is just wrong (it should be right, but the menu apparently has a bug).
1. Select the series you want to add a secondary axis for
2. Right-click (two-finger tap) on the series
3. Select "Format Data Series..."
4. In helper window on the right, you can choose to plot the series on primary or secondary axis.