12 Replies Latest reply on Jan 30, 2014 4:51 AM by Prateek Bhandari

How can i dynamically control the axis of chart with the help of a formula(i.e. the min and the max values of the range)

How can i dynamically control the axis of a chart with the help of a formula(i.e. the min and the max values of the range)

• 1. Re: How can i dynamically control the axis of chart with the help of a formula(i.e. the min and the max values of the range)

Can you provide some more details about what you are trying to accomplish?  As always, a sample workbook with a mock up is always helpful.  You can certainly control what is showing in a chart based on a parameter, which can change the axis.  If you can tell us more about what you hope to accomplish by doing this, we can try and help you find a solution.  Cheers!

• 2. Re: Re: How can i dynamically control the axis of chart with the help of a formula(i.e. the min and the max values of the range)

Sure i have a waterfall chart created and i would like to restrict the min and max values for the y axis dyanically. Attached is a sample file. I have set the axis as fixed it works fine when i select New York but not so much for Chicago.

• 3. Re: How can i dynamically control the axis of chart with the help of a formula(i.e. the min and the max values of the range)

Hi,

Did you get a solution? I am looking for something similar. The simplest example would be I have a quick filter, and based on the selection,  I want to display the data accordingly.

But the the Y axis should always be fixed, based on the min/max of the Y value in the overall data.

The reason to do this is to easily put graphs in perspective.

Thanks!

Michel

• 4. Re: How can i dynamically control the axis of chart with the help of a formula(i.e. the min and the max values of the range)

Michel: Can't you just set a fixed axis to be those values constantly?

• 5. Re: How can i dynamically control the axis of chart with the help of a formula(i.e. the min and the max values of the range)

And Abheer:  In order for anyone on the forum to help, you'll need to post your workbook as a packged workbook file.  Simply Save As>>.twbx (packaged workbook).  This will ensure your data is included when you upload the workbook file.

• 6. Re: How can i dynamically control the axis of chart with the help of a formula(i.e. the min and the max values of the range)

Matthew,

Unfortunately, no. The thing is, I am using extracts, and the Y axis is a "volume" axis. If I refresh every month (for example), the maximum/minimum may change drastically - so the scale would need to change.

But once the scale min/max changed,  I would like it to be fixed - until the next extract...

I think I could manipulate the TWB programmatically, but if I can avoid it, I'd rather do that

• 7. Re: How can i dynamically control the axis of chart with the help of a formula(i.e. the min and the max values of the range)

I see.  I am not sure if there is a solution for this or not. Sorry I'm not more help

• 8. Re: Re: How can i dynamically control the axis of chart with the help of a formula(i.e. the min and the max values of the range)

Mathew ,

Attached is a packaged workbook.

Thanks

• 9. Re: Re: How can i dynamically control the axis of chart with the help of a formula(i.e. the min and the max values of the range)

What is the problem with using the "automatic" option?

• 10. Re: Re: How can i dynamically control the axis of chart with the help of a formula(i.e. the min and the max values of the range)

too much white space and would like to see the middle components a little larger

• 11. Re: Re: How can i dynamically control the axis of chart with the help of a formula(i.e. the min and the max values of the range)

Sorry, I'm not sure what you're looking for--maybe someone else can help out on this one.

• 12. Re: How can i dynamically control the axis of chart with the help of a formula(i.e. the min and the max values of the range)

Hi Abheer,

Just checking if you had any success in finding a way to get rid of the bottom part of the axis to build focus on more important part of the graph?

Many thanks

Prateek