daily data overlaid by monthly data chart
I have to create a graph that has daily data overlaid by monthly data.
Ideally the monthly data would be a bar graph with the daily data as
line graph over top.
'Here's a pic to explain what I mean
I also had the problem that the monthly data was in a differen
arrangement - the date traversing the columns with the daily data wen
- To fix it I used the Edit -> Special paste -> transpose option an
then laboriously cut and pasted the resulting arrangement to one bi
column. Wish I knew a better way.
I ...Chart and Data range
I'm using a chart dayly and i would like that the chart take all the data
without selecting source data within data source and updating the range
Thanks for Help
Do a Google search for: Excel dynamic chart
or go to
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Louis" <Louis@discussions.microsoft.com> wrote in message
> I'm using a chart dayly and i would li...Import data using macro
Hi, how do you use excel to import a text file using a macro to do the work
I start by creating a new workbook.
Then turn on the macro recorder and open that text file. (Try not to make
errors--it can make clean up troublesome.)
Then format the worksheet (headers/footers/page layout/filters,freeze panes)
exactly the way you want.
When you're done, turn off the macro recorder. Close the imported file and back
to your other workbook.
Insert a giant button from the forms toolbar on the first worksheet (with
Then save it.
Now go into the vbe and start tweakin...database mirroring question
for database mirroring, can one mirror server to two principle servers? That
means two mirrored servers mirror to one same mirroring server. Is that ok?
...XML data into MDB file
I am a newbie in xml.
I have a requirement where I have a predefined XML files and I want to
add the data in these file to into Access mdb through my application
The xml structure is fixed and I hav eto implement a button which on
click submit the data to the mdb file without any further intervention
My problems are ::
1) Since xml file structure is fixed but it can have multiple nested
elements in different files, the database in MDB should be relational.
I dont know how I can achieve this. How will I maintain multiple
tables in the target database??
for example ::
on...How do I create a table with data selected via a pass through que.
I see the data using a pass thru select query but when I try to use the query
in a separate make tabel query, I get an error message. Has anyone done this
On Fri, 30 Nov 2007 14:33:00 -0800, kandamj
>I see the data using a pass thru select query but when I try to use the query
>in a separate make tabel query, I get an error message. Has anyone done this
You may want to try saving the passthrough query, and base a new MakeTable
query on that saved query.
The passthrough query runs on the host, and ha...Budget question
I have a question. I am struggling setting up the budget for my income.
Problem is that we get salary increases in Mid year, and Money 2006 is
reporting the paychecks trough the year (it will be nice, but)
Any idea how to setup the budget when Paycheck 1 is till may, and
Paycheck 2 starts in June? I tried putting end payment for the paycheck
1 and starting second one next month, but it didn't work. It was still
reporting 2 incomes.
"AJ" <email@example.com> wrote in message
> I have a questio...Need help in data copying.
I have an invoicing file in excel (Sheet1). I need to store the dat
which is invoiced into another sheet. My Invoice Data starting from Ro
8 and column B to F (The first item is from B8-F8, second item i
B9-F9). B-Item Code, C-Item Name, D-Qty, E-Price, F-Total.
Once I print the invoice, I need to transfer the data to another shee
When I create another invoice, the new data should be added below t
the previous data in Sheet2. So that I can have all the items I sol
Can someone help me sending a macro for it???
I will be grateful to you.
Thanks in advance
We working on a 55 page catalog that is using the ACCENT BOX layout that came
with Publisher. Every page has a pageholder/header at the top that shows the
name of the catalog, the page number and a little image. When we began this,
we were adding single pages (not knowing about the master page concept). Now
we have all the pages ready but we've noticed that the page numbers within
the pageholder and image are all on the top right of every page. What we
would prefer is that they be mirrored with the left pages (odd number) having
these items on the left hand corner and the right ...Copy selected columns from .xls to a .txt file question
I would like to be able to copy two columns from a .xls file, columns 2
(B) and 9(I) into a .txt file for approximately 100 rows, using VBA.
What is the best way to do this?
.DisplayAlerts =3D False
.ScreenUpdating =3D False
FpatH =3D "C:\Documents and Settings\username\filename.xls"
FileP =3D ActiveWorkbook.path
ActiveWorkbook.SaveAs Filename:=3D _
FileP & "\" & "1.txt&...SQL Questions
Hi, i am from Spain, excuse my Inglish
I have a Windows Server 2003 R2 x64
1) can I install SQL 2000 Standard Edition?
2) Can I downgrade SQL 2008 Standard Edition licences to SQL 2000 Enterprise?
3) Need Windows 2003 R2 x64 SQL Enterprise Edition or can i install the SQL
Thanks for all and excuse again my Inglish
ZIDAC (ZIDAC@discussions.microsoft.com) writes:
> I have a Windows Server 2003 R2 x64
> 1) can I install SQL 2000 Standard Edition?
Yes. You will get a message saying that SQL 2000 RTM is not supported on
Win2003, but that you need to insta...Store to HQ -- is there data encryption?
Hi, when a store communicates with HQ in RMS, is there built in data
encryption? If not, are there ways to encrypt the data other than using
VPN? Just wondering since it seems like most companies would
sales/inventory to be confidential.
just wondering. thanks!
so no one knows whether data is encrypted when being passed over the
internet between the Store and HQ?
> Hi, when a store communicates with HQ in RMS, is there built in data
> encryption? If not, are there ways to encrypt the data other than
> using VPN? Just wondering since it seems like most companies...Setting hover data labels to cells other than source data
Hi and thanks in advance,
I need a macro or something that will show a data label for a data source
point when clicked or moved over by a mouse. I also need this data label to
reference a different source than the source data used in the plot. For
example, I am graphing a yield curve in relation to duration, however,
instead of showing the x (duration) and y (yield) with the data label, I
would like it to show the name of the instrument.
x = column a, y = column b, instrument name = column c, for example.
I have already tried using the tashar mehta macro for hovering data labels
but it...General CRM 3.0 questions
We are considering using CRM 3 in our SBS IT consulting firm. Our current
environment consists of the following:
- SBS 2003 and Exchange 2003
- Timetracker MX with QB interface that we use on our Audiovox 6600 PPC
phone to track time that is then uploaded to QB for invoicing.
- QB for accouting and invoicing
- Outlook 2003 that syncronizes with our PPC phone to track contacts, notes,
appointments, and tasks.
My questions are as follows:
- With CRM what sync capabilities will I have with my PPC phone and Outlook.
CRM will not change any sync capabilities between your phone and
Ou...Data export issues from Quickbooks
We are trying to migrate from Quickbooks to Great Plains.
We are looking at various options in trying to extract
data out of Quickbooks.
1. One of the options is export out through reports.
However while exporting out transactions, here if an entry
involves multiple accounts (called as SPLIT in
Quickbooks), these accounts dont print on the reports
unless you drill down. Has anyone encountered this
Any feedback on export of data out of Quickbooks will be
appreciated (whether using reports or without it).
Your export/import will be difficult and time consuming
working...SRS Question and possible link to error
I am currently running a single Windows 2003/Exchange 2003 server for
my organization. We had been running an Exchange 5.5 server until this
new one was in place and it has since been put out of its misery.
(however I think it may have not been demoted properly, but that's
another story) I just today changed the FQDN of the exhange server to
our new domain and my ISP made the appropriate changes and it took
fine... but I have two questions:
1. On the new Exchange server I still see a Site Replication Service,
can this be safely deleted now that the 5.5 server is dead and gone? By
deleting...Sort on last two digits of data
A sorting question.
I have a sheet of data A12:BC77. I would like to sort this on items in
column A. The problem is I need to order it by the last two digits of the
data in Column A. So say ZWE11 will come before AA77 and QW22 will come
before BB55 and so on. There is probably a simple answer but it is missing
me at the moment.
All I can think of is splitting out the last two digits into a new column
and sorting on that, then deleting that column once sorted but seems very
Any advice will be very gratefully received
with kind regards
Hi Spi...Charting Data from Excel
Hello, all! I'm new to this group and trying to figure out a way to query
data from SQL Server 2000 into Excel to graph.
Basically, I have one row of data that is collected on a weekly basis that
reports the size of a various file that we send to customers. I would like
to have Excel read the database from whatever date range that I specify, and
have it graph the size of the file for both weekly, monthly, and yearly
Can Excel query database directly?
Does anyone have any sample charts or tutorials online that I can see how to
I suppose I could export my SQL data...Microsoft Access "Classroom management database" question
Microsoft Access "Classroom management database" question.
When grading, it has the ability in this template to put in scores for Assigments, Quizzes, Exams, Etc. For example, student scores 45 our of 100 possible points.
BUT it does not calculate that into a grade, that field is editable and I guess you have to manually put in a letter grade. Leaving room for human error.
Is there a way to make the # of points work or translate into a Letter Grade.
Path is: Open Classroom management database, go to classes, choose assignment tab, and click View assignements. THere you can ...Last cell with data in a range
I enter weekly data into a spreadsheet with a summary page at the front.
After every week, when new data is entered, I want the formula at the front
to use the cell with the new data instead of me having to change the existing
For example, my data looks like this:
A B C
I need a formula that will automatically detect the last number >0 in column
Thank you for your assistance!
so your main page formula might be something like:
=...SQL Server 2005 Mirroring (Same Server Mirror)
I am trying to set up SQL Server 2005 mirroring for testing on the same
Windows 2003 server. I have created two separate SQL Server 2005 database
instances. After setting up the mirroring between the two instances. When I
tried to Start Mirroring after the configuration I received the error listed
One or more of the sever network addresses lacks a fully qualified domain
name (FQDN for each server, and click Start Mirroring again.
The syntax for a fully-qualified TCP address is:
TCP://<computer_name>,<domain_segment>[,<domain_segment>];<port>...Data in combo box not visible
I have a form with a combo box on it, and it has worked flawlessly for
sometime. Now, when I go to make a selection in the combo box, I see
nothing but white. The list pulls down to 8 data items (as
programmed) but there appears to be nothing there. But, when I select
on "nothing", the data is selected. So if I go to position 3 in the
combo box drop down list, I get the correct 3rd item. But I can't see
anything in the drop down list. The resulting data selected does show
up correctly in the main combo box field, but I can't see what I am
selecting until after it is sel...outlook data backed us as office data file
i recently backed up my outlook data and somehow it was
backed up as an "office data file" not an "outlook data
file". I am unable to open the file in outlook or
word.is there a procedure to convert the file to an
outlook data file so i can view it?
Does it have a .pst extension on the file name? If yes, it is an outlook
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer
andy <firstname.lastname@example.org> asked:
| i recently backed up my outlook data and...Backing up Money data to online location?
2003 does not allow an easy way to save a back-up to an online location,
such My Yahoo briefcase. I have to take the file, and upload it manually.
Please correct me if I'm wrong.
Will there be an online back-up option in future releases? I'd like to see
it go to MSN via my Passport, for instance. I'd upgrade for that.
Given the size of a backup and the availability of sync with the web, this
might not make it anytime soon.
"Iron Flatline" <email@example.com> wrote in
> 2003 doe...Updating Quarterly Data
Hi, I have a summary spreadsheet that is set up with a QTD budget
column. This column links to a tab that has the budget numbers by
month. Each month when I update the QTD budget column for the new
month I either have to manually update all of the formulas to include
the next month of the quarter, or if it=92s a new quarter I have to
adjust all of the formulas to ONLY look at the new month. Is there a
formula or way that I can automate this process? Here=92s an example of
the formula that I=92m manually adjusting each month.
Adjustment at the beginning of the quarter: