![]() ![]() Now, if we delete a column, the chart shifts on the worksheet. Let's try the second option, "Move but don't size with cells." Note that by default, the chart will both move and resize with cells. In the dialog, click Properties.Īt the top are options for Object positioning. This will open the Format Chart Area dialog box. ![]() Click the Format Selection button on the Chart Tools Layout tab. You can control this behavior by adjusting the chart's position property. If we increase or decrease row heights, the chart automatically expands and contracts. We can see this behavior in action if we increase or decrease the width of any columns underneath the chart. In this lesson we'll show you how to adjust the size and location of a chart.īy default, Excel charts will automatically move and resize when cells underneath them change. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |