[access-uk] Re: wp update/spreadsheet filtering
- From: "Carol Pearson" <carol.pearson@xxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Sat, 28 Aug 2004 13:58:55 +0100
Justin,
I just about hit charts etc but you're obviously way ahead of what I did
here but I'd just like to encourage you to make sure you know all the
highlighting key strokes too because these will be very useful to you as
you said you had trouble selecting those rows and columns you wanted.
I'm sure you can find the key strokes and maybe you do know them already
but I know it got me out of lots of scrapes.
If you need any further help on this, ask away on the list and I'm sure
I can either dig up all that I ever knew or someone more experienced can
help.
Cheers and all the best to you as you continue with your placement. I
certainly am interested in all of this.
--
Carol
carol.pearson@xxxxxxxxxxxx
-----Original Message-----
From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf
Of Justin R
Sent: 28 August 2004 13:50
To: access uk post
Subject: [access-uk] wp update/spreadsheet filtering
HI everyone,
OK, I hope this is on topic or appropriate?
I'll give you a breif description of what I done yesterday for the
council.
I finally got away from poster designing and was examining a spreadsheet
on employment gains and losses over all employment sectors of Ipswich.
I was mainly concerned with percentage rise and fall. I was to convert
these figures, all the figures into a bar chart, or any similar chart
using the wizard. Well, the charts came out rather messy and didn't
currectly imput all the information in. So, my boss decided that we'd
filter out any gain of 10% or lower to any loss of 10% or lower. they
were more concern with larger gains and losses. So, I had a go with the
excel's filter feature. well, it doesn't, i found out, work to how I
want it. if I wanted to filter out any rows with 0% in them. what the
filter did was to filter out anything other than 0%. i couldn't really
find an option to really tell the filter what I wanted to do. So, i had
to do a work around. I discoverd i couldn't selectively highlight some
rows I wanted, and and others I didnt need. it was all or nothing! So, I
physically looked at all rows, identified what I wanted and recorded the
cell letters and numbers and wrote down the divison number of each
sector in a word doc. I'd enlarge the font to 24 size, print it out and
then, look along the list while using zoomtext's speech to announce the
cell reference letters and numbers Anything not on my list, got deleted.
Now, I must say here, lol, that I did create a back up copy of the stats
spreadsheet. infact it was the copy I created I manipulated! I've
created a cylinder bar chart using the wizard. I've almost finished it
but, I've gotta resize and tidy up the text in the bar chart. So, real
tough work this time!! I really felt i was learning something as, I was
exploring excel's other features I never touch really. i don't use
excel much here at home. I dont have much reason to as yet.
any thoughts on filtering data in excel, or any comments at all, I'd
like to here them. there, soemthing else I'm learning with MS office.
<smile>.
Justin
** Going on holiday and want to halt messages? Send a message to:-
** access-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** vacation ## d
** where ## is the number of days followed by d for days.
** For other things like digest mode, send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.745 / Virus Database: 497 - Release Date: 27/08/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.745 / Virus Database: 497 - Release Date: 27/08/2004
** Going on holiday and want to halt messages? Send a message to:-
** access-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** vacation ## d
** where ## is the number of days followed by d for days.
** For other things like digest mode, send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts:
