Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Changing Chart Size.
There are two types of charts that you can create in Excel—embedded charts and chart sheets. A chart sheet occupies an entire page. An embedded chart appears on the same page as your worksheet data.
If you are working with an embedded chart, you can change the size of the chart to any size you want. You cannot directly change the size of a chart sheet; it is set to be a single page. You can modify the printed size of a chart sheet, however. (This is covered in a different ExcelTip.)
You change the size of an embedded chart as you would any other graphical object in Excel:
It is worth noting that if you hold down the Alt key as you resize the chart, the resizing is done according to the size of the cells that underlie the chart. (Try it to see what I mean.) This can be useful for using the cells as an alignment or sizing aid.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (8525) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Changing Chart Size.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Got a chart created from your worksheet? You can plot times of day in the chart if you apply the simple techniques in this ...
Discover MoreMost charts you create in Excel are based on information stored in a worksheet. You can also create charts based on ...
Discover MorePie charts are a great way to graphically display some types of data. Displaying negative values is not so great in pie ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2016-10-17 08:17:03
Sami
When making a statement above like:
"You can modify the printed size of a chart sheet, however. (This is covered in a different ExcelTip.)" a Link (URL) to that Tip is the actually required.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2017 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Comments