Dynamic Charts - 2 issues

[Caravishah]

Hi,

1. Dynamic Y Axis

How do I make the Y Axis dynamic for a dynamic chart? Refer the chart below - if selected for 1 month (vs. say 10 years) the Y axis doesn't scale doesn't change. Obviously everything for the Y axis is set to auto.



2. Getting rid of unchecked legends -

The Other question is - how do I get rid of the legend (cleared in the above image for confidentiality purpose) if I untick one of the data series?

Appreciate your help. Thanks.

 

[Hui]

Q1.
1. Select the Chart
2. Right click on the Y Axis
3. On the Axis Options Tab, set the Minimum and Maximum to Auto

Q2.
You could have a Formula in the cells where the Series Name is located
This would refer to a cell linked to the Check Box using a formula like

=If(Check_Link_Cell,"Series Name","")

The Check_Link_Cell will be displaying a True or false and so there is no need to use =If(Check_Link_Cell=True,"Series Name","")

 

[Caravishah]

Q1.
1. Select the Chart
2. Right click on the Y Axis
3. On the Axis Options Tab, set the Minimum and Maximum to Auto

Q2.
You could have a Formula in the cells where the Series Name is located
This would refer to a cell linked to the Check Box using a formula like

=If(Check_Link_Cell,"Series Name","")

The Check_Link_Cell will be displaying a True or false and so there is no need to use =If(Check_Link_Cell=True,"Series Name","")

Thanks Hui.

On 1st - I have set everything to Auto.



I'm not sure if I'm putting across my problem correctly. so please find below the snapshot for 10 years. The scale work absolutely fine here. But if you see the 1 month graph (attached in my 1st post) I don't want the scale from 80 down to 0. Am I clear?



On Q2 -

If I do what you suggesting, I can get rid of the name but still the color remains in the legend. Any way to get rid of the color as well - as if it doesn't exist on the chart at all.

 

[Hui]

For the second question
please read Narrayan's solution to this post:
http://forum.chandoo.org/threads/dynamic-chart-series.28655/

and the associated links
these should solve your issue

 

[Hui]

For the first issue of Zooming that can only be achieved by using VBA to override the Min&Max Scale values

 

[Caravishah]

Thanks Hui ...

 

[Hui]

Have a look at the attached file where Horizontal and Vertical Pan & Zoom is implemented