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

Fix Incorrect Formatting Using Flash Fill In Excel  Flash Fill in Excel is a new feature that was introduced in Excel 2013.  One of the cool uses of Flash Fill is to fix incorrect formatting in your text automatically.Ever had the scenario where your data is formatted differently?Example: First names starting wit...
Sparklines: Column Sparklines are new in Excel 2010 and they show a graphical representation of your data in one cell.  A Column Sparkline is best used when you have lots of data points.You can style them in different colors and add a marker for the High and Low points of your data.  As your da...
100% Stacked Column Chart: Percentage Contribution... The 100% Stacked Column chart is an extension of the Stacked Column chart in that it compares the percentage that each value contributes to a Total.For example, if you want to show the percentage contributions for the North & South sales over the last 5 years then thi...
Excel Sparklines with Excel Tables Did you know that you can include an Excel Sparkline inside an Excel Table? Well you can!To create an Excel Table you need to highlight your data and press CTRL+TSee Tutorial HereOnce you have your Excel Table you can add your Excel Sparklines inside one Column and us...