
Please download the supplementary materials as displayed on the Window to the right. It contains Excel file for practice and PDF handbook for reference.
This Video explains the elements of the Charts - Chart Area, Plot Area, Axis Values, Gridlines, Legends etc. in addition to some of the important settings and shortcut keys.
_______________________________________________________________
Advanced Excel for Professionals - https://www.udemy.com/excelnext_excel/?couponCode=XL66
_______________________________________________________________
Axis Value Settings and formatting tricks
Applications:
Comparing 2 parameters of similar scale:
2011 vs. 2012 sales
Budget vs. Actual
Me vs. My Competitor
Key Steps:
Series Overlap
Fill -> No Fill
Border Color (Solid Line) & Border Styles (Width)
Applications:
Comparing 2 parameters of different scale:
GDP ($) vs. Growth or Inflation (%)
Sales Amount ($) vs. Profit Margins (%)
Key Steps:
Plot Series on
Change Series Chart Type (Line with Markers)
Applications:
Components of a Category (%):
Headcount
Source of Funds
Sales Origination
Key Steps:
Format Data Series – Rotation and Pie-explosion
Applications:
Trend:
Profit
Sales
Clients’ / Subscribers’ acquisition (e.g. Telecom)
Key Steps:
Chart Tools -> Layout -> Trend line -> Two-period Moving Average
Format Axis -> Axis Labels -> High
Format Labels -> Numbers (e.g. no. of decimals – 0, 1, 2)
CALLOUTS Shapes
Applications:
Relation (80:20 comparison):
Sales and Profit
Input and Output
Key Steps:
Switch Row/Column
Lines -> Series Lines
_______________________________________________________________
Advanced Excel for Professionals - https://www.udemy.com/excelnext_excel/?couponCode=XL66
_______________________________________________________________
This trick will allow you to replicate a report format for 100s of items in a category. E.g. Sales report customer-wise in individual worksheets.
Join our "Advanced Excel for Professionals" program for numerous tricks like this.
CA. Rishabh Pugalia (Founder, Excel Next) presents a crisp Online Training Program on Excel Charts.
The program covers popular charts like Thermometer Charts, Exploded Pie Charts, 2-axis Charts, 80:20 Stacked Column Charts, Trendline in addition to intricate settings and shortcuts.
The accompanying eHandBook will help you recollect the steps to make these Special Charts and it also enumerates the key application areas. In other words, when to use which chart.
His training program on Advanced Excel can be accessed from this UDEMY link - Click Here.