Enter the appropriate dimension values using the Shape Height and Shape Width options in the Size group.Įxcel assigns the size settings to all of the selected charts, not just one.Click the contextual Format tab. In Excel 2003, right-click the selection, and choose Format Object.

Select all of the charts by holding down the key as you click each chart to create a multiple selection.To assign the same size dimensions to all of the charts at the same time, do the following: In Excel 2003, right-click the chart and choose Format Object. Excel will display the selected chart’s dimensions in the Size group. If one of the charts is about the right size, select it and note its dimensions by clicking the contextual Format tab. Let’s illustrate this simple manual technique on the charts shown below. Fortunately, you can create a multiple selection and enter the appropriate size dimensions for all of the charts, at once. There’s not much work to forcing a chart’s size after the fact, but the task might become redundant if you have several charts or if you have to resize a few charts often. So, you might want to adjust the size of each chart so they’re all the same. When you create a chart, Excel adjusts the chart’s size, depending on space, labels, number of data points, and so on.

For more info, visit our Terms of Use page. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. You can do so manually or by using the easy macro. Quick Tip: Apply a uniform size to all charts on an Excel sheetĪfter adding several charts to a sheet, you might want to adjust their sizes so they're all the same.

How to make a pie chart in excel 2003