Mr Excel & excelisfun Trick 115: Plot Chart, Show Only Selected Employee Name Is Axis

4,084 views · Published 8 March 2013 · 6:20 · Indexed 25 October 2026

Channel: excelisfun · 2013 · Education

Watch on YouTube

Download Files:
https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MrExcelExcelisfunTrick115.xlsx

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
See Mr Excel and excelisfun use two methods to plot all the sales for all the employees, but show only the employee name of selected employee ID. See IF functions and VLOOKUP. Hide all axis labels except for the one selected employee

More from this channel

• 3:51 YouTubersLoveExcel#19: Steady Growth Cash Flow Formula

  excelisfun

  3,560 views · 23 May 2008

• 3:44 YouTubersLoveExcel#26: Text To Column Trouble

  excelisfun

  3,596 views · 30 May 2008

• 3:41 YouTubersLoveExcel#26.2: Formulas do not like TEXT Time

  excelisfun

  2,016 views · 6 June 2008

• 3:30 YouTubersLoveExcel#34: Hide Columns Copy Problem

  excelisfun

  3,877 views · 11 June 2008

• 9:27 YouTubersLoveExcel#31: Dates, Cash Flow & Logic

  excelisfun

  4,909 views · 11 June 2008

• 1:57 YouTubersLoveExcel#36: VLOOKUP increase based on Rating

  excelisfun

  3,053 views · 16 June 2008

• 7:38 YouTubersLoveExcel#52: VLOOKUP & Workbook References

  excelisfun

  3,914 views · 7 July 2008

• 1:39 YTLE#60: Hide Columns by Grouping

  excelisfun

  4,807 views · 18 July 2008