Hello,
I have an active report which is set up with a line graph. The graph is built into a data deck and is connected to a drop down menu. My line graph shows the total quantity of items at a particular location. The graph is being filtered on the [Location] field and works perfectly. I am able to click on each location and view different graphs. The issue is that some locations have much larger quantities than others (i.e. one location has 5, another has 500). This results in the graph being skewed with a very large Y axis due to the larger locations. For example, when viewing a graph for a smaller location the Y axis remains the same, causing the graph to be difficult to read when changed. Is there a way to automatically scale the Y axis with each selection of the active graph?
Thanks
I don't know if this is helpful or not, but I don't have much experience of Active Reports (yet). In burst report there's an option to make each graph use it's own axis scale...if you click on the Y axis for your graph is there anything similar?
Just a quick update,
I was able to get this working. There is an option in the graph property settings which fixes this. An option such as "use scale for each instance of this graph" is automatically checked. When I unchecked this everything worked well.
Thanks