How chart time scale x-axis with another date serie
Hello all. I have this problem, I will need to create this chart that I don't
know how to.
Serie 1 is below which needs to be time scaled
Serie 2 - needs to plot the three dates in serie 1's time scaled X-Axis with
I will look something like you have a line of count on a time-scaled chart,
with 3 dates point in the x-axis. Please ...Copying and Pasting Between Published Documents
I have created a 132 Document in Publisher 2007
I needed to make a highly customised and intelligent Index so I created a
second document and typed the index in that, having both documents open on
extended Windows Pages
I thought it would be easy to move the index from the second document into
the first document containing the text
It does not appear possbible to copy and paste table pages between the two
Is there any way I can accomplish this task without retyping the Index in
the first document
1. Create on your 132 page document a bla...Why does copy and paste between eMails not work?
Copy no longer copies to the clipboard. Is there a setting I have deleted
somewhere? Using Windows 7 and Office 2007 proffessional.
Does it work if you restart outlook?
Do you have any addins installed that could be erasing the clipboard? I've
seen this happen with addins and contacts, but not email. to test, open the
new message form before copying so you just need to copy and switch to the
other message. (http://www.slipstick.com/Contacts/clipboard.htm)
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Cent...Copy field data to multiple places
Newbi here.... I have a access 07 file of about 1000 records (rows) and a
field (column) I'll call the "project number". All the records do not have
the project number inserted as of yet. Is there a simple means to insert a
project number in say 50 records at a time, another project number in
another 75 records etc. Copy/Paste will do it but may take months to enter.
Any suggestions appreciated. TIA
On Wed, 27 Feb 2008 15:31:05 -0500, "Meebers" <firstname.lastname@example.org> wrote:
>Newbi here.... I have a access 07 file of about 1000 records (rows) and ...Pivot Tables & changing data
Hi - I have never used pivot tables in Excel before so hopefully what I am
going to ask is possible and not too complicated for me.... :o)
I am working with Excel 2003. I have a pivot table already set up and the
information is pulling data from a row titled "sum of Subscriber". I added
new data in a new column from the main spreadsheet and I would like to pull
the data from there. Its titled "Adj Subscriber".
Is it possible to switch it? If so, how?
Thanks, Anna Marie
> Hi - I have never used pivot tables in Excel before so hopefully what I am
&...How Do I Copy My Outlook Files To My New Computer?
I exported my Outlook files from my old computer and burned them to a
CD. During the export process, it asked me three times for a password.
When I tried to import these files to my new computer I got "File
access is denied. You do not have the permission required to access
the file." Can anyone help?
Apart from the fact that Import/Export options often lead to corruption -
you should use a simple pst copy -
The pst needs to be on the hd and the read only flag off, before In OL
attempting to open it. NB not import
<email@example.com> wrote in message
news:1145746658.84...Excel sheet truncated after copying to powerpoint slide
We are using Office 2000 with sp3. When we copy excel sheet to power point
slide, some of the rows and colums are truncated. Also the font size is
changed. We can see only some part of the sheet.
Let me know if anybody faced this problem..
Thanks in advance
Debra Dalgleish posted this link that you may want to review:
> We are using Office 2000 with sp3. When we copy excel sheet to power point
> slide, some of the rows and colums are truncated. Also the font size is
> changed. We can s...how to edit my x-axis data on a line graph
Operating System: Mac OS X 10.5 (Leopard)
my x axis data on my graph is just showing numbers 1 2 3 4 5 6 7 8 9 10 11.... and it is suppose to show the years. I can't figure out how to change these values
...Data from Access query to Excel
To pull data from an Access 2003 database, I have created
the queries in Access, then import into Excel. The
problem is that all the numbers that are pulled into
Excel are text and need to convert them into numbers to
run formulas on. I have converted a few sheets by hand,
but, some have will over 50,000 rows. Is there a
function to select all number colums (the colums are the
same through out the sheets) and convert?
There are instructions here for converting text to numbers:
You can select all the columns, and only the num...Using a VBscript to copy/delete/move Outlook messages
I need to write a VBscript to:
- open my Outlook (2000 or XP) mailbox
- read the list of the folders in either the Exchange Mailbox and in local
- open each folder and subfolders
- read information about messages (i.e. sender, recipient, creation date,
and so on)
- move, copy or delete messages based on the above information
Can anybody please provide a pointer to a sample I can start from?
...How to delete duplicate data
I am using excel to consolidate monthly room booking data. I have a date
column and time column.
May I know how to to delete those rows which contains duplicate data with
same date stated in the date columnand and same time range in the time column?
Data>filter>advanced filter, unique records only and copy to another
Excel 95 - Excel 2007
Northwest Excel Solutions
(Remove ^^ from email)
"PL" <PL@discussions.microsoft.com> wrote in message
news:F45DAE2B-252D-4E17-81D8-0F4C060BCB21@m...Compressed Outlined Data Copy
I need to copy only the data that is compressed in Grouped rows and not all
the rows when they are expanded.
When I copy and paste the compressed data, I get all the data that is within
the group, and not just the compressed data. For example:
I need just the following (which is compressed):
Ship $ Line
$5,278.00 CYP Total
$133,122.00 TI Total
$34,660,135.00 Vic Total
$34,798,535.00 Grand Total
when I copy it (D2:E17, but only showing 5 lines because of the
compression), it pastes 16 lines:
Ship $ Line
$5,278.00 CYP Total
$...Using a variable for a chart limit
Since I got instant help on my last query, is there any way to use a cell
reference as an axis minimum or maximum in format axis? It seems impossible,
but there is a lot of experience out there. Thanks in advance.
See Jon's information
Vince F wrote:
> Since I got instant help on my last query, is there any way to use a cell
> reference as an axis minimum or maximum in format axis? It seems impossible,
> but there is a lot of experience out there. Thanks in advance.
Andy Pop...inverting data #2
Please help, I'm stuck! I conducted a survey where respondants each gave
answers to 30 questions using a Likert scale i.e. they answered either
1,2,3,4 or 5 to each question. The data is in the following form:
q1 q2 q3 q4 q5
1 2 4 2 1 2
2 4 1 2 1 4
3 4 4 2 1 4
4 2 3 2 2 5
5 2 3 4 5 3
My problem is that half of the questions were asked in a negative direction
to avoid possible response bias. For the answers to these questions, I need
to reverse the answers. If the repondant answered 1, I want to record 5, if 2
then 4, if 3 then 3, if 4 then 2, if 5 then 1. Is there an...Manual for beginners -- Charts with Excel
You may find useful a training manual I wrote for making charts in
Excel. The manual is for beginners to intermediate users. [So, no VBA
and dynamic ranges and stuff]. Great for teaching college students or
self-mastering the Excel Charts facility. In any case, the book is
free at http://www.vgupta.com
We move mailbox on a new server but somethimes we receive the following
message: "outlook is retrieving data from the OLD exchange server"
Can anyone help me
On Thu, 1 Feb 2007 01:21:01 -0800, Damb0
>We move mailbox on a new server but somethimes we receive the following
>message: "outlook is retrieving data from the OLD exchange server"
>Can anyone help me
What steps did you do to decommission the old server? If you give us
an idea of the version of the old and new ones we can post the right
help ...How to change a bar to line in a combo chart?
I am currently using Excel & PPt 2000 and cannot figure out how to control
which rows of data are displayed as a bar or line in a combunation chart. In
PPt it combo bar/line chart defaults to the last row only as a line and in
Excel it seems to have half as a bar/ half as a line.
In the chart, select the series you want changed. Then, select Chart |
Chart Type... and pick the desired type+subtype.
When a single series is selected the chart type choice applies only to
that one series.
Excel, PowerPoint, and VBA add-...Invisible bar on bar chart
I have a stacked bar chart with 3 bars ie 'series' of data. I have made the
1st (bottom) bar invisible by setting its border, fill pattern etc to
'none'. So far so good.
I want to make the bar visible again, but I cannot find out how to 'select'
it in order to change its format! I need to double-click on it ? Am I
missing something ?
Help please ?
With the chart selected, use the arrow keys and watch the Name box. When you
see the series you want click the Format item on menu bar
Bernard V Liengme
remove cap...Help Required with Macro to Manipulate Data
I have a spreadsheet(s) with the following data on it (this is imported
from a text file)
A B C D
1 Branch Date Total
2 4501 030204 29
4 4501 030204 14
6 4502 030204 331
8 4502 030204 52
10 4503 030204 54
12 4503 030204 85
and what do you want to achieve :-)
"Alan T >" <<Alan.T.firstname.lastname@example.org> schrieb im
> I have a spreadsheet(s) with the following data on it (this is
...Line Chart 03-22-10
I am trying to create a chart that will allow me to have multiple years on
the same chart so the difference can be seen from year to year.
Second problem is there a limit to what can be entered into the axis.
I'm not sure if this is clear or not.
Appreciate any assistance.
Please check out:-
- item number 53.
Open the Workbook and go to the Chart Worksheet.
1. Change data range A4 to A8 to, for example:-
These dates will then appear in the Horizontal Axis of the chart.
This gives y...Copied Objects to new Page Move Around
I am trying to copy a set of interconnected Visio objects from one file to
The copy itself seems to work okay, however, once the objects are pasted in
the new, blank document, Visio goes ahead and re-organizes all the objects
the way it wants to.
Is there any way to STOP Visio from re-arranging pasted objects?
Thanks in advance (I hope)....
Keith C. Jakobs, MCP
what kind of drawing?
Hope this helps,
"Keith Jakobs, MCP" <elohir@NOSPAM.hotmail.com> wrote in message
I can not see the entires I made for the past month. What
can I do?
In microsoft.public.money, Magnus wrote:
>I can not see the entires I made for the past month. What
>can I do?
I don't know what would cause that.
describes using -s switch. That is a simple safe thing to try.
These may not solve your problem, but they are what I would do. I
would also review my backup file situation.
...Remove Data Format Change
I have a program that puts a database's data into an excel spreadsheet. The
problem is that Excel is constantly changing the numbers to dates, which
corrupts the data. I know I can switch the column data type to Text and that
will fix it, but the problem is that when the data is written to the
spreadsheet it overwrites that column data type and Excel does the formatting
that changes my data. How can I turn this off so Excel stops trying to
recognize data types and change their format? Please help because this is
causing major problems for us.
>>I have a ...External data changes not reflected
I am frustrated by something that is probably simple and due to my lac
I had some 10 rows of external data (a named range in anothe
spreadsheet) and I was copying it in just fine.
Then I extended the source to have 20 rows and changed the length o
the named range now when I refresh the data in the destination it onl
brings in the first 10 rows.
Even If I create a NEW desination workbook file it still doesn't pic
up my new BIGGER named range definition(so it isn't something local t
the WKS file)
I presume it muct be keeping some definition around in cache or in
...Data Migration Import
I am setting up the migration to only import the "Account" entity. I load
the cdf table with all the required fields. When I run the migration it
says everything was successful but no data is imported.
What am I missing?