Help with spreadsheets

hjb123

Am using spreadsheets at the moment and just wondered if anyone knew if there is a way of renaming the columns from a,b,c to headers relevant to the data am putting in or whether the only way for headers is to use the first row ?

thanks

[Deleted User]

You can't rename the columns, it would create havok with formulas and calculations.

You will just need to use a row for the headers instead.

hjb123

thought that might be the case but just wanted to be sure

hjb123

another question:D

can you make the spreadsheet highlight (automatically) any boxes where a figure greater than a set amount? ie, I want to single out any cells that have a value greater than 250 in?

thanks again:D

hjb123

oops, just got it worked out

S0litaire

There is an option to change colour based on value. Can't think of it off hand but check the help files under "conditional formatting"

hjb123

thanks for that, have got the conditional formatting sorted now

but...

another question....

am now looking at some charts, now in column A I have some numbers which are for each category and columns B onwards have values each month. The numbers in column A arent sequential - some numbers are missing as there arent categories for them.
now what I have been trying to do and failing is having column A as one of the axis on the graph - ie so along the bottom it has the numbers in each box from column A, and along the side axis it has the values so I will be able to see how the figures vary from month to month

hope this makes sense:D

stevemcol

Sounds like you need to make the chart type XY scatter. Set column A to be set to the x axis.
If there is a value missing from colum A, there will be no corresponding tick on the graph. I may have misunderstood what you're after though.


Edit, No ignore this I don't think it does what you want. I'll have a play and post later (after a dozen people have correctly answered your question).

PhilCo_2

You'd probably be better off with Amount on the side, month on the bottom and individual columns/lines for the items. I've put an example on my site...http://www.spreadsheetsdirect.com/files/graph.xls

stevemcol

HJB, what is not working when you try to make the graph?
There are a few ways of doing it but I'm not sure what you're trying to do.

hjb123

oh blast, have just realised what I was trying to do was totally impossible - was trying to fit 3 categories etc onto 2 axis. duh:D

thanks anyway for the help:D