MarkAndrews
Well-known Member
- Joined
- May 2, 2006
- Messages
- 1,970
- Office Version
- 2010
- Platform
- Windows
Can these be placed on charts?
TIA
TIA
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Combo Boxes
- Thread starter MarkAndrews
- Start date
Excel Facts
Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
MarkAndrews
Well-known Member
- Joined
- May 2, 2006
- Messages
- 1,970
- Office Version
- 2010
- Platform
- Windows
Thanks
Upvote
0
MarkAndrews
Well-known Member
- Joined
- May 2, 2006
- Messages
- 1,970
- Office Version
- 2010
- Platform
- Windows
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?
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?
Upvote
0
MarkAndrews
Well-known Member
- Joined
- May 2, 2006
- Messages
- 1,970
- Office Version
- 2010
- Platform
- Windows
anyone?
Upvote
0
DominicB
Well-known Member
- Joined
- Oct 3, 2005
- Messages
- 1,569
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
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
Upvote
0
Similar threads
- Question
