
1. Re: Automation of dashboard using Tableau to improve efficiency
Chris McClellan Jun 28, 2018 8:02 PM (in response to A S)Can you provide some sample data and workbook ?
Have you tried using labels on the bars ?
In a dashboard it should be simple to arrange the graphs to align *IF* there is the same number of values on the xaxis.
But I get the feeling I'm missing something, so any sort of dummy workbook to illustrate the concept should help

2. Re: Automation of dashboard using Tableau to improve efficiency
A S Jun 29, 2018 1:40 PM (in response to Chris McClellan)Hi Chris,
Thanks for your response. I'm not sure if I understand what you mean by aligning the graphs if we have the same number of values on the xaxis. Could you please elaborate? I'm afraid the data is highly confidential; so it's not possible for me to provide sample data but essentially, I have currently created a 100% stacked column chart setting the gap width to zero and then layered the rectangles manually on top of the underlying chart (the rectangles are for displaying a proportion or percentage of the rectangles in the underlying column chart).

3. Re: Automation of dashboard using Tableau to improve efficiency
Chris McClellan Jul 1, 2018 2:36 PM (in response to A S)I understand the data is confidential, but surely you can randomise the data (use the RANDBETWEEN function in Excel) to create some data so we can see.
With the same number of values on the Xaxis. It look like you're looking at 4 years, but if one of the graphs have more years then it won't align properly.
It's really hard to talk about this without a visual cue, so anything that you can provide (really, in Tableau) would be great

4. Re: Automation of dashboard using Tableau to improve efficiency
A S Jul 2, 2018 11:25 AM (in response to Chris McClellan)Hi Chris,
I have attached an Excel spreadsheet which contains some sample data. Also generated the underlying graph which is a 100% stacked column chart with zero gap width. The challenge is to create a graph similar to the one I posted in my original query either in Excel/Tableau. Please let me know if you have any questions.
Thanks!

Sample Data.xlsx 19.2 KB
