Adding additional data to a pivot chart
I am trying to add a line or some sort of note to a pivot chart and I'm
wondering how to do it. I will have multiple items but the note only
occurs on one date for each particular item.
For example, let's say that I am keeping track of when I buy an item
(month and year) and when I sell an item (month and year). I want to
add some sort of note automatically to my pivot charts indicating when
I put these items on sale (month and year). For example, maybe I put
all RC Cars on sale May-01 and all airplanes on sale Oct-05. How can I
get the sale date into my pivot chart?
I...moving XML data from client to server vice versa
.... The second time I am sending this email ...
.... I want a good solution, please.
.... Thanks :)
What I need is moving xml data from client to server & vice versa, but not
using xml file.
I did something like this :
In server (VBScript) :
xml_list = Server.CreateObject("Microsoft.XMLDOM")
newnode = xml_list.createElement("mylist")
xml_list.documentElement = newnode
itemnode = xml_list.createElement("line")
newnode = xml_list.createElement("element_id")
textnode = "This is a text"...Word should add image-count tool or property
MS Word should add an image-count function, either as a tool similar to Tools
> Language > word count, or as an automatically generated statistic in
document properties. I believe this is available in Sun's Open Office, and
was quite surprised I couldn't unearth it somewhere in Word's Tools >
Options. I often receive drafts to edit that contain 100 or more unlabeled
graphics (i.e. can't generate table of figures) and want to know what I've
got on my plate w/o counting them manually. VB scripts are great for techies,
but please - how hard could it be ...Outlook Picture Compression
When sending pictures through Outlook 2002 to someone
using OE, the pictures appear in the body of their e-mail
in their original size. How do I compress the picture so
that they can see it?
...Making Data and Axis Labels Different
I have a simple column chart that uses millions of units on its Y axis and
puts a label above each column showing the exact value. At the moment the Y
axis shos all the trailing zeros behind each million value, somethiong like:
What I would like to show is the Y axis values without the trailing zeros
but the data label in full. I seem to be able to do one or the other but not
...Multiple Instance of same form retrieving different data.
I have a form that shows Batch Jobs by name. Connected to this is a subform
which shows unique Batch Job Name & Job Nbr combination records. The Batch
Job Name and Job Nbr are the primary keys for the table being sourced by the
subform. For Example, I have a form with Job Name of: Batch Job A and a sub
form which Shows Batch Job A, 12 Steps & Batch Job A 16 Steps. The Job Nbr is
hidden because its an internal number that ties back to source system. What
I would like to do is give the user the ability click on the batch Job name
in the sub form which will open form Batch...Image in a cell
Is it possible to place an image in a cell? If so, can you tell me how to do
No. Images are placed in the Drawing Layer "above" the worksheet. Cells
can contain formulae or data.
If you size an image to exactly cover a cell, you can set the Move and
Size with Cells property (right-click on the image, choose Format
Picture/Properties and select the appropriate radio button) so that the
image remains "on top" of the cell.
In article <6463B5FA-3D07-43B9-90EE-7A5143977C1B@microsoft.com>,
"Mark" <Mark@discussions.microsoft.com> wrote:
> Is ...Combine two sets of overlapping Date/Time data into 3 columns.
I have two sets of data with Date/Time. One set has a fixed interval, the
second is more sporadic. I am trying to combine into these sets into one
table with the data from one set next to the corresponding data from the
A B C D
4/22/2010 9:00 000 4/22/2010 9:01 777
4/22/2010 9:01 111 4/22/2010 9:03 888
4/22/2010 9:02 222 4/22/2010 9:06 999
4/22/2010 9:03 333
4/22/2010 9:04 444
4/22/2010 9:05 555
4/22/2010 9:06 666
A ...Email template with images
How to add images in an email template.
I tried to use SharePoint Designer to design my email template and copied
the entire design and paste it to MS CRM email template editor, but the
images does not appear.
Any help is very much appreciated.
try using visual studio.net and also put it a url to the image.
Microsoft CRM MVP
Web - http://www.crowecrm.com
Blog - http://www.crowecrm.com/crowe/microsoft/crmblog.cfm
"Benjamin Fallar III" <firstname.lastname@example.org> wrote in message
news:AF61147B-68F5-460A-8FDD-322CA9971F40@microso...Show Employee Picture on form
I have an employee table that contains a picture (file name path) of each
The employee form works just fine, displaying the pictures.
I would like to add the picture of the employee to the payroll form, that
is, when an employee is choosen from a combo box I would like to have the
picture show on another box.
The employee and payroll tables are linked, by employeeid, could some one
help me with the code to accomplish this please.
It will work basically the same as the employee form. You will need to add
code tot he after ipdate event of the control box and the...Diaglog/Threading Data Exchange Question
I have learned a lot from all of you, and I hope to over come my latest road
block. I have a smal IRC Chat client I am making.
I have a Dialog Box with Control and I use a worker thread for connecting to
IRC - That Thread will update controls on the Dialog by sending
Now my problem is in the ListBox Control that I have extended to do popup
menu with various commands.
I need to be able to read that controls methods from within the Thread.
so I need to do this from within my IRC Socket thread:
(code not exact - pseudo code)
CListBoxEx myUsers; //Defined in my ...CAE macro for green screen updates with Excel data
I am a user of the Personal Communications AS/400 (Client Access Express for
Windows) WorkStation Program IBM software. I am able to record a vbscript
macro to automate a repetitive update of our ERP using one of the ERP
I need to modify the macro so that it picks up the data to be entered from
an Excel list and "types" it into the appropriate input fields. I need to
get it to process the entire list of values row by row.
Right now the macro recorder has produced a statement like
which I have to replace with commands to...Data Forms #3
Hi I have a spreadsheet that I am filling in using a form.
I have also a row at the bottom with blank rows in between
with a running total. When I print there is a huge gap
between the last entry in the form and the totals at the
end. Is there a way that the form can enter the next line
and push down the totals so that there are no gaps.
This is what I have.
Name Salary Tax Total
Ann 42000 5000 37000
Joe 37500 6000 31500
Total 79500 11000 68500
This is what I want
Name Salary Tax Total
Ann 42000 5000 37000
Joe 37500 6000 31500
Total 79500 11000...Use spreadsheet as data source
We have two workbooks,
Bk 1 contains information relating to production scheduling and
Bk2 is a template used to generate a ticket (workbook) containing specific
information relating to the individual order.
Is it possible to transfer information between the two.
Eg on Bk1 there is a packing spec worksheets for items, what size outer to
use, and how many items in that outer as well as other information, can we
interrogate this (search by item code) and then "autofill" in cells marked
"Outer" and "Number" in Bk2 (ticket).
Tha...Best way to copy data across ?
End users are using an Access 2003 Database with both front end and back
There is a requirement to add fields in a particular table and change the
forms and reports accordingly. I have made a new copy of both front end and
back end while end users are still using the database.
I would like to know what is the best way to copy all data from production
to the newly developed backend ? (How to import data to table) ?
Why not just alter the existing backend? Kick everyone off the system
briefly and make the changes. Alternatively, write VBA code to make the
changes for y...Data Table #2
Is it possible to display the Data Table on a Pie chart, as you can in a Bar
Simple answer, no.
Instead create your own. For more information see Tushar's page,
k f h wrote:
> Hi All,
> Is it possible to display the Data Table on a Pie chart, as you can in a Bar
> Excel 2003.
Andy Pope, Microsoft MVP - Excel
Thanks for the link, is there any way to add the...chart displaying horizontal line for zero data
I am using a column chart in Excel. The chart is currently
displaying a horizontal line when there are zeros for the data. It is
working as it was designed to do... however I would like to make the
graph not display a line when there is all zero data. Is there an easy
way to fix this problem?
In place of zeros use =NA() This displays as #N/A and these points are
ignored by chart
Bernard V Liengme
remove caps from email
<pseudonym@1NET.gr> wrote in message
news:email@example.com.....Exporting Data from access and appending to an existing excel sprd
I run a series of queries each month in an access form that I have created. I
can export the data into a new excel spreadsheet no problem. I am just
wondering whether or not there is a way to export the data into an existing
excel file and append it to the bottom of data that has been exported in
previous months. It's not really critical, I'm just trying to make things
that much easier.
You can always use the drag and drop technique. Open the Excel file to the
desired worksheet, then minimize it to your task bar. Drag a saved query from
your database to the...Pivot tables / source data
Is there a way to take a pivot table and copy and paste it into a new
document so that the source data cannot be pulled up by the person
looking at it? The reason I need to do this is because I have created
a pivot table and included in the source data is very confidential
information. I want to be able to send out JUST the actual pivot
table, but I don't know how to do this without releasing all of the
other information along with it. Is this even possible??
Have you tried doing <copy> (on the table), then moving the cursor to
another sheet and Edit | Paste Special | Values (ch...Collect data from spesific cell in multiple sheets
How can I collect data from cell A1 on sheet 01.01 thru 31.12 (Dates) to
I've tried fill and copy formula with different use of ! and $ but I've not
been able to solve this by my self.
The correct syntax is
Substitute sheet1 & sheet3 for the first/last sheets in the range you want
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
"Espen Rostad" wrote:
> How ...Transactional Data Through DTS/SQL Scripts
One of my client want to create new company in same SQL Server, but
with different segments and format of Chart Of Account. Firstly i gave
idea to use account modifier to change segments and COA within Old
comapny but they require new company. Till now no problem but client
also want all historical/open data for from old company to new one.
I think i need one table for account mapping with old COA and New COA,
then utilize that mapping through SQL Script while transfering data
tables through DTS.
Modules running are AR,AP,SOP,POP,GL,BR,FA,INV,HR,PAYROLL on GP 8. and
whats ...Pivor Table Data Field
This is a multi-part message in MIME format.
I have tried to "show" a data field after using "hide" in field =
settings. How can I make this reappear? Not using Field drop down =
option. The fields orgin is from the excel list and not a calculated =
<!DOCTYPE HTML PUBLIC ...copying data from test databases
We are getting ready to have our client go-live on GP 10.0. For the last
few weeks, we have had to client "play" with their data in GP 10.0 test
companies (test databases).
We would like to transfer their master data from the test companies to the
live companies databases. Before doing so, we will use GP's history removal
utilities to get rid of the transactions that we do not want to transfer over.
Which is the best and safest way to transfer this master data--by simply
restoring a backup of the test databases over to the live databases or by
using SQL 2005 Imp...Display blank data rows in a report
How can I force the same set of row labels in a report even if the value is
null or blank in the table? I would like my report to look like this:
Year 1 Year2 Year3 ----these are the column headers
and the 'static' row headers are:
% OF DIFFERENCE
I would like to make these 6 items to show for each FundName in my report.
It took me a great deal of work to get the numbers to sort of 'Pivot' . But
now I would like the rows to display even if there are no values stored in
I would re...CRM workflow: Error trying to write/get data into/from databse
I've got a workflow rule which call an assembly to write the new contact
record details to a database. I've got the workflow working fine on my
development VM server, but when I test it on our client server, it throws an
error "Object reference not set to an instance of an object" .
I am just wondering what the environment issues cause that to happen, the
only different between the two environments is the sql database is on another
server, and VS .Net is not installed.
Let me know your thoughts.
Thanks in advance,
Can you post the complete...