When you create an Excel chart you can choose from 11 different custom Chart Layouts.

This is handy if you are pressed for time and want to create a Chart with all its bells and whistles with a press of a button.

From this selection you can show your Chart with or without the following layouts:

  • Chart Title;
  • Axis Titles;
  • Legend;
  • Data Labels;
  • Data Table;
  • Axes; and
  • Gridlines

 

Give it a try!

DOWNLOAD WORKBOOK

Chart Layouts

HELPFUL RESOURCE:

728x90_en

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Apply Custom Chart Styles Excel's default Charts are bland and ugly but you can certainly spice them up to your liking.Using the Shape Styles group in the ribbon menu you can customize your Excel chart the way you or your boss wants.There are several formatting options including Shape Styles, Shap...
Logarithmic Scale In An Excel Chart When you have a large numerical range of data and you want to plot a graph, you will most probable end up with a skewed looking chart like the one below:You can use the logarithmic scale (log scale) in the Format Axis dialogue box to scale your chart by a base of 10.W...
Clustered Column Chart: 12 Month Trend An Clustered Column chart is used in Excel whenever you want to show a periodic trend that has around 12 data points.To create the Clustered Column you have to set our your data with the first column showing the periods and the second column showing the values.Below I sho...
Create a Treemap Chart With Excel 2016  Treemap Charts are one of the many new Charts available only in Excel 2016.They are very visual as it can easily show you patterns, like based on your summary of sales grouped by month.The tree branches are represented by rectangles, wherein each rectangle's siz...