The Interactive Chart tool in the Reporting category is very useful to create charts in Alteryx, but there are some weakness. One of them is not to be able to show the label for the line chart. In this post, I would like to explain how to show the label on the line chart by layering charts.
Normal Line Chart
First, this is the sample basic line chart.
To know the value easily, supposed to show the label, but there is not such the function. But if you select the bar chart at the chart type, you can see this option at the Layer tab.
However, when you select the line type at the chart type, there is no TEXT option at the layer tab as follows.
So, I would like to use the layering option.
Show the label on the line chart
The basic method is to add the bar chart to the line chart and make bar chart transparent and show the label at the bar char.
1. Create a normal line chart
First, let’s create a normal line chart. Add a layer and set “Line” to the “Type” and a field to X axis and another field to Y axis. And name “Line Chart” to know easily as follows.
In this sample, I would like to divide the line charts by store name, so set “store” field to the split option on the Transforms tab.
In a result, the basic line chart will be created. You can change the chart area size, point the value position or change any other options. If you don’t change the other options, it will be shown as follows.
2. Add the bar chart
Next, add the bar chart layer for showing the label. At the Layer tab, add the layer and set the “Bar” as the Type and a field to X axis and another field to Y axis. Name “Label” to the layer name to know easily.
At that time, the chart is shown as follows.
3. Change the setting at the bar chart
Final, change the opacity to zero percentage to show the label only. For this, you can change the setting of the bar chart at the Layer tab.
To do this, set as follows.
- Opacity % : 0
- Bar Mode : Overlay
- Text : sales ( This field is for label.)
- Text Position : Outside (if you set “Inside”, the labels would be transparent.)
After that, you can get the chart as follows.
And also, you should change the size or any other options as you like. This chart as follows is my favorite setting.
Conclusion
- By overlaying a transparent bar graph with label on a line graph, the label is added to the line chart.
- Layering some charts is very useful for the chart variation.
Sample workflow download
The next blog post is…
I will show you another variation of layering charts.
コメント