Forum Discussion
Add "Total" on same level as current calculated dataset for line chart?
Hi nbrandborg ,
Not sure if I understood your problem and it would really help if you could share some sample file.
From what I understood, I think you can use the 'small multiples' in the line chart to separate every single country.
If you do not want the scale of your graph to change, when selecting a country, you can provide the upperlimit of the Y-axis, instead of keeping it 'Auto', from the formatting pane, which will make the scale static.
Again apolgies, if my response is not what you are looking for and in that case if you could please provide more information.
Thank you,
Vishesh Jain
Hi visheshjain
The problem is not the Y-axis as I have locked it to show 0-100% always - but the width of the graph area - the X-axis. When a country, like USA, is selected as a single-selection, then the line-chart area becomes wider, as the legend takes up less space on the left. I have too many countries to have the legend in the top or bottom.