Search results for query: *

HI, This should be a fairly simple question. What make an excel file size increase? Does the size increase based on number of sheets, formulas or VBA code? I know that a combination of these will make up a file size but lets say I have two files... both starting with th same amount of data and...

:( well thanks anyway - will try and work with what I've got. - Gillian

Another query - I have created the drop down list by the using the Tools - Validation and everything works well. The only problem is the font sixe in the list boxes is really small - how do I change this font size? Thanks Gillian

Thanks again Ken - will give that a go!! Cheers Gillian

Thanks Ken - thats exactly what I needed to know!!! Everything works really well now! I never knew that function existed!

Hi I've got two questions. First - I've created a list box in excel which, for example, lets say gets it's list values from J1:K3. The list box itself is linked to cell A1 - meaning the chosen value from the list box goes into cell A1. By the way, this list box sits in cell A1. All this works...

thanks straybullet - although some graphs do this automatically. Is there a setting that can be used to allow this - I have about 20 graphs that have dynamic data and hence some text are rather short while there are other more lengthy texts. - Gillian

Thanks Chris and Tranquilo for your responses. Chris I need the text to be aligned at 0 degrees. I need to be able to space the text out so that they dont overlap each other.

Hello :) I'm having trouble with a vertical bar chart that I have created. The labels that go at the bottom of each bar is quite long (they're almost sentences) and I need them to be a size 10 font. Problem is they overlap each other. The only way I can stop this from happening is by making it...

thanks Andy - that works perfectly! also thank you to everyone who tried to solve my little graph problem :)

Than you both for responding - but no that is not what I want.... Lets say I have two data sets A B 4.5 3.2 5.6 4.4 3.2 2.9 2.5 1.5 I need series A made into a normal horizontal bar graph and series B need to be dots that appear on each of the corresponding bar. eg. the...

you could use a countif formula which will tell you how many time "Jan-04" appeared in that column. try this =COUNTIF(A:A,"Jan-04")

Hello... I've ceated a horizontal bar graph with five values ... I need to add a line through each bar which will be values from another column... I know this is probably really easy but I cant seem to figure it out. please help me! GD

Thanks G LS that works really well!!!

Hello, I have a report which gets its data from a query. Also I have set up a form to get specific records froom this query. The form has a combo box on it with three columns Col 1 Organisation Name Col 2 Organisation Code Col 3 Organisation ID It is set to display only the first two columns...

Thanks Duane that makes sense now [smile]

Cosmo - Thank you - it works and I managed to learn something new!! dhookom - I have deleted all subreports and am left with just one very straightforward main report. The report is grouped by "Category Name" and in this section I have a textbox called "Count" which has...

dhookom - that does'nt seem to work and I dont quite understand what you're trying to do here... In the sum function... CountField is a Number but CategoryName is a textbox - what are you trying to do with the "*" ?????

Thanks Tony - your solution worked! CosmoKramer - How do you re calculate a total as you suggested earlier? Lets say if in my details section I have CategoryName Count and in the footer if had the total count Total Count The result being 1 - Apples 5 2 - Grapes 4 3 -...

yup I know the RIGHT() function exists and dont ask me why but I just love the MID function [smile] !!!