For creation of dual chart we need atleast one date field and 2 measure, according to your data dual chart is not possible.
But we can acheive this by using below steps.
Create 2 workbook.
First workbook contain data of male.
Second for female
For colour range inshade put measure in colour shade in my case I have puted number of records (i.e. number of person falling in that age range).
once we are done with this then combine this 2 sheet in dashboard as below.
Hope it helps..!!
Please find attached package for more details.
Colour Shade.twbx 12.0 KB
please check the attached workbook done with sample superstore data.
follow the below procedure
i hope you are done up to below image view
Now drag Discount (bin) field on to marks card and change it to color
The View is now as shown below
Now the East Region values have one color and west region values have another color
i am assigning East region Pink and West Blue (With Shades)
go to color legend and select option Edit Colors
you will get pop up window select Purple
Now your final view is as shown below
please find attached workbook.
Ong.twbx 1.1 MB
In tableau version 9.3 is not allow to insert two measures in colours tab.
Nice feature in 10 :-)