What is in this lesson?
- Need for interactive charts
- Introduction to form controls
- Using Scrollbar control
- using checkboxes
- Example interactive charts (2)
Author: Chandoo
My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions.
I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here.
I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.
Dynamic Charts in Excel
What is in this lesson?
- Need for Dynamic Charts
- Dynamic charts using Filters
- Dynamic charts using camera tool
- More info. & ideas on dynamic charts
7 Advanced Charting Tutorials in Excel
What is in this lesson?
- Bullet chart – what is it and how to make
- Incell charts – using REPT to make charts
- Min-Max chart – showing range along with average
- Waterfall charts
- Time line charts
- Thermo-meter charts
- Gauge Chart
Bar & Column Chart Formatting
What is in this lesson?
- Overlapped Bar Charts, Understanding Series Gaps
- Negative bars
- Highlighting the max or minimum item automatically
- Adding average line to the chart
Chart Formatting – 10 Tips
What is in this lesson?
- Making titles dynamic
- Reversing categories
- Adjusting axis – (non-date)
- Adjusting axis – (date)
- Removing axis, grid lines, legend
- Combining 2 chart types
- Adding secondary axis
- Error bars, adding and formatting them
- Choosing right colors
- Chart Templates
Introduction to Excel Charts
What is in this lesson?
- Understanding Excel Charting Options
- Bar Charts / Column Charts
- Line Charts
- Scatter Plots
- Pie Charts
- Other Charts in Excel
How to Select Correct Chart
What is in this lesson?
- Basics of Chart Selection – Rationale
- Common Messages for charts
- Which Charts to use
- Further help & Tips on Chart selection
Conditional Formatting – 3
What is in this lesson?
- Conditional Formatting & Dates
- Conditional Formatting and Duplicate Data
- Complex CF Examples
Conditional Formatting – 2
What is in this lesson?
- Advanced CF Options
- Using Icons
- Using Data Bars
- Using Heat-maps
- Highlighting Top 5, above average etc.
Conditional Formatting – 1
What is in this lesson?
- What is Conditional Formatting?
- Basic CF with values
- Using Formulas in CF
- Examples of CF