Home

Add second x axis to Excel 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-201259%22%20slang%3D%22en-US%22%3EAdd%20second%20x%20axis%20to%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-201259%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20use%20Excel%202016%20and%20want%20to%20add%20a%20second%20x%20axis.%20How%20do%20I%20do%20this%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-201259%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharts%20%26amp%3B%20Visualizing%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESecurity%20Policy%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-375668%22%20slang%3D%22en-US%22%3ERe%3A%20Add%20second%20x%20axis%20to%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-375668%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F267603%22%20target%3D%22_blank%22%3E%40Chilli7%3C%2FA%3E%26nbsp%3B%20-%20I%20was%20looking%20for%20an%20answer%20to%20the%20same%20question%20-%20it%20seems%20that%20this%20a%20bug%20as%20the%20clustered%20column%20chart%20now%20fully%20overlaps%20and%20obscures%20the%20shorted%20bar.%26nbsp%3B%20I%20have%20work%20around%20this%20by%20changing%20the%20Gap%20Width%20on%20one%20series%20(to%20make%20its%20column%20wider%20than%20the%20other)%20and%20making%20the%20Fill%20transparent.%26nbsp%3B%20Not%20ideal%20but%20at%20least%20both%20series%20are%20visible.%26nbsp%3B%20%3A%2F%3C%2FP%3E%3CP%3EHope%20MS%20fixes%20the%20bug%20or%20we%20find%20a%20better%20solution.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-319998%22%20slang%3D%22en-US%22%3ERe%3A%20Add%20second%20x%20axis%20to%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-319998%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20make%20a%20clustered%20column%20chart%20with%20two%20axis%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20soon%20as%20I%20add%20a%202nd%20axis%20excel%202016%20converts%20the%20chart%20type%20to%20combo.%20And%20the%20plotted%20columns%20of%20each%20series%20overlap%20each%20other%20instead%20of%20being%20on%20next%20to%20the%20other.%3C%2FP%3E%3CP%3EHow%20do%20I%20make%20the%202axis%20variant%26nbsp%3Blook%20like%20the%201axis%20variant%20(except%20the%20scaling)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EChilli%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-201306%22%20slang%3D%22en-US%22%3ERe%3A%20Add%20second%20x%20axis%20to%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-201306%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20check%2C%20for%20example%2C%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D84Al7vxBJCU%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D84Al7vxBJCU%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-201300%22%20slang%3D%22en-US%22%3ERe%3A%20Add%20second%20x%20axis%20to%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-201300%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20you%20please%20provide%20a%20click%20by%20click%20guide%20%3F%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3EHi%20Peter%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFormat%20one%20of%20your%20series%20to%20plot%20on%20secondary%20axis%2C%20both%20vertical%20and%20horizontal%20secondary%20axis%20will%20be%20available%2C%20you%20may%20hide%20vertical%20and%20show%20only%20horizontal%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-201294%22%20slang%3D%22en-US%22%3ERe%3A%20Add%20second%20x%20axis%20to%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-201294%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Peter%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFormat%20one%20of%20your%20series%20to%20plot%20on%20secondary%20axis%2C%20both%20vertical%20and%20horizontal%20secondary%20axis%20will%20be%20available%2C%20you%20may%20hide%20vertical%20and%20show%20only%20horizontal%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Peter Havord
New Contributor

Hi,

 

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

5 Replies

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 

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 


 

Please check, for example, here https://www.youtube.com/watch?v=84Al7vxBJCU

In this video, I will show you how to add secondary vertical and horizontal axes in graphs when using Microsoft Excel (2007, 2010, 2013, 2016). I am using MS Excel 2013 but it should work with other versions of Excel. ------------------------------------------------------------------------- If ...

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

@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.

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies