Data prep for first stacked bar chart

jeffv

All,

I did some searching but can't seem to figure out how to format data for a simple stacked bar chart.

Say for example I have the following data:

Area, Smiles, Frowns

1, 22, 56

2, 29, 2

3, 10, 0

4, 10, 70

For all my trying various combinations I can't seem to figure out how to produce a stacked bar chart. Not sure what is considered the series. What I'm search for on horizontal axis is the areas. The stacked bars consist of # smiles, and # of frowns. Seemed so simple when I started ... sigh. Any guidance appreciated.

Jeff

Reporting

Accepted answers

robheb

I opened the file that you sent and it looks like you had checked "Area" in "Fields to Group" (See the screenshot below). I unchecked the box and got all of the Areas on the horizontal axis. It was a little confusing to me, but checking that box was creating one chart per Area instead of one chart with all the Areas combined. Hopefully that is the fix that you found in your second comment.

Reporting has always been very difficult for me. I feel that it is not really Alteryx's strongest attribute when you want to focus heavily on formatting so I tend to default to Tableau or Excel if I have very specific needs. However, there are some webcasts related to the Reporting tools in the Live Training section of this Community site. Here is an introductory training but you might be able to find something more suitable for what you are trying to do if you dig a little deeper than I did:

https://community.alteryx.com/t5/Live-Training/Live-Training-Introduction-to-Reporting/td-p/66495

Finally, as far as I know, there is no way to change the test angle for the axis labels. It might be something to propose in the Ideas section.

All comments

robheb

Series refer to the elements of the chart. In the case of your example Stacked Bar chart, it sounds like you'll want two series, one for smiles and one for frowns.

I am not sure if you are looking for a Stacked Bar, or Stacked Column based on your description. If you want the "Area" on the bottom axis and the stacked bars extending vertically, that would likely be a "Stacked Column".

Are either of these helpful?

jeffv

@robheb

You are right I used the incorrect terms. If I could get either to work it'd be a miracle. You proven it can be done.

Can you look at mine? I only get three columns but can't see a place to change that. Also can see how I get the labels right. I'm sure it's something simple.

BTW, my data might be different.

Thanks for guidance!

Jeff

ExBarChart.yxmd

Amy18

Hi Robheb,

Can I ask you several questions about Alteryx Stacked Bar chart?

Is there any way that I could put the number label to the center of my stacked bar?

Is there any way to remove or change the "record" and Layout" header?

For the color of bars, I know I could pick different color palette under "Legend, Data Layout". But can I choose the color for each bar (field)?

Thanks.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703