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

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...
Excel Cycle Charts Cycle Charts in Excel are easy to create using the Smart Art feature. There are several cycle process charts to choose from, some have arrows, like the Basic Cycle, and others show the relationship to a central idea, like the Radial Cycle. Here is how you insert a Radial Cy...
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+T See Tutorial Here Once you have your Excel Table you can add your Excel Sparklines inside one Column and us...
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...