You can always resize any chart to make it bigger or smaller. To resize a chart, follow these steps:
1. Move the mouse pointer over any corner of the chart until the mouse pointer turns into a two-way pointing arrow.
2. Hold down the left mouse button and drag (move) the mouse to shrink or expand your chart.
3. Release the left mouse button when you're happy with the new size of your chart.
Using the Chart Tools
As soon as you create a chart or click on an existing chart, Excel displays the Chart Tools tab, which provides tools organized into four categories:
Type: Lets you change the chart type
Data: Lets you change the source where the chart retrieves its data or switch the data from appearing along the X-axis to the Y-axis and vice versa
Chart Layouts: Lets you change the individual parts of a chart, such as the chart title, X - or Y-axis labels, or the placement of the chart legend (top, bottom, left, right)
Chart Styles: Provides different ways to change the appearance of your chart