tag:blogger.com,1999:blog-3998628784041768080.post9119488048794600822..comments2024-03-28T03:27:07.147+00:00Comments on VizWiz: Tableau Tip: 7 easy steps to create a combination chart with overlapping bars & a lineVizWizhttp://www.blogger.com/profile/11408220384219218043noreply@blogger.comBlogger43125tag:blogger.com,1999:blog-3998628784041768080.post-24132213157502268422018-04-03T06:30:32.340+01:002018-04-03T06:30:32.340+01:00First, a chart with 5 measures will be impossible ...First, a chart with 5 measures will be impossible to read. I would suggest creating one chart for the bars and one for the lines. To answer your question, you would need to use measure names twice which you can’t do if they are different measures on each shelf. That’s by design so people don’t create charts like you’re suggesting. You really should push back on the stakeholders. VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-1335444416111489112018-04-02T20:12:21.608+01:002018-04-02T20:12:21.608+01:00Hi Andy, I have a requirement to create Dual Combi...Hi Andy, I have a requirement to create Dual Combination chart in Tableau which has 5 measures by Quarter.<br />Out of 5 measures we need to have 2 with bar graph and 3 line graph. Using Dual Axis and other workaround we are use maximum of 3 measures like 1 or 2 bar chart and another 1 for line chart.<br />Is there a way to achieve this requirement? In Microsoft Excel we have Chart Type of 'Unknownhttps://www.blogger.com/profile/02178063649444976661noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-11112355822066552672017-04-12T18:40:35.631+01:002017-04-12T18:40:35.631+01:00They're not on the same axis. Watch the video ...They're not on the same axis. Watch the video that's linked at the top or follow the steps outlined above or download the workbook. VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-44934774426789378582017-04-12T18:28:27.439+01:002017-04-12T18:28:27.439+01:00thanks for the tutorial, how do we show both the b...thanks for the tutorial, how do we show both the bar and line chart on single axis?Anonymoushttps://www.blogger.com/profile/13488812180480613702noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-81780710805362604552016-11-07T19:53:03.914+00:002016-11-07T19:53:03.914+00:00Similar issue as Ranjan, how can we size so one is...Similar issue as Ranjan, how can we size so one is thinner and the other thicker?Anonymoushttps://www.blogger.com/profile/05382028817821363773noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-70412689679527662172016-03-08T19:45:45.008+00:002016-03-08T19:45:45.008+00:00Hi, I have a variable category from 1-4 and corres...Hi, I have a variable category from 1-4 and corresponding sales values that I would like to sum up. It's easy to plot 1,2,3,4 and their sales in bar chart. How can I plot this . Sales of 1-4 on one bar and 2-4 on next, 3-4 on next and 4th one with sales of 4th category? Please help?Anonymoushttps://www.blogger.com/profile/03385669434322916005noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-36533693883668272212016-02-15T22:25:07.611+00:002016-02-15T22:25:07.611+00:00This helped me so much !!! Thank you because my ch...This helped me so much !!! Thank you because my chart kept doubling my axis instead of overlaying the data on top. Stack marks had to be turned off in my caseAnonymoushttps://www.blogger.com/profile/00112517795774361704noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-42034259798255702262016-01-06T22:47:32.828+00:002016-01-06T22:47:32.828+00:00Don't create the line chart.Don't create the line chart.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-15096627713907130602016-01-06T19:58:42.645+00:002016-01-06T19:58:42.645+00:00Is it at all possible to make the overlapping bars...Is it at all possible to make the overlapping bars without the line?? Jhttps://www.blogger.com/profile/05814834671439888137noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-54847893330793985332015-10-13T09:14:40.668+01:002015-10-13T09:14:40.668+01:00for example achievement score
...for example achievement score <br /> 1<br /> 0<br /> 1<br /> 1<br /> 1<br /> 0<br /> 1 etc i want to count the how many 1's and howmany 0's Anonymoushttps://www.blogger.com/profile/17504080658133387311noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-31001381067006453492015-10-13T09:12:10.857+01:002015-10-13T09:12:10.857+01:00hello i want to find the how many 1's and how...hello i want to find the how many 1's and how many 0's are presenting the achievement score column . i want the calculation field Anonymoushttps://www.blogger.com/profile/17504080658133387311noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-42208066058851310542015-08-15T21:34:22.319+01:002015-08-15T21:34:22.319+01:00Joy, without seeing your workbook, I'm guessin...Joy, without seeing your workbook, I'm guessing that you need to put measure names or grade on the size shelf.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-46183295516211161752015-08-15T00:16:03.454+01:002015-08-15T00:16:03.454+01:00Hi Andy
I'm so excited that I succeeded in fol...Hi Andy<br />I'm so excited that I succeeded in following your instructions to make a combination graph. I am reporting data on 2 measures of literacy from 2nd-5th grade over two years. The bar graphs are overlapping so they don't show the grade performing the lowest! How can I have my bars look like yours with different widths or have grouped together?<br />Thanks so much,<br />JoyJoy Broughtonhttps://www.blogger.com/profile/02786496133135570607noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-3111943377704205032015-06-27T13:37:20.202+01:002015-06-27T13:37:20.202+01:00There are a few different ways you can accomplish ...There are a few different ways you can accomplish this. Refer to these posts:<br /><br />Change the chart type of a single chart with a parameter - http://vizwiz.blogspot.co.uk/2013/10/tableau-tip-change-chart-type-of-single.html<br /><br />or via Alan Smithee Presents<br /><br />Changing Viz Types with Dashboard Containers and Parameters - http://www.alansmitheepresents.org/2011/03/VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-86113025508374698112015-06-26T19:51:05.139+01:002015-06-26T19:51:05.139+01:00Hello. Is there a way to select a chart that you n...Hello. Is there a way to select a chart that you need from a drop down menu and not get blank areas on the dashboard? As I have it right now, I have a drop down menu that selects which of my charts are visible. However, the charts are side by side in the dashboard so that when I select one of them, there is simply blank space where the other two reside. Is there a way to organize the charts on sjuallstar16https://www.blogger.com/profile/12623504834369283540noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-14451748787945398472015-05-22T18:04:57.759+01:002015-05-22T18:04:57.759+01:00Charlie, you could do one bar inside of another ba...Charlie, you could do one bar inside of another bar. Or use dots.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-85639378829125143652015-03-31T16:10:52.439+01:002015-03-31T16:10:52.439+01:00two* bar graphs.two* bar graphs.Charliehttps://www.blogger.com/profile/03962753242057001178noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-81734844073277162092015-03-31T16:10:06.460+01:002015-03-31T16:10:06.460+01:00Could I compare two dimensions to each other using...Could I compare two dimensions to each other using a line or bar graph in Tableau 8? I am currently just creating to bar graphs, but would like to see both dimensions in one bar/line graph. E.g. Would like to compare survey results for two different surveys with the same rating values. Survey 1 Satisfied to Survey 2 Satisfied; Survey 1 Dissatisfied to Survey 2 Dissatisfied; Survey 1 Somewhat Charliehttps://www.blogger.com/profile/03962753242057001178noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-28322268898408176212014-10-25T04:13:29.994+01:002014-10-25T04:13:29.994+01:00No Tableau does not support that. Why not two sepa...No Tableau does not support that. Why not two separate charts if you have so many measures? You're readers will likely be confused. VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-16345694729112681302014-10-25T01:47:43.296+01:002014-10-25T01:47:43.296+01:00Can you have two measures tied to each axis? I hav...Can you have two measures tied to each axis? I have four measures I want to graph on one graph. Two are in thousands of gallons and two are percentages. I have no problem creating a combo graph with three of the measures and dual axes: the two percentages tied to one axis and the thousands of gallons to another. But I cannot get the second measure in thousands of gallons to blend with its axis.Facehttp://www.face.edu.vn/noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-14308211764092401142014-10-13T22:27:38.366+01:002014-10-13T22:27:38.366+01:00Can you be more specific on what you're trying...Can you be more specific on what you're trying to do? What do you mean by "a two combination graph with dimensions"? VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-33033825835198050722014-10-13T21:21:33.330+01:002014-10-13T21:21:33.330+01:00Thanks for posting this. I am having the same prob...Thanks for posting this. I am having the same problem as a few others - can you make a two combination graph with dimensions rather than measures?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-64734054072440031242014-09-30T15:06:28.467+01:002014-09-30T15:06:28.467+01:00Ranjan, when open the edit size dialogue, you can ...Ranjan, when open the edit size dialogue, you can adjust both the smaller and larger sizes. <br /><br />http://onlinehelp.tableausoftware.com/current/pro/online/en-us/help.htm#viewparts_marks_markproperties_size.htmlVizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-72773220505167897042014-09-30T14:55:29.674+01:002014-09-30T14:55:29.674+01:00Samantha, you can drag your calculated field onto ...Samantha, you can drag your calculated field onto the Measure Values shelf that appears.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-15880247215631110902014-09-30T14:54:44.614+01:002014-09-30T14:54:44.614+01:00If they are both the same quantity, then you have ...If they are both the same quantity, then you have two options:<br /><br />1. Right-click on the right axis and choose Hide Header or <br />2. Drop the pill that's creating the secondary axis on top of the left axis. This will combine them onto a single axis.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.com