I have data in my file from which I produce a chart. Depending on the selection the user chooses from the drop down box, the data will change. I have a few charts based of this same data and I want the axis numbers to remain at the same levels.
In the data, I work out the MAX value I want on my chart axis. How can I link the chart axis 'maximum' field setting to get the value from this cell?
In the data, I work out the MAX value I want on my chart axis. How can I link the chart axis 'maximum' field setting to get the value from this cell?