change source data in multiple charts
I have over 30 charts where I need to change the source data and it's taking
ages doing it manually, especially as each chart has 3 or 4 series. Is there
an easy way of doing this, please?
I've tried find and replace, but that doesn;t work
We need a little more detail. 1. Are you modifying all the charts to use
the same new range or does each chart use a different new range? Is the
data compact, that is, if you choose the chart wizard and look at the Data
Range tab does the Data Range box contain a simple reference like
"Tuxla&...automatically import data from a cell in one workbook to another workbook
Operating System: Mac OS X 10.5 (Leopard)
How do arrange for workbook A to import the data from a cell in workbook B? In other words, what formula (address?) should I enter in a cell in workbook A so that it will import the data in a cell from workbook B?
This would be just another formula; start with =+ and then just use the mouse/trackpad to click on the referenced cell (assuming you have both wordbooks open. Be careful of relative/absolute references.
Thanks, Mungo <br><br>Cheers <br><br>Karshish
1) Make sure both workbooks ...How do I 'spindle' or collect multiple documents in a single file
I used to be able to create chapters, so that discrete documents could be
combined for global changes and unbundled for separate editing/use. Can this
Word has a master document function but it is notoriously unreliable and can
result in data loss, so is best avoided. Word can work with very large
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<>...can I sort text data into bins?
Here's my problem - I hope you can understand it & help:
Let's say I've got a column, A (or row 1, it doesn't matter) tha
contains cells, each with a single word/category that I'm interested i
[example: dog, cat, bird, fish, gerbil] - we can assume that this is m
list of category headers/titles.
Plus I've also got various other columns, A-D (or rows) next to m
column A titles that each contain a list of items, one per cell: [eg
B1=dog + B2=cat, C1=bird + C2=cat + C3=gerbil].
Perhaps it would be clearer if I drew it out (ignore the dashes
they're just t...Finding sheet one
A worksheet I need has dissapeared - no longer does 'Sheet one' show, only 2
& 3; how do I retrieve sheet one?
"Old Red One" <firstname.lastname@example.org> wrote in message
> A worksheet I need has dissapeared - no longer does 'Sheet one' show, only
> & 3; how do I retrieve sheet one?
Or maybe you deleted it, in which case it is gone if you have saved the
Gord Dibben ...Format all sheets in one Workbook
I would like to add a little something to all the help everyone has
offered on the formatting issue in Excel. If you would like to format
all sheets including (Header, Footer, etc..) you need to make sure and
use the "page setup" under "file" menu, because using the formatting
from the print preview option will only make changes to the sheet you
are currently viewing.
I'm guessing but I think MS wanted to make sure you don't accidentally
format all sheets thru print preview so they make you choose it from
the file menu. It is the same thing as the repeat columns ...Convert works database to excel
Is there a way to copy information from a Microsoft Works
database to Microsoft Excel worksheet?
...need to transpose 3 or 4 columns to one column
The matrix below represents what I need to do in Excel. I need to
transpose the data from row 1 of C1, C2, C3 and C4 to rows 1-4 of C5
then repeat for each additional row of C1-C4. I think I might need a
macro but I have no idea how to write it. Any help would be
appreciated. My data set is too large to utilize cut and paste
special. Thank you for your responses.
C1 C2 C3 C4 C5
5 4 3 5 5
4 3 4 5 4
5 4 3 2 3
If your example table is entered in cells A1:D4, enter this into cell E2, and copy down until it
returns #REF ...Data Validation #10
I am using Excel 2003 and am doing a drop down list using Data|Validation. However, I must have the data for my drop down list in the same sheet as my drop down list, otherwise the drop down lsit doesn't work. Am I doing something wrong? I used to be able to put the data in a different sheet. What happened?
It's OK to have the list in another sheet,
but then you must name it, e.g. "List1"
(without quotes), and use that name in
the validation box (Allow: List and enter
Followup to newsgroup only please.
&quo...Counting how many records have writing in two columns.
I am trying to finish a report that is to include a current calculation of:
# of total employees, # of hourly employees, # of salary employees, # of
employees on leave, # of current employees (not on leave), and finall (the
part I am having trouble with), # of salary employees on leave and current
salary employees as well as current hourly employees and hourly employees on
leave. I have four columns in my table and query I am linking from (hourly,
salary, LOA (means they on on leave), and schedule (means they are current).
For the first few calculations I just had it count the number of...Displaying all data when using a combo box
Okay I have a form, based on one table. My form has two combo boxes on it,
one searches for an employee by building, the other by department. The
results are displayed in a subform beneath the combo boxes. This seems to
work fine. However until you enter a selection into each combo box no
records are displayed. How can I set each combo box to work independently
and/or together to get the desired results? Is there a way I could add
something like an "all" field to both? I would also like the subform to
display all records when the form is open until a selection is made. ...Multiple email accounts #14
How do I add additional email accounts so they go into their own folders with
individual access to outlook 2003 on the same computer?
If they're all POP3 accounts you've got to setup rules to move incoming mail
messages based on the account they came in via
"llbarnhill" <email@example.com> wrote in message
> How do I add additional email accounts so they go into their own folders
> individual access to outlook 2003 on the same computer?
If you mean each individual sho...View row and column headings
I have a sheet in a workbook that does not display row and
column headings and the select all button. How do I re-
Tools>Options>View tab>check the Row and Column Headers box>OK.
Greeting from the Gulf Coast!
"Rob" <firstname.lastname@example.org> wrote in message
> I have a sheet in a workbook that does not display row and
> column headings and the select all button. How do I re-
...Two sheets merged to one changing colour?
If you had 2 or more spreadsheets giving the same info but in
different areas, is it possible to merge all the info into one sheet?
Week ending dates across the top, left hand side operation bein
carried out, cells are coloured in a colour according to area,
if it is possible, if an operation being carried out coincided wit
another operation would the cells then divide in colour?
Hope ive explained the question well tried to keep it simple.
I have two small examples here which show in more detail what I mean
if anyone is having trouble getting it.
Frank...where are you my saviour :
-...How do I change font size in multiple text boxes?
I am working in Publisher, and I have dozens of text boxes that I want to
change the font size, from say 10 to 8. Is there a way that I can select a
number of them and change them in a batch-style?
Use the Painter tool. Change the first text box, while your cursor is in the
box, click the Painter, click the next text box and so on.
Or open the font scheme dialogue, use or create a font scheme, click each text
box with the text scheme highlighted.
Mary Sauer MSFT MVP
"JustinB" <JustinB@disc...data turned into embedded picture
I somehow turned my data in a worksheet into a picture or embedded object
that I cannot edit the cells. want to retrieve my data that has become a
picture object ??
...enable a combo box in one form based on input in another form
I'm a novice programmer and was hoping that someone could help me.
I have a combo box in form 1, and another combo box in form 2. Currently
the combo box in form 2 is NOT enabled.
This is what I'm trying to do: when the user selects "yes" in combo_box1 in
form 1, I want the combo_box2 in form 2 to be enabled. I tried using a
public variable to enable combo_box2 but as I move from one record to
another, the public variable is not updated.
If anyone has an answer or better method of how to activate combo_box2 (in
form 2) based on the selection of combo_box1 (...extact data
I have 30 sheets, which contains the count of SMS of everyday, I need
summary on last sheet that every sim consumed how many SMS. The count is in
accending order so Sim no. will not be in order,
Thanks & Regards
> Dear All,
> I have 30 sheets, which contains the count of SMS of everyday, I need
> summary on last sheet that every sim consumed how many SMS. The count
> is in
> accending order so Sim no. will not be in order,
> Thanks & Regards
There are two opt...outlook just can start one time
This is a multi-part message in MIME format.
I am using win98 and outlook2002. I create a new profile for Outlook2002 =
to connect to our Echange 2000 server. First time I can start =
Outlook2002 and work fine. But after I close Outlook2002 and start it =
again. I receive the following error message:
Your logon information was incorrect. Check your username and domain, =
then type your password again. If your account is new or if your =
administrator r...Excact row and column size
This is a multi-part message in MIME format.
In Publisher 2002, using calendar templates, it is easy to resize with =
the mouse. However, this is a course change. There are instances when =
I need to change a row or column size to an exact amount. . The Format =
Table>Size seems like it would be the place to make an exact setting, =
but it is inoperative and I do not see any way of making an exact size =
in the Table drop down menu. =20
Is ...Subquery for column names
I have a database table with a large amount of analytical data in it -
all floats but for a timestamp column. Instead of returning the
entire set, I want to be able to return specific columns based on a
"system" number that is specified as a parameter (in this case it is
written in as "S02" for testing purposes) and compare the provided
system number with the column names within the table - which is what
the subquery currently does correctly.
Aside from creating a stored procedure to handle the result and
reformat it into a string to then use as a parameter of a ...Convert Excel to Word
How can I convert an Excel Workbook with multiple sheets
into a .doc format document?
To my knowledge, you cannot perform a straight conversion from Excel
to Word. However, there are two things that you can do.
1. Open Word, then within word, click File > Open > Under "files of
type" click All. Find the Excel file and click. An option box will
apear to ask if you want to open the entire workbook, or just one
page. The result is messy at best
2. Open Word to a blank document, and copy the excel portion that you
need and paste special it into word as an excel worksheet...Changing data format
I have a program that sends a report to excel, however, instead of putting
the information in coulmns, it places it all in one cell with spaces. Is the
only way to get all this information into columns, cut & paste or is there an
Try Data>Text to columns in the menu bar
Regards Ron de Bruin
"frustratedwthis" <email@example.com> wrote in message
>I have a program that sends a report to excel, however, instead of putting
> the informat...Column Number as parameter in Query to select data
Hi is it possible that we can give Column Number as a parameter to select
Records at Runtime in access table .
eg, Table having structure like this, Where Qtr1..Qtr4 Stores Amt Paid by
If runtime i provide Column name to quaery it should return Cust with
specified quarter like
"Select Cust,<Column No> from tbl" , Where Column No is the parameter
I know if the data table is normalized like this
it is quite easy to select , but my proble is , presently i am...have a subreport get data related to a date on main report
I have a subreport that I want to pull up data 180 days before the
date on the report. Any ideas on if and how this can be accomplished?
Please and thank you.
>I have a subreport that I want to pull up data 180 days before the
>date on the report. Any ideas on if and how this can be accomplished?
Try using a filter/criteria for your date field like:
<= DateAdd("d", -180, Date())
MVP [MS Access]
I tried that previously but my boss didn't want 180 days from the day
they run the report he wants 180 days from the closing date on the