Link Charts from tabs to Summary tab including Combo Box

[Thomas Kuriakose]

Respected Sirs,

Kindly let me knowhow to link the two charts in Open requisition tab and Open Purchase order tab to the Summary tab, with all the features in the chart (text box, combo box and the interaction).

When I copy this to the summary tab, it works but without the features.

Thank you very much,

with regards,
thomas

 

[Hui]

Thomas

The Input Range: and Cell Link: dialogs in the Controls have to have the Full path, including the Worksheets names
Otherwise it assumes the Ranges are on the current worksheet, which they aren't



See attached file

 

[Thomas Kuriakose]

Respected Sir,

Thank you very much for this solution provided.

Much appreciated

Sir, is it possible to link the same chart in both the summary and open requisition and open purchase order tabs respectively.

Thanks once again,

with regards,
thomas

 

[Hui]

Yes

Make sure you use the Worksheet names in the Series definitions
='Worksheet name'!Range
as appropriate for each Range

Hui...

Respected Sir,

Thank you very much for this solution provided.

Much appreciated

Sir, is it possible to link the same chart in both the summary and open requisition and open purchase order tabs respectively.

Thanks once again,

with regards,
thomas

 

[Thomas Kuriakose]

Respected Sir,

Thank you very much for this information.

with regards,
thomas