Tableau Graph Question

We are trying to migrate from using Excel to using Tableau to generate graphs. The issue is that we are looking for Tableau's results to mimic Excel as much as possible, and we have not found a way to represent the same data in the same graphical way. For instance, one of the graphs that we are looking for is a year and month breakdown of durations of actions. In excel, we have a key where each color represents an average duration of a different action. In Tableau, we are able to get the same sort of breakdown of information, but cannot color code it in the same way. If possible, we'd like to know how to use a key to color code results in Tableau so we can get away from using Excel for this type of report. Examples attached (named for the program where they originated). Any assistance is appreciated.
Excel.png
Tableau.png
Peter NavikAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SteveCost AccountantCommented:
Each of your blocks may already be aggregated by Undetected/ restore/request/end...
You need to use this as the colour key.
This may require an additional calculation field (a simple if agregation) but I doubt it.
You seem to have the figures seperated, so the key should be available.
Just drag your 'time key' onto the colour icon (top left one).

You really are not far off from having what you need.
You will need to have the month as an additional sheet and pop that in after on top to match excel.
Or you could jusy use the drill down features on each year.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SteveCost AccountantCommented:
Maybe take a look at the simple example attached.
(drop the fake .xlsm extension from the example as EE won't upload tableau workbooks.)
U--TableauExample.xlsx
U--Example.twb.xlsm
Peter NavikAuthor Commented:
Thanks Steve. We were able to figure it out, but we used the method that you described. I appreciate your help.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.