Forum Discussion
Creating Line and stacked column chart with average calculations
I am trying to compare the average attendance in the league to a single team average attendance for combined years.
I have confused on what is the shared axis assuming years. Then how to get the double Y axis to calculate.
5 Replies
- Hi there
Can you please share some sample data as well as what the expected outcome would be?Hello Gilbert,
Let me me see if I can provide that for you.
Hello Gilbert,
I have to choose the most appropriate visualization to show how the team's (Chicago White Sox) attendance average combined for all years '06-'14) compares with the attendance average of all other teams in the League.
I assume the League average attendance would exclude the WS.
I started with two separate visualizations, but I am convince that the line and stacked column chart should do the trick.
I am thinking the years at the bottom (x-axis) average attendance on Y- axis. Thes would be stacked column and the WS average attendance would show a line going across the years.
Hopefully this sample data is enough to work with. Thanks,
How do I send you the sample data?
- Hi there
I could not see any actual data
When replying with the standard reply you can copy and paste a table into the text box which should keep it in the structure.
