Charts in Excel - Dual Axis Chart
ฝัง
- เผยแพร่เมื่อ 25 ส.ค. 2024
- Learn how to create a chart with two axis in Excel. This example shows how to effectively chart out percentages (%'s) as well as dollars ($) in the same chart!
Want to take your basic Excel skills to the next level? Take our online course and start impressing others: www.spreadsheet...
Skip to 4:28
mvp
@@k4piii yes
Thank you for this tutorial! It really helped me!
You're very welcome!
great video! I was looking for this type of video for months
Very very helpful 👍👍👍
Glad to hear that! Thanks for the comment
Thank you so much really helpful when working on reports for my labs
Absolutèly amazing
I seriously only needed to see 4:30 to 4:37 to get what I needed which is how to create a duel axis...
Thanks
Very helpful! However I wish your voice was more clearer. Thanks anyway!
Sorry about that! Glad it helped.
Doesn't work with 3D Charts or Bar Charts (even if you create it with a line chart & attempt to convert it to a different type - the other axis vaporizes). There's not an option to specify another axis (now I recall why I hate Excel charting!)
thankyou thankyou veryucj
You're welcome!
Thank you so much for the tutorial. I have a question on Combo chart:
We have dates, duration and charge. Date: horizontal axis, Duration: First data series (column) and Charge: second data series (line). In this data, sometimes the charges is null
How to create the chart but don’t show duration if the charges is null
Thank you so much.
Thanks
No problem