Chart & Data Validation help

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
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 :biggrin:
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
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
 

Watch MrExcel Video

Forum statistics

Threads
1,114,041
Messages
5,545,679
Members
410,697
Latest member
srishtijain0708
Top