tag:blogger.com,1999:blog-3998628784041768080.post6648066136964153117..comments2024-03-28T03:27:07.147+00:00Comments on VizWiz: Excel: How to create a dual axis chart with overlapping bars and a lineVizWizhttp://www.blogger.com/profile/11408220384219218043noreply@blogger.comBlogger17125tag:blogger.com,1999:blog-3998628784041768080.post-13104982014933720632017-04-05T20:23:03.330+01:002017-04-05T20:23:03.330+01:00I outline how to do this in Tableau in this post h...I outline how to do this in Tableau in this post http://www.vizwiz.com/2016/09/tableau-tip-tuesday-how-to-create.htmlVizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-68136076492878160012017-04-05T10:34:34.801+01:002017-04-05T10:34:34.801+01:00I'm stuck on how to do this in Tableau. Any s...I'm stuck on how to do this in Tableau. Any suggestions??Anonymoushttps://www.blogger.com/profile/14532740536060076211noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-50312699167839679022016-06-01T04:26:26.376+01:002016-06-01T04:26:26.376+01:00Thank You very must.Thank You very must.Anonymoushttps://www.blogger.com/profile/00371508093839956835noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-58937915568886927142016-02-08T15:42:36.870+00:002016-02-08T15:42:36.870+00:00When you have two number of the same value the bar...When you have two number of the same value the bars' top lines dont match because the thicker outline creates a problem for the barsAnonymoushttps://www.blogger.com/profile/05342611647348607148noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-65388663434723897072015-02-10T15:04:38.886+00:002015-02-10T15:04:38.886+00:00I do not know how Dan. I haven't built a chart...I do not know how Dan. I haven't built a chart in Excel since probably around the time I wrote this blog post. VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-91225061561124462712015-02-10T10:52:57.010+00:002015-02-10T10:52:57.010+00:00Awesome!
A question: Do you know how to do this f...Awesome! <br />A question: Do you know how to do this for a total of 4 series, (on the chart)? (I.E ,making 2 sets of overlapping bars) <br /><br />eg: For the columns/series A,a, B,b : -> "A" over "a" , and "B" over "b". <br /><br />Thanks,,!Anonymoushttps://www.blogger.com/profile/08159824450863866949noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-35875711787621966592014-06-25T16:27:07.296+01:002014-06-25T16:27:07.296+01:00Thank you!!!!!Thank you!!!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-68986285884051005262014-02-24T22:51:53.071+00:002014-02-24T22:51:53.071+00:00Thanks for this! really helpedThanks for this! really helpedAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-77913028500667736922013-06-13T10:24:04.031+01:002013-06-13T10:24:04.031+01:00Hi,
I might have difficulties to follow those ste...Hi, <br />I might have difficulties to follow those step as I still have Excel 2003 (yes it's possible unfortunetly :-/)<br />Any back-up solution for old excel version user maybe?<br />Thanks!<br />/MaggieAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-67810102477868645732013-06-13T09:52:37.986+01:002013-06-13T09:52:37.986+01:00You have to click on the gray bars. When you clic...You have to click on the gray bars. When you click on one of them, they should all be selected. Then go to step 11.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-36557492494655260402013-06-13T09:03:19.490+01:002013-06-13T09:03:19.490+01:00Hi!
Could you please explain a bit more the step 1...Hi!<br />Could you please explain a bit more the step 10?<br />I don't manage to get the overlap as in your chart.<br />Thanks!<br />MaggieAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-6071043070379401192012-10-01T17:09:37.450+01:002012-10-01T17:09:37.450+01:00Aayush,
You don't need a dual axis chart to b...Aayush,<br /><br />You don't need a dual axis chart to build this in Tableau. Use the Show Me if you're ever unsure what you need to build a standard chart type.<br /><br />As an example, connect to Superstore Sales. Choose Region, Category and Sales. Click on Show Me, then choose side-by-side bar chart.<br /><br />That's it!<br /><br />AndyVizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-40303628709374180812012-10-01T13:43:27.080+01:002012-10-01T13:43:27.080+01:00Hi,
I wanted to know how to create non-overlappin...Hi,<br /><br />I wanted to know how to create non-overlapping bars in tableau as excel does normally. I don't have a trend line to show. I just need to have a dual axis chart with the bars placed adjacently as excel does normally.<br /><br />Thanks in advance,<br />AayushAayush Anandhttps://www.blogger.com/profile/11405433944176529852noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-22546212654350451582012-05-03T07:03:09.051+01:002012-05-03T07:03:09.051+01:00Andy: I have used the dual axis trick in Excel to ...Andy: I have used the dual axis trick in Excel to show the overlap you are talking about. I solved the synchronous axis problem by having a unseen element in both charts which was the maximum value (ie. max of budget and actual in your example). Since we always start at zero so you always get the same scale on both sides.<br />- can't do the line as well unless you really want to cheat thoughKeith Sucklinghttp://www.eavi.com.aunoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-62948199416161892682011-08-27T04:23:37.804+01:002011-08-27T04:23:37.804+01:00Mike,
I've used the secondary axis trick in ...Mike, <br /><br />I've used the secondary axis trick in the past as you outline in your excellent blog post, but you have to be 100% certain your axes are synchronized. In the example you showed, the axes didn't appear to be the same.<br /><br />Also, there is no way in Excel to use your technique, but to also have a line.<br /><br />The easiest solution is to always use Tableau.<br /><VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-979027663147456322011-08-26T17:42:02.500+01:002011-08-26T17:42:02.500+01:00By adding a line to the bar you visualize the budg...By adding a line to the bar you visualize the budget as being higher than it actually is so I wouldn't use that technique. There is another option but it involves the secondary axis so I'm not sure if you can still get the line there as well:<br /><br />http://datapigtechnologies.com/blog/index.php/stacked-thermometer-chart/<br /><br />This reminded me of an interesting article by Stephenm-bnoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-50922593979552745962011-08-26T15:54:14.355+01:002011-08-26T15:54:14.355+01:00There are many pitfalls when creating a chart in E...There are many pitfalls when creating a chart in Excel. For example, when adding the border to the budget, not just the width of the light gray bar was increased, but also the height, this can be seen in the first pair of bars where the values are 200 and 150, but visually looks like 200 and 190.Joe Makohttps://www.blogger.com/profile/15643500270169278424noreply@blogger.com