Linking Time-varying charts
Here's my problem.
I've got a set of Excel files with monthly data which is updated every
month. So in January I only have Jan data. In February I have Jan and
Feb data, and so on.
The chart I have for this data always displays a full 18 months data
from October 2003 to March 2005, and as more data is added, the line on
the chart snakes its way from left to right.
These files are submitted to me from various sources. As a central data
collector, I now want to link these Excel files into a single Excel
file which will display all the charts in one place for convenience.
Ho...Need to truncate a transaction log
I have a database which is 2 GB but the log file has grown to 35 GB. I would
like to truncate the log so I set the recovery method to SIMPLE but the log
file did not truncate after last night's backup.
This has worked for other databases and I get a small log file. Later, I
reset the recovery method back to FULL.
Rich Lawson (firstname.lastname@example.org) writes:
> I have a database which is 2 GB but the log file has grown to 35 GB. I
> would like to truncate the log so I set the recovery method to SIMPLE
> but the log file did not truncate after last night&...Need Help with Formula #3
I need help trying to come up with a formula for a friend
of mine. This is what he wants -- Using any 9 numbers --
he wants Excel to come up with every possible 3-digit
combination of numbers that are divisible by 7.
Is there anyone who could assist me with a formula that
will perform this calculation? Can Excel do such a
Thanks so much for any assistance you can offer.
In A1, enter the number 7.
Edit>Fill>Series, Step value 7. Format>Cells>Custom, "000".
If with "using any 9 numbers" you mean you don't want any zero...Latest Exchange Administrator Needed admin.exe = 5.5.2655.33
If any body knows were to download the Exchange Admin (admin.exe Version 5.5.2655.33). I am having a problem with mailbox sizes being incorrectly diplayed in Exchange admin. I have dozens of Executives that have mailboxes over 4 or 5 GB and I have no way of correctly reporting there sizes other than using ExMerge. Please help.....
You will need to call into our Tech Support and refer to the following
Knowledge Base article and tell them that you need the hotfix.
305829 XADM: Incorrect Mailbox Size Is Displayed in Exchange Server
Thanks,...Using MS Access information in Outlook
I have an MS Access DBase that contains our companies contact information. I
want to be able to use that information in an Outlook contact folder. I do
not want to import the information into Outlook. I want it to be
Is this possible?
...How to generate XML file as follow, using XmlDocument
I have to generate XML file as follow, using XmlDocument.
< Employee EID=3D=94111=94 Description=3D=94 xyz=94>
<FirstName> Abhijit </FirstName>
<LastName> Babar </LastName>
<FirstName> Sahine </FirstName>
<LastName> Ghavane </LastName>
< Employee EID=3D=94222=94 Description=3D=94 abc=94>
<FirstName> Swapnil </FirstName>
...In excel when inputting dates 10/4/04 (10/april/04) data converts.
In excel when inputting dates 10/4/04 (10/April/2004) excel converts this to
4/10/04 (4/October/2004) Where can I change the input characteristics.
I have changed the date format to English (UK) and this works when I input
the date in the American format mm/dd/yy but I want to input in the dd/mm/yy
I think I'd try chaning my windows regional settings.
In win98, I'd get to it via:
Windows start button|Settings|control Panel|regional settings applet
Change the short date format to dd/mm/yyyy (I like 4 digit dates--you don't have
to use that part--but put it in d...Adding Lines And Boxes, etc. To A Chart ?
Will blame it on my age.
Using Excel 2007 (or, at least trying to) and XP.
When I have a chart page opened up, how do I get it to show the bar on the
bottom (that the real old versions had) that allows one to click on one of
its icons shown to "draw" lines, arrowed lines, boxes, add text with a box,
etc on the chart itself ?
With the chart selected you can use the Insert tab > Illustrations > Shapes.
To add shapes to the chart. Textbox is in the Text group of the Insert tab.
Andy Pope, Microsoft MVP - Excel
http://www.andypo...newbie needs help
First to let you all know, I am a big novice at this kind of stuff, so
please bear with me.
What I am trying to do is make a trendchart with 9 different plots on it.
How do I change the numbers on the side and bottom of the chart to read what
I need them to? I take these tests 3 times a week and would like to chart all
of them seperately and also together to chart progress for a whole month.
One for each day, and then one for the month. Then I would like to do the
same for the following months of the year. And I would like to have one chart
to show the progress for the whole...CRM & Data Matching
We are going to populate our MSCRM with various data sets. Because of this
there will be duplication of customer data. Is there any mechanism within
Microsoft CRM (or easily available elsewhere) to match the data from the
diverse sources against each other and to arrive at a single instance of the
Microsoft CRM V3 only offers merge capabilities which means you have to
locate the duplicates - crm can then merge the records two at a time. ISV's
have produced other solutions
Microsoft CRM MVP
http://codegallery.got...I need to write this formula in basic
Does anyone know how to write this formula in Basic. I need to make it
work in Openoffice because Excel seems to crash with a list of 20000
...Calcs & Data Validation
Looking for an easy way to complet the following. I imagine their must be a
quick & easy method.
Cell A5 has a drop down list which corresponds to a range on another
worksheet. It has 300+ entries. In cell B5 i will enter a number/qty. What i
would like is that as each of the items in the list has a corresponding cost
(on other worksheet), i would like to know an easy way to calculate the cost
(in C5) based upon the qty entered (B5) & the cost of the item selected.
I have done it before with 'IF' function for a small selection, but figure
there must be an easier...Chart Type HELP!
Hi, I still need help on the Chart Type thread that I posted a couple of
hours ago under "Chart Type".
It is URGENT--for a presentation for which I am already late!!
Hi Sat - Take a look at what I just posted and see if it helps.
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------...Combination chart? Stacked cylinders and scatter
Hi, I want to make a stacked bar chart that also shows another data
point as a single point along the stacked bar. Here is what I have so
Here is what I want to accomplish:
- don't show Sections where Length is zero -- right now the zero
sections show with label and value on the right side of the cylinders
- show another data point (from another cell in my sheet) as a single
point along the stacked bar
- show a final data point as the total of the bar len...Problem with line Chart
I have the following data:
I would like to create a simple line chart connecting the Value points. Note
that the points correspond to random dates (not evenly spaced). How can I
create a line chart that has time on the x-axis, (say shown in months) with a
line connecting the Value points, which are shown at various locations in
time. Soun...Why doesn't indirect work with a dynamic range created using offse
Has anyone else experienced this issue or I am doing something wrong.
I have a series of dynamic range names defined using offset. For example
the name USCities is defined as =offset(AA1,0,0,Counta(AA:AA),1) and the name
Europeancities is defined as =offset(AB1,0,0,counta(AB:AB),1)
In column A, dataentry into the cells is limited to USCities or
In column B, I want to limit data entry to the range name appearing in
For example if USCities is selected in A1, data entry in cell B1 is to be
limited to those cells forming the USCities range name.
I have tri...PatchFactory 2.0 Released. Professional and easy-to-use patch building tool for Win9x/Me/NT/2000/XP.
Professional and easy-to-use patch building environment that can help
you to create instant patch packages for software and file updating.
Generated patch packages are small size self-extracting executable
update programs in a famous installer style with adjustable
user-friendly interface and multilingual support.
Enhanced with features like easy-to-use interface including a Wizard
mode, powerful patch engine, integrated compression technology,
adjustable multilingual user-friendly interface of the update program,
this program will most definitely become a valuable asset for softw...No "Chart Option" feature in the Formatting Palette or when double click on Chart
Operating System: Mac OS X 10.6 (Snow Leopard)
I have read a discussion board concerning this issue but it was from 2008 and no solution was offered yet. The problem is as follows: one creates a graph but cannot add a title or format the axis etc. <br><br>When I open a new spreadsheet and enter the data, I can create the graph. However, I cannot select the "Chart Option" to change any specific features. On the formatting palette I only get the "Page Setup" options but nothing relating to the chart and when I double click on the graph t...Create Outlook 2003 Rule using 'Or' operator in 'Sent to' condition
How do I create a rule that uses the 'or' operator in the 'sent to'
condition? I actually have a rule like this, but don't know how I
created it. In other rules, when I try to add more that one email
address or group in 'sent to,' Outlook inserts the 'and' operator.
What is the exact rule in full?
In general you'd create additional rules but it depends a bit on the
condition or action that you are using.
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins ...Formatting doesn't follow data sort
I was just recently updated to 2003 MS Office Pro. I can't remember
what I use to have, but I used to be able to Data Sort info and the
borders around cells would follow the appropriate text. It doesn't do
that anymore, and I can't find out how to fix it in the online help,
and my IT guy doesn't know off the top of his head. Can anyone help or
have I wasted a full day and a half putting borders around information
for no reason?
kanimalhouse's Profile: http://www.excelforum.com/me...Pivot tables, linking to a named range as a source to a pivot table
I have created a main worksheet within the same workbook
of many pivot tables, and I want to use this same
worksheet as the source of information to these different
pivot table sheets off of which I create charts.
I want to use a named range because there are over 4,000
rows in this main worksheet.
I am not sure if I need a "=" to start the reference or
what to do.
I thought I should just use nameofworksheet!database if I
name the range "database", but when I point and click to
the sheet, it is just inserting the name "database"
without the name of the...Permission to use object denied.
I have a user on a Windows 2000 machine with user rights.
The user is also running office 97. When he opens a excel
speedsheet and Enable's Macros, he gets the following
message; "Permission to use object denied".
It sounds like there is some sort of link to another workbook that a macro
is calling and your user does not have rights to it.
I think I would open the book without enabling the macros, and then take a
look at them to see if one is trying to do such a thing.
Vaya con Dios,
"Shannon" <Shannon507@aol.com>...Accessing a linked file in a Word document using VBA
Basic question, in my Word template I have some linked images. I want to use
VBA to change the path and filename of some of these links ... can anyone
give me a clue as to how I should best do this?
To see how to paths in Word using vba, check out the macro solution I've posted for implement relative paths at:
[Microsoft MVP - Word]
"Robin" <Robin@discussions.microsoft.com> wrote in message news:7EA2C548-7D01-4515-BCC8-2EF3210439C9@microsof...How do I copy previously entered data
If I enter related data in A1 and C1 and then type the same data as A1 in A4,
how do I get the data in C1 to automaticallyh appear in C4?
> If I enter related data in A1 and C1 and then type the same data as
> A1 in A4, how do I get the data in C1 to automaticallyh appear in C4?
Thanks for the information, I tried it and it works.
One further question if I may?
If I type the info in A1 in multiple places in columnA, can excel be
repeat the related info in c1 in the cor...Data validation causing problems when using a data form in Excel 2
I have an Excel 2007 workbook that includes data validation set on a number
of cells. When using a data form to enter data and I enter an invalid value
on the form field corresponding to one of those cells I receive the
validation error dialogue that prompts me to retry. I enter the correct data
into that field on the form then close the form. My worksheet only has the
data relating to the corrected field entered. All other data entered via the
form is not entered onto the worksheet.
Is this a bug in Excel 2007? I previously was using Excel 2002 and found
that when using a ...