Chart & Data Validation help

[MarkAndrews]

I have a chart which changes when the user selects a different option from a validaton cell

I have seen charts with this validation option on the chart

How is this done?

TIA

 

[Krishnakumar]

Hi,

See here

 

[MarkAndrews]

I'll take a look, thankyou

 

[MarkAndrews]

Thanks Krishna

But i am still non the wiser?

I have the combo box on my chart, its linking the source data to this that puzzles me

 

[MarkAndrews]

BTTT

 

[Andrew Poulsom]

You can add a ComboBox from the Forms Toolbar to a Chart:

http://peltiertech.com/Excel/Charts/ChartByControl.html

 

[MarkAndrews]

You can add a ComboBox from the Forms Toolbar to a Chart:

http://peltiertech.com/Excel/Charts/ChartByControl.html

Thanks Andrew

I have a ComboBox on my chart, the thing which puzzles me is how to get the chart working from this

I'll have a read of the link you posted

Thankyou