Search results

Hi I would like to be able to click on a bar from a bar chart, then a pie chart pops up somewhere to show the relevant data. A better explanation: A bar chart could show sales in a shop - lets say there are 3 bars on the chart - one for drinks, one for food and one for magazines. If I click...

Hi I have a problem here which im sure somebody will know the solution to: http://i.imgur.com/WOgT9Hm.png If you look at the image, amongst this table, there are different reference numbers. Two different letters get sent out amongst the same reference numbers - one in print and one in...

Id just like to confirm that this worked! I used 0;;; and it worked exactly as required. Thank you so much for your help, youve been great.

Ok so what you are saying is that my answer definitely lies in this formatting, Ill have a play around with it and hopefully it solves my problem. Thanks again for your help!

Hi Narayan I have ammended the formula, the problem is that when I format the data label to go blank by using the ;;; in custom formatting, then this does get rid of the 0 values on my data labels BUT when these values aren't 0 but turn into other values when i select a different category on...

Also, If I change the 0s to not show up on the data labels, then will this mean that when this value is not 0, then the data labels will still not show?

Narayan, I think that this is along the right lines of what I need to do but i can't quite make sence of it. Here is the formula in one of the cells that shows as #NA: =IF($AC$27=$X$36,Y31,NA()) So when January is selected for example, then Y31 will appear, otherwise it will be #NA. So on...

Hi I am currently using Chandoos method of interactive graphs of having tables that populate to #NA for undesired values on the chart. So if i click january as the month, then all other months and values would go to #NA in the tables, so that the graph only shows Januarys values. Now the...