Its Friday, time for another poll.
This weeks topic is inspired from a discussion Jordan started in our forums (#).
What is your favorite feature of Excel?
I will go first.
My favorite features are,
- Conditional formatting: Quickly highlight something that is not alright (or meets conditions), see trends with data bars or heat maps.
- Pivot tables: Turn data in to understandable information with just a few clicks. When combined with slicers & conditional formats, becomes very powerful.
- Formulas: Ofcourse, with out formulas, Excel would be a glorified notepad!
What about you? What are your favorite features in Excel? Go ahead and tell us by posting a comment.
PS: If you are reading this in our newsletter or RSS Reader, click here to share your favorite features.
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.