• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hyperlink roll over chart

aparvez007

aparvez007

Member
Hello Ninja's


Can any1 please check the file what is the problem.

I am unable to catch where i was making mistake.

I watch chandoo's video but unable to do it.


http://www.2shared.com/file/mu8AMipj/hyperlinkchart.html


Thanks

Regards,

Pavi
 
Hi,


I am not sure whether you are looking for the below kind of report.


http://www.2shared.com/file/jNjkM_k5/1_online.html


Thanks,

Suresh Kumar S
 
Thanks both and sorry for late reply as i was travelling.


@Suresh Kumar... file not working in my pc.


@narayank991.... can you please upload in 2shared.com speedy.sh is block in my country.


and request you both can you please explain me. I just dont want to complete but want to understand the concept and which step i misssed in my file.


Thanks

Pavi
 
Hi Pavi ,


Please check the file here , and confirm that it is what you wanted ; once you confirm , I will give detailed explanations of all the techniques used in the file.


http://www.2shared.com/file/geOLAYbM/hyperlinkchart1.html


Narayan
 
Bingooo... Narayank the great....


only dynamic chart heading which i was used is not showing only region name showing...

I think you change the dynamic chart heading...


Also the last column of data from which chart made showing same data in all row...


It will be great if you expalin what i was doing wrong... and now how it works...


Thanks Narayan to help me...


Regards,

Pavi
 
Hi Pavi ,


A few points :


1. Regarding the chart title , I am sorry ; I didn't realise what it was originally ; in the process of making changes , I must have changed this too ; just click on the chart title ; you should see the following in the formula bar :


=hyperlinkchart1.xlsm!valSelOption


Change this to the following :


=Sheet4!$AE$9


This will bring back the original chart title.


2. The last column of data is not being used in the chart ; at least the way I've done it ; I have not gone through Chandoo's blog to understand how he did it ; at least at present , that last column is not in use.


The header i.e. cell AE12 ( valSelOption ) is used , but the data from AE13 through AE23 is not used ; you can delete data in this range , and it will not have any effect on the chart.


Narayan
 
Hi Pavi ,


Sorry once more ! I just realized the importance of what you said viz. the last column of the table is showing the same value everywhere. It is not supposed to.


The formula you entered was not entered as an array formula ; you should have selected the range X13 through X23 , entered the formula =INDEX($X$13:$AD$23,,$AE$11) , and pressed CTRL SHIFT ENTER. Then the range will display the data from the currently selected column of the table.


I have reworked the file on this basis ; download it from here :


http://www.2shared.com/file/oZWlpuBd/hyperlinkchart1.html


You can compare the two versions to see that in Chandoo's version , there is no need to define the various named ranges which I had defined. Chandoo's version is more elegant , and you should use that.


Narayan
 
Hi Narayan,


When i m trying to use , in formula its not accepting only ; acceting in all formula.

why its happening...


I checked your new file its used same formula which i used in my file but for me its not working and in your file its working.


Please help..


Thanks

Pavi
 
Hi Pavi ,


As explained earlier , the formula will work only if it is entered as an array formula , using CTRL SHIFT ENTER.


1. Select the range AE13 through AE23 , and press the DEL key ; you should have a blank range. I made a mistake in my earlier post , and posted the range as X13:X23 ; this is wrong , please read it as AE13:AE23.


2. Type in the following formula :


=INDEX(X13:AD23,,AE11)


and press CTRL SHIFT ENTER.


You should see the range populated with data from the column given by the value in AE11 e.g.


if AE11 shows 1 , then the range AE13:AE23 should display data from the range X13:X23


if AE11 shows 2 , then the range AE13:AE23 should display data from the range Y13:Y23


and so on.


Narayan
 
You must log in or register to reply here.
Back
Top