Combo Boxes

[MarkAndrews]

Can these be placed on charts?

TIA

 

[SteveO59L]

Yes

 

[MarkAndrews]

Thanks

 

[MarkAndrews]

I have a validation cell on a data sheet which is the control for all the Hlookups i have (the Hlookups work from this validation)

Is possible to put a sort of validation option on my charts (similar to the validation in the data sheet) January - December & have my charts change as this is changed by the user?

I've never done this before?

 

[MarkAndrews]

anyone?

 

[SteveO59L]

Use a combo box, linked to a cell

 

[DominicB]

Hi Mark

You can't place a data validation drop down in a chart 'cos it's a cell - try and drag it to a chart and it will be hidden by the chart. Combo boxes (both Form and Control Toolbox type) are the opposite, they will sit on top of the graph, so although they are not part of the graph object they can be used to control it.

HTH

DominicB