2 things are pretty evident from this Chart

  1. Most Indians don’t eat non-veg on Tuesdays (by the way..I have no reservations !)
  2. Therefore it becomes very hard to select small data points in the chart.. unless you want to keep trying all day with the mouse


By selection I mean just clicking on the bar the represents Customers for Tuesdays. The selection could be for any reason (putting it up on the secondary axis, formatting the data series, adding data labels… etc etc)


Here is a Quick Trick!


  1. Select the Chart
  2. Go to the Format Tab
  3. On the extreme left you’ll have a drop down for all chart elements
  4. Pull that drop down and pick up whatever element you want to select in the Chart. In our case it was ‘Customers on Tuesday’
  5. Done! This nifty trick has saved me countless minutes of manually trying to select small data points!


Additional Trick: Sometimes after selecting (any element) we need to right click and often we loose the selection while right clicking, the trick is to

  1. First select the element using the format tab
  2. Then instead of right clicking press SHIFT + F10 (the shortcut for right clicking)
  3. Now this was smart wasn’t it?


More Charting Hacks

  1. Beauty Tips for your Excel Reports
  2. 5 Charting Hacks to help you work a lot faster
  3. Use Camera tool to make Dynamic Charts
  4. Dynamic Text boxes in Excel
  5. Eight (8) best Chart Formatting practices


Topics that I write about...

Download Smart Ebooks on
Excel and Power BI