Excel Combo Chart: How to Add a Secondary Axis

Excel Combo Chart: How to Add a Secondary Axis

Eric Andrews

6 лет назад

255,974 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@robertkostka2035
@robertkostka2035 - 05.08.2023 21:51

I was looking for scaling... thank you!

Ответить
@jonpetter8921
@jonpetter8921 - 24.02.2023 16:42

What if we add a fourth axis about temperatur (celcius)for instance.

Ответить
@robl417
@robl417 - 19.11.2022 03:41

Very helpful. Thank you.

Ответить
@abdullahalmamun-kk5bb
@abdullahalmamun-kk5bb - 26.09.2022 21:40

so helpful

Ответить
@antoniobacic5674
@antoniobacic5674 - 19.08.2022 09:34

This helps, thanks a lot.
PS Pleasant to listen to.

Ответить
@FRANKWHITE1996
@FRANKWHITE1996 - 19.05.2022 21:49

Exactly what i needed today. Thanks 🙌

Ответить
@vladimirmoravek6749
@vladimirmoravek6749 - 12.01.2022 01:24

nice video, is it somehow possible to overlay both X axis? I mean, that when I set up overlay 100% I will still be able to see orange over the blue vertical line.

Ответить
@HeadBeeGuy
@HeadBeeGuy - 20.12.2021 18:51

Super helpful! Thank you for this video.

Ответить
@lawrencekazibwe9751
@lawrencekazibwe9751 - 07.11.2021 14:57

Thanks alot Boss, very informative

Ответить
@videovoice4622
@videovoice4622 - 20.10.2021 14:48

thanks for teaching me how to put the label low!!!

Ответить
@joelong4650
@joelong4650 - 19.10.2021 20:31

I'm trying to put together a line graph comparing five different teams performance on one of our priority metrics. I have a graph depicting their daily performance throughout the month. I would like to add their current average displayed as a dot on the far right side of the chart with the color corresponding with that of their line.

I have not found a video with this information so I was wondering if you have a video you could direct me to or any ideas as to how to accomplish this something of a similar effect.

Ответить
@lankylankster7148
@lankylankster7148 - 09.09.2021 00:40

THANK YOU, Eric! It helped that you taught how to reposition the horizontal labels to a lower position so they're distinguished from the more visual parts of the graph (vertical bars and horizontal % line). LL

Ответить
@MrRajnishdwivedi
@MrRajnishdwivedi - 16.07.2021 21:44

Thank you very very much for such clear and concise explanation 👍!!!!

Ответить
@AADIBAWA
@AADIBAWA - 04.06.2021 21:44

but how i can create chart if i have more than 500 rows ???

Ответить
@keyurpatel498
@keyurpatel498 - 23.05.2021 01:40

good video of graph

Ответить
@-SUDHARSANAS
@-SUDHARSANAS - 25.04.2021 09:25

Thank you sir

Ответить
@nomunacc2235
@nomunacc2235 - 21.02.2021 10:13

there is no combo chart type in my chart6. What can i do?

Ответить
@docdaven
@docdaven - 12.11.2020 05:26

how did you get Sales and Net Profit to show side-by-side? No matter what I do, the bars overlap. All I want is 2-axes both sets with separate bars (no lines) and then, ideally, somehow show it in 3D (though it looks like 2 axes aren't supported in Excel 2013)

Ответить
@amiramedhat3107
@amiramedhat3107 - 28.08.2020 11:01

For some weird reason, the dates don't show up at the bottom of my chart which messes up the chart and i don't know how to fix that..

Ответить
@ghazalahashmi9215
@ghazalahashmi9215 - 27.06.2020 06:45

I don't understand

Ответить
@celltrey
@celltrey - 02.06.2020 18:57

hey how do you get to all charts in the new excel

Ответить
@youssrael2527
@youssrael2527 - 02.06.2020 13:00

Thank you so much

Ответить
@patrickcordero6673
@patrickcordero6673 - 01.06.2020 09:28

my 2010 excel doesn't have this deature? what is your version?

Ответить
@jsrockin
@jsrockin - 21.05.2020 17:33

What if I want conversion rate axis on left and money on left side

Ответить
@barbaramillet4544
@barbaramillet4544 - 07.02.2020 19:05

Thank you, Thank you, Thank you!

Ответить
@midoterminator
@midoterminator - 15.11.2019 05:00

please i have urgent question in charts that stops my work could you help me please

Ответить
@suzy5166
@suzy5166 - 26.09.2019 17:36

Thanks very much... very useful...
🙏🙏🙏

Ответить
@EdwinKG
@EdwinKG - 13.09.2019 04:38

Thank you, for helping.

Ответить
@babatundekozeem1649
@babatundekozeem1649 - 11.07.2019 04:11

Thanks for the insightful video. I will like to ask if it it possible to have one of say five series to be on the secondary axis (line graph) while the remaining four series remain in a starked column not clustered as you have brilliantly shown in this video. Thanks

Ответить
@thmagd
@thmagd - 30.05.2019 19:04

Hello Eric, your videos really helps, thanks for uploading. Could you please do the video of how to do an animation with powerpivot, I couldn't find any videos on the internet.

Ответить
@heatherwilson9886
@heatherwilson9886 - 13.06.2018 00:34

Hey Eric, I have a graph with historical data and projected data. I currently have this as a scatter plot with two sets of data. My boss would like the historical data to be columns, but when I convert the historical data to columns, the historical and projected data overlaps. Anyway to have column and scatter on two separate sets of x values?

Ответить
@cursodeexcelonline
@cursodeexcelonline - 18.12.2017 01:41

Very good Eric

Ответить