Re: Scroll Bar Selection, Show The Last Four Months of Max Date
Thank you for your answer. It has saved me a considerable amount of time and is very clever way of doing things!
If I may, in addition, ask a question of the back of this:
If there are a lot of different locations, so like London, New York, Paris etc how do you incorporate the above solution so that the graph shows the last four months progress grouped by each location. Currently it is showing October 2013: London value, Paris value, New York value etc, however I would like this to change to the following:
Re: Re: Scroll Bar Selection, Show The Last Four Months of Max Date
I added Regions as a 2nd dimension. By default the 2nd dimension will create 'clusters' of bars or stacks within a single bar for each unique value of the 1st dimension. So in this case you get a bar or stack for each region and you get a cluster of these for each month in the chart. To toggle between individual bars or stacks , go to the style tab of the chart properties and pick 'grouped' or 'stacked'.