Add Secondary Axis in Excel Charts (in a few clicks)

Рет қаралды 62,640

Күн бұрын

In this video, I will show you how to quickly add a secondary axis in an Excel Chart.
You can use the recommended chart feature (available in Excel 2013 and later versions). With this feature, it may automatically show you a chart that has a secondary axis. All you have to do is click on that chart and it will be added to the worksheet.
The other way is to manually select the series you want to plot on a secondary axis and select the secondary axis option in the Format Series options.
This video is a part of my 'Excel is two-minute' series, where I share simple and quick tips to help you speed up your work and be more efficient
Subscribe to this KZfaq channel to get updates on Excel Tips and Excel Tutorials videos - / trumpexcel
This KZfaq channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel.
It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.
You can find a lot of useful Excel resources on the following site: trumpexcel.com/
Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: kzfaq.info...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 29

@simantajyotithapa3434 9 ай бұрын

bhai deadline me bacha diya, thank you ❤

@puneetvij8433 4 жыл бұрын

Sumit Sir, I faced this problem 06 months ago. You are making video on real time MS Excel job problems and doing a great job. ; )

@trumpexcel 4 жыл бұрын

Thanks for commenting Puneet... Glad you found the videos useful :)

@santidiaz4397 2 жыл бұрын

Very well and easy explained. Thanks!

@pagadalaa6155 Жыл бұрын

Thanks ..so much time saved

@dmuralidhar4680 4 жыл бұрын

Sir today's video is very amazing and useful to me thanks for the video Sir

@a_rjun332 2 жыл бұрын

This is what I was looking for

@wayneedmondson1065 2 жыл бұрын

Thanks Sumit!!

@TheChicagoTodd 2 жыл бұрын

Great video...thank you

@bucketsshuckets 2 жыл бұрын

Thank you!

@Up4Excel 4 жыл бұрын

Great stuff Sumit - love the recommended charts tip for getting there super fast. Wish I spotted that before I did my 2 axis chart video. TAB between series is also another great tip 💙👍💚

@trumpexcel 4 жыл бұрын

Thanks for commenting... Glad you liked the video :)

@eggsy8271 3 жыл бұрын

Thanks!

@kidsvideos3742 8 ай бұрын

thanks

@Playtam8 3 жыл бұрын

Super tuto

@mmmmsasa 3 жыл бұрын

i need 2 same column with different axis???

@kidsvideos3742 8 ай бұрын

can you make video, how to add target bar with the chart like this.

@balachandarp5978 2 жыл бұрын

easy boss .....

@shuxrat2600 3 жыл бұрын

how do you make the bars from the second axis?

@hemantyetkar6314 2 жыл бұрын

Your subtitles are covering it all

@noorsk2348 Жыл бұрын

👍👍👍

@juliaprzytula4851 2 жыл бұрын

Hello, do you know the statistical name of this graph??

@shrijenpuvaneswaran3297 4 жыл бұрын

I want both of them are bar chart and it should be arrange in back to back .. how can I do it???

@Up4Excel 4 жыл бұрын

You can show one bar in the other pretty easily by changing the gap width. Look at 'How to Create 2 Axis Chart in Excel ' in #up4excelcharts to see if that is what you mean?

@shrijenpuvaneswaran3297 4 жыл бұрын

Thank you for replying my cmt... I will check it sir