reopen the workbook, the x and y axis chart titles and the chart legend
move slightly toward the center of the chart. In addition, the width of the
plotted chart increases slightly if you decrease the zoom magnification,
and it decreases in size if you increase the zoom magnification. The
changes in the embedded chart become more obvious when you save and reopen
the workbook several times.
- You create an embedded a chart that contains x or y axis titles or
- You select a zoom magnification other than 100 percent.
- You save, close, and reopen the workbook that contains the chart.
changes in the chart become more apparent.
Method 1: Completely reinsert the chart. Use this method if the chart can
easily be re-created and you want to restore all the affected
chart items. To reinsert the chart, use the following steps:
a. Select the chart and delete it. Do not delete the data on
which the chart is based.
b. Select the cells on the worksheet that contain the chart
data, and click the Chart Wizard button.
c. Select the desired chart options and continue to click Next
on each screen until you reach the end of the Chart Wizard.
d. To insert axis titles, double-click the chart, click Titles
on the Insert menu, select Value (Y) Axis and Category (X)
Axis, and click OK.
Method 2: Reinsert just the titles and the legend to restore their
positions and then manually resize the chart plot area. Use this
method if the chart contains a lot of formatting and you cannot
easily re-create the chart:
a. Double-click the chart, click Titles on the Insert menu,
clear the Value (Y) Axis and Category (X) Axis check
boxes, and click OK.
b. Click the legend and delete it.
c. To reinsert the axis titles, click Titles on the Insert menu,
reselect the Value (Y) Axis and Category (X) Axis check
boxes, and click OK.
d. To reinsert the legend, click Legend on the Insert menu.
e. To resize the chart plot area, click the plotted chart
area such that the entire chart, excluding the titles and
legend, is selected, and drag the handles (the small black
boxes that appear on the selected chart) to resize the
listed at the beginning of this article. This problem was corrected in
Microsoft Excel for Windows 95, version 7.0a.
causes the titles and the legend to appear to move toward the center of the
Index tab in Microsoft Excel Help, type the following text
and then double-click the selected text to go to the "Creating charts in
ID članka: 142592 – Zadnji pregled: 14. feb. 2017 – Revizija: 1