Sure! but I can't find where to add a file. So I'm copy-pasting some made-up numbers. Hope it will work
City rent vacancy Vancouver 1281 6.0 Calgary 1224 2.0 Toronto 1213 6.8 Edmonton 1141 3.2 Ottawa 1132 4.4 Victoria 1068 5.0 Kingston 1054 5.7 Barrie 1048 2.4 Saskatoon 1041 5.0 Regina 1018 2.5 Oshawa 985 3.3 Halifax 976 5.7 Kelowna 970 3.3 Winnipeg 969 5.6 Guelph 957 2.7 Kitchener 952 5.1 Hamilton 932 5.4 London 924 5.2 Peterborough 915 5.5 Greater Sudbury 914 6.3 Canada 894 3.8 Ste Catharines 872 5.2 St john's 864 2.1 Thunder bay 858 5.1 Branford 835 7.3 Abbostford 820 5.8 Charlottetown 804 4.4 Windsor 788 6.2 Quebec 757 5.1 Gatineau 744 2.5 Moncton 742 4.5 Montreal 730 7.4 Saint John 691 4.6 Sherbrooke 591 1.5 Saguenay 571 5.1 Trois-Rivières 555 7.1
Here are also the data for the main stack bar. I'm not sure if it should be a separate data set....
Alpha milestone A 500 B 600 C 700 D 800 E 900 F 1000 G 1100 H 1200 I 1300
3 of 3 people found this helpful
This is totally doable, you just have to get creative and use more than one worksheet and utilize the 'Match Mark Color' option. See the mock up below.
Note that the text colors don't match the original. Either the underlying data provided is off or I made a small error in the calculated field determining colors.
I'm sure there are multiple other approaches that could solve this problem, one of which may include lines next to each metropolitan area text like the original.
Wow! this is the answer! Yes, the underlying data for the colors are just made up.
But now, how did you get to that? I don't event know where to start. Could you share your Tableau?
Thank you so much!
1 of 1 people found this helpful
Hi Mana Mouss,
You should be able to download my workbook and view the underlying structure on your machine. To download the workbook, follow this link:
There should be a download button on the bottom right of the viz.
Basically, you can assign items to the left and right side of the graph based on rank such that odd rankings are to the left and even rankings are to the right. I did the ranking in excel but it could just as easily be done in Tableau.
Each side of the graph is a separate worksheet with the text aligned to the right/left respectively. The coloring can be achieved with a calculated field like below:
//2.9 = national average. Hardcoded but could use WINDOW_AVG to be dynamic...
IF [Vacancy]>2.9 THEN
I made the marks circles 100% transparent, and then labeled each with the City and dollar rent amount. Clicking 'Match Mark Color' under the label settings will recolor the labels to match the underlying marks (even though they are transparent).
The middle chart is a dual axis gannt chart with some tweaks done to achieve close to the exact formatting of the original.
Thank you again for this. I'm trying it.
Can you please send me your excel file? misram17 at yahoo dot fr if it's needed.
Now I have a big issue. I can't find the way to move from one data source (blocks and city sheets from Excel) to another as you did in your mock up. How di you do that?
I actually managed to do everything I needed. Thank you sooo much again. Your comment was really helpful
I still have one question regarding the chart you did. I reproduced it and its works perfectly.
However, is there any a way to add the leader lines by any chance?
1 of 1 people found this helpful
Yes, try using unicode text characters in the label to accomplish the line.
I tried the first option "BOX DRAWINGS LIGHT HORIZONTAL" and it looks nice.
Heres the 'formulas' for the label:
<City> <AVG(Rent)> ─
─ <City> <AVG(Rent)>