Combo charts or charts of type in VISUALIZATIONS which share the same x-Axis. First of all you need to choose the type of chart that you want to create.
Here is a clustered column chart from one of my previous posts.
ComboChart_0
This shows a chart of male, female and total populations in four of Indian States, Andhra Pradesh, Tamil Nadu, Karnataka and Kerala (all South Indian states).
Now I change this chart type to Line and Clustered Column Chart. The chart will not change.
ComboChart_1
Now go back to the Fields tab under VISUALIZATIONS as shown here.
ComboChart_2
Now drag one of the fields (Female in this case) under FIELDS to the space under Line Values under the VISUALIZATIONS|Fields as indicated in the next image.
ComboChart_3
Now the Chart appears as shown, you see the Line chart superimposed on the Column chart.
ComboChart_4
Now go back to Format under VISUALIZATIONS and expand Shapes as shown here.
ComboChart_5
Here, you can turn-off the shaded area under the line graph. You can choose several other visual items a shown here.
ComboChart_6
You can also have a combo chart using the Line and Stacked Column chart as shown here:
ComboChart_7
Here is a clustered column chart from one of my previous posts.
ComboChart_0
This shows a chart of male, female and total populations in four of Indian States, Andhra Pradesh, Tamil Nadu, Karnataka and Kerala (all South Indian states).
Now I change this chart type to Line and Clustered Column Chart. The chart will not change.
ComboChart_1
Now go back to the Fields tab under VISUALIZATIONS as shown here.
ComboChart_2
Now drag one of the fields (Female in this case) under FIELDS to the space under Line Values under the VISUALIZATIONS|Fields as indicated in the next image.
ComboChart_3
Now the Chart appears as shown, you see the Line chart superimposed on the Column chart.
ComboChart_4
Now go back to Format under VISUALIZATIONS and expand Shapes as shown here.
Here, you can turn-off the shaded area under the line graph. You can choose several other visual items a shown here.
ComboChart_6
You can also have a combo chart using the Line and Stacked Column chart as shown here:
ComboChart_7
No comments:
Post a Comment