Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Excel Magic Trick 804: Chart Double Horizontal Axis Labels & VLOOKUP to Assign Sales Category

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
3,235
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Sep 16, 2011

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
1. See how to add two Horizontal Axis Labels to a Column Chart
2. See the default Chart keyboard shortcut
3. VLOOKUP to Assign Sales Category like: OK, Good, Great, etc.
Related Video:
Learn Excel 2010 -"Dynamic Chart Labels": #1426

  • likes, 1 dislikes

Link to this comment:

Share to:
see all

All Comments (6)

Sign In or Sign Up now to post a comment!
  • @gds514 , I am using the F9 key to recalculate the RANDBETWEEN function.

  • @ExcellsFun - at 1:20, are you scrolling through values or are you resetting the RandBetween

  • @gds514 , what minute mark?

  • How are you scrolling through the values without the rows changing?

  • @Markblackburn86 , yes a PivotChart will do it no matter what position the column of words!

  • A Pivot chart would also be very nice to display those categories coz they will be grouped.

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more