Site logo white shadow

Have you noticed the NEW Charting Icons

Once a chart is drawn,  three buttons appear near its top right end. Have you noticed these charting icons? These offer very easy access to many powerful features which otherwise require you to use the ribbon.

charting icons

If these are grayed out, it means you have opened an older file. Save the file in new format and reopen it to get all these features.


image  Add chart elements

This allows quick addition or removal of …


Further options are also available through sub-menus…

image Change Chart Styles

This allows you to change the look and feel of the chart very quickly. Just hover the mouse cursor over available styles and choose the desired one. Multiple styles and different color combinations are available. DO NOT miss the Color tab.

change chart titles   image

image Filter

This one is really convenient and powerful. This was not possible so easily using existing menus. It allows you to filter individual data elements easily. You must try it out – you will love it.

image    image

If this is a Pivot Chart, filtering button is not available. (This is because, filtering buttons are available in the chart itself in case of Pivot Chart).

Queries | Comments | Suggestions | Wish list

Subscribe to Blog

Join 1,758 other subscribers

Popular articles

Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.

Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.