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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Benchmark Chart in Excel 2013 Benchmark Charts or Budget Charts are a great way to show your actual sales versus your benchmark in a graphical way, highlighting the strong v weak months. There are a few steps but in Excel 2013 it has been made much easier to create these charts with the new Combo charts. ...
100% Stacked Bar Chart A 100% Stacked Bar Chart is a great way to compare a percentage that each value contributes to its total. So if we have sales rep sales for three consecutive years, we can plot this on a graph and it will show us what each sales rep´s percentage breakdown is per year. DOWNL...
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...
Line Chart: Trend with lots of data A Line Chart is used in Excel when you have lots of data points and want to show a periodic trend. An example can be company sales over the last 20 years, daily transactional sales results for the year, interest rate evolution or the population growth from the year 1900, as I ...