Viewing Chart data with mouse roll over

[Sam Patterson]

Hi and thank you in advance

I have created a column chart displaying two sets of information. The Value axis is labelled tonnes and shows amount in tonnes and the category axis is labelled months and target and shows the amount in stock for each week of each month and also a comparison stock target amount.

When the mouse is hovered over either of the columns the tonnage is shown in the pop up for the specific month or target for that period.

The problem I am having is that this is fine for all the columns on the chart starting at the left side of the chart i.e. Target and 01 Oct and working right up to week beginning 28th January, but the last few weeks information up to the end of April is not shown when the mouse is hovered over the columns.

Help!

 

[Faseeh]

Hi Sam Patterson,


I assumed you must have used some sort of VBA code defining this mouse event so please upload the sample file that will help people solve your problem.


Regards,

 

[kaushik03]

Hi Sam Patterson,


Meanwhile, you may want to have a look at the below discussion.


Kaushik

 

[Debraj]

Hi Sam,


are you searching for some discussion in below..

ooh.. here it is..


http://chandoo.org/forums/topic/pointing-mouse-to-show-other-series-data-in-the-chart


Regards,

Deb

 

[SirJB7]

@Kaushik03, Debraj Roy

Hi!

Trying to earn new enemies? If Sam Patterson happens to read all the topic you posted, for sure I'd take my hat off to him.

Regards!

 

[kaushik03]

Thanks Debraj...I jst forget to paste the link (you posted)which I copied..


Kaushik

 

[Debraj]

Thanks Koushik..

for taking the complete blame on yourself.. and save me from making a New Enemy..


Or


Thanks SAM.. for reading the complete post..

 

[SirJB7]

@Sam Patterson

Hi!

Chapeau, monsieur...

Regards!

PS: yes, I know, both of them should & could have led you straight to the point, but they wanted you to read the whole Enciclopaedia Britannica...

 

[Sam Patterson]

All

Thanks

I will read the discussion and check out the file

Will let you know how i get on asap

 

[SirJB7]

Hi, Sam Patterson!

As one of the authors of the involved links I know it's not an easy topic, so just advise if any issue.

Regards!

 

[Sam Patterson]

Hi All

Sorry I have not got back to you sooner but have been in bed with a bad cold.

I have since discovered that letting the spreadsheet run for a while on the PC will allow the values from 28th January to April (i.e.left to right on the screen)to be displayed on mouse roll over. I do not know why but it works the PC is fairly new so it should not be slow at any processing.

Thanks for all and any future help and suggestions

Sam