How are charts treated when added from library workbooks to a composite worksheet?

• A. They do not maintain original settings
• B. They retain settings if placed correctly
• C. Charts cannot be added
• D. They must be added last

Answer: (B)

When charts are added from library workbooks to a composite worksheet, they retain their original settings if placed correctly. This means that the formatting, data connections, and other configuration settings of the charts are preserved, allowing for a seamless integration into the new worksheet environment. Proper placement is crucial; ensuring that the charts are positioned in accordance with the composite worksheet's structure allows them to function as intended without any loss of visual or data integrity.

In contrast, if charts are not positioned correctly, or are added inappropriately, there is a risk that they may not display data properly or may lose some of their functionality. This aspect highlights the importance of understanding the layout and placement rules within the composite worksheet to take full advantage of the features offered by the charts.

While other options suggest limitations on the behavior of the charts, the correct understanding is that with correct placement, charts can be effectively utilized in composite worksheets without losing their original characteristics.