Search results

I have fixed it now - thanks for your help

Hi i have a 100x10 grid/table in excel (a list of 100 jobs) the last column in the the table (column 10) is a complete status(Complete/WIP/Incomplete), I would like each row to go green once the compete status is populated with "Complete" I know how to format one row to get my result but i...

Thanks guys I have now fixed my problem.

Hi All On a dash board of mine I have a pie chart which display category and data label's which are 0% which just get in the way - Is there anyway to tell excel to not display category name if the value is 0 ? I Know i can get rid of the data value by using Custom and type"0%;;;" however the...

Thanks Narayan My VBA is ok still lots to learn though, i will read over this article and see what I come up with. Thanks again Chris

Hi I am trying to nest a pie chart in a bar graph- i'm not sure if this can be done but i thought one of you may know. What i particularly want to do is have a bar graph on my main dashboard then once one of the bars is clicked a pie chart appears to show you the break down of that...

I'm not to sure how I upload a file ? Could you please advise ? Thanks Chris Franklin

HI I am creating a dashboard and within the dashboard you get to choose which month of the year you would like to view My question; My chart changes from month to month depending on what month has been selected on the dashboard, however no matter what month is selected the chart picks up...