In the 44th session of Chandoo.org podcast, let’s talk about failures.
What is in this session?
In this podcast,
- Book announcement about Dashboards for Excel
- Story of my first ever dashboard
- Important lessons – Requirement Analysis for dashboards
- Resources for creating awesome dashboards
- Podcasts
- Books
- Courses
Listen to this session
Podcast: Play in new window | Download
Subscribe: RSS
Click here to download the MP3 file.
Resources to make awesome dashboards
Podcast episodes:
- Create awesome dashboards with this 10 step process
- Make better charts by optimizing Data to Ink ratio
- Rules for making legendary column charts
Books on Dashboards:
- Information dashboard design by Stephen Few
- Non-designers design book by Robin Williams
- Dashboards for Excel by Jordan & Chandoo
Courses:
- Excel School + Dashboards – Online classes from Chandoo
Excel School, is a comprehensive online course to help you become awesome in all aspects of data analysis, visualization, interactive workbooks, dashboard reporting and automation.
In this course, you will learn to:
- Analyze data using simple & advanced formulas in Excel
- Structure & process large volumes of data quickly using tables & pivot tables
- Present information using charts, interactive & dynamic charts and complex charts
- Create dashboards using 8 in-depth tutorials & case studies
- Make gorgeous workbooks using conditional formatting, color & font choices and more
- Develop workbooks faster: using my favorite tricks and productivity hacks
Please click here to know more about Excel School and enroll
Transcript of this session:
Download this podcast transcript [PDF]
Help our community & me learn more by sharing your mistakes
It’s your turn. Share the mistakes you made during data analysis, dashboard preparation or automation projects. Let’s all learn from these and become stronger.
8 Responses to “Create a Combination Chart, Add Secondary Axis in Excel [15 Second Tutorial]”
[...] Select the “daily completed” column and add it to the burn down chart. Once added, change the chart type for this series to bar chart (read how you can combine 2 different chart types in one) [...]
[...] set the height series to be plotted on secondary axis. Learn more about combining 2 chart types and adding secondary axis in [...]
[...] Excel Combination Charts – What are they? [...]
[...] To show the years, I have used another dummy series and plotted it on secondary axis (related: how to add secondary axis?) [...]
Thanks for this one!
[...] Choisissez la colonne « Daily Completed » et ajoutez-la au graphique. Une fois ajoutée, changez le type de graphique pour cette série à histogramme (lisez comment combiner 2 types de graphiques en un : combine 2 different chart types in one) [...]
How do i create a chart that has negative numbers on axis x and y and plot them correctly? I cannot seem to understand how to do this, please help.
Thanks.
Nat
You can also plot 2 or more Y axes in Excel using EZplot or Multy_Y from Office Expander.com
There is a demo version to try.
Cheers.