CODEWITHSUNDEEP
overlaytableau-apigantt-chart
user4100980
user4100980

Reputation: 137

tableau adjust placement of gantt bars

In Tableau, I have a dual-axis bar chart of some data with their margins of error. I am using Gantt bars for the error data, and I want to overlay the error bars on top of the original data. My problem is that I can't figure out how to adjust the placement of the Gantt bars so that they are centered over the top of the original bars, with the error value displayed both above and below the bar.

I am pretty sure I need to create a Calculated Field but am new to Tableau and coding and don't really know how to go about this.

Upvotes: 2

Views: 2211

Answers (1)

al_the_man
al_the_man

Reputation: 295

You can do this without the use of Calculated Fields as follows:

  1. Create a Bar Chart with the original data
  2. Duplicate the Bar Chart by Ctrl-Clicking the measure pill in the Rows shelf
  3. You should get 2 charts one above the other now, select one of the charts from the Marks dialog, and change it to Gnatt Bar
  4. Drag error to the Size button of the Gnatt Bar and also to the Color button
  5. Now click the one of the pills in the row shelf and select Dual Axis
  6. Right click the second Axis and select synchronize Axis

Upvotes: 3

Related Questions