Yes, i got this too, but I like to do it the same way I was able to do it in excel. any ideas?
Well, that's the way Tableau creates that kind of viz, and it's not the same as Excel.
The closest you can get is right-click on the year values below the bars and unselect "Show Header". That will remove the year value from each bar.
Tableau will place the column names (in this case, City) above the bars.
Something like this?
There are few workarounds but one approach will be to use the INDEX() function. See attached workbook and steps below.
Right click on [Index], Select Compute Using the dimension which defines the color, in this case 'Year'.
Uncheck 'Show header'.
Index computed using Year and show header is unchecked.
Notice the space between the bars. You can reduce that by taking the Size slider to the max.
The above steps gets us very close. However, it is not very visually appealing.
There are few things you can do here. First choose Fixed instead of Manual in the Size options like below.
This should do it. However, you won't be able to reduce the width of the bars any further.
An alternative will be to use Manual resizing with a dummy calculated field.
Change Size option to 'Manual and drag [Resizer] to the Size marks card.
You can remove the grid lines by going to Format -> Lines.
Hope this helps.
Side by side chart_OO_v10.5.twbx 20.8 KB
Thanks I tried all these options. I thought there is a way around it. Thanks for the help!