Data point labels in a scatter diagram
My Y axis is from my "Units" column and my X axis is from my "Revenue"
column. How do I get a third column like "Company Name" to appear as the
labels for the data points in my scatter diagram?
Right click your plot area, choose Source Data, on Series tab in the box with
series names highlight the series you want, to the right of it there is an
option to choose your cell containing the name, repeat this for both of your
series, then right click on the series in your chart, choose Format Series,
on Data Labels tab check Series Name check box.
La...Updating Excel QueryTable using VB
I have searched the web extensively for a solution here but cannot find one.
I am using the following code to refresh data from an external data source in
With Selection.QueryTable.Connection = Array(Array( _
.CommandType = xlCmdSql
.Sql = "SELECT * FROM vwDetailsReporting"
.PreserveColumnInfo = True
.Refre...Find the cell value in excel by using vb code
I'm trying to write a vb code that find a Row and a Column in worksheet2
that i called PoF (headline)
It looks like this
Row/Column: a b c d e
The name is PoF because i will use the same code in different sheets and the
name PoF in different Columns/Rows
The code is a loop.
W = Worksheets(2).Range("PoF").Row
' This will give me the...using "transparency" option on chart settings
When making a chart, I see there is a "transparency" option (under "fill
effects"), but can't figure out what it does or how to use it. Can anyone
explain how to use this option?
It's not available to charts. The dialog is also used for Fill Effects
in shapes. And when used on a shape that section of the dialog in enabled.
If you are after using transparency effect see John Walkenbach's work
Mike D wrote:
> When making a chart, I see there is a "transparency" option (un...Can I link an SQL database to my Outlook Contacts using Access?
We have contact data sitting in an SQL database and I would like it to be
viewed and updated live in Outlook. Is this possible? Is Access the correct
method to do this? How do I "double link" a file in Access so that it is
linked to an SQL database AND to outlook?
Also I'm using Acess 2002 and Outlook 2002
> We have contact data sitting in an SQL database and I would like it to be
> viewed and updated live in Outlook. Is this possible? Is Access the correct
> method to do this? How do I "double link" a file in Access so that i...Create dynamic code by using Reflection
I have hard to see a situation when I would use the reflection feature to
create the code dynamically ?
Can somebody give me a hint when this situation would arise ?
It's much much easier to create the code in the normal way.
"Tony Johansson" <firstname.lastname@example.org> wrote in message
> I have hard to see a situation when I would use the reflection feature to
> create the code dynamically ?
> Can somebody give me a hint when this situation would arise ?
> It's much much ea...Data Analysis Views Dashboard
We use MSPS 2007 with SP2. No MOSS installed.
I am trying to build a dashboard which consists of 4 different views out of
Data Analysis. I have built the 4 Data Analysis views, created a new webpart
page, and added the data analysis webpart 4 times so that I can show one view
per webpart. However, I am only able to see the Pivot graph in one web part
ad rest of the webparts do not show anything. Is there something I am missing?
...Transfering data from another Worksheet
I am trying to transfer data in certain cells on my first sheet(Problem
Sheet) to another sheet(Processed). It is processing ok but it is not
transfering the correct data.
The lines of code that are causing problems are:
ActiveCell.FormulaR1C1 = "=Office Picked"
ActiveCell.Offset(0, 0).Formula = "Office"
It's working fine but it's not transfering the correct data. I want
cell D5 on Sheet "Problem Sheet" to go where I have "office&qu...Search through a data base with multiple parameters
I have two data bases, from a ground investigation which look like that:
(a) Borehole (b) Depth from (c) Depth to (d) Soil Type
1 BH1 0m 2m Sand
2 BH1 2m 4m Clay
3 BH1 4m 7m Gravel
4 BH2 0m 1.5m Sand
5 BH2 1.5m 5m Clay
6 BH2 5m 8m Gravel
(a...Import Data from ACT 6.0
Hi, I would like to import my data from ACT 6.0 into CRM 3.0., Does anybody
have step by step instructions in how to do this?
there are multiple options
1 - use the Microsoft data migraiton framework
2 - buy and use scribe migrate
3 - write your own code
4 - buy a 3rd party utility which transfers act to an easier database then
extract from that
sorry there is no easy quick way to do this
Microsoft CRM MVP
"Behzad1m" <Behzad1m@discussions.microsoft.com> wrote in message
news:7C19676E-...How to read location, content of selected cell in pivot table data area?
Greetings! Am fumbling with the pivot table object, trying to work around
some idiosyncrasies. Would appreciate help on two things:
1. How do I read the cell value when a cursor is located in the data area,
and associate it with an item value or otherwise locate it in the data area
with respect to the framing fields/items so I can flag the row as not
2. Is there an on-line description somewhere of how the parts of the pivot
table object fit together, and VBA access to them?
To give an idea where I'm at - it seems a little wild to need to read the
cell.pivotcell.parent val...Combination chart: primary data labels obscure line series on secondary axis
I have a combination chart; a stacked column chart on the Primary Axis
and a line chart on the Secondary Axis. I use the stacked column chart
to display "bands" which I then overlay with the second data series. So
far so good, the line segments and markers draw "on top of" the bands.
But when I turn on data labels for the stacked column chart (to
identify the bands), they display in *front* of the line series?! The
column itself, remains behind, but the text of the data label is
drawing on top of the series.
Is there a way to force the labels *behind* the series on the se...Using HTML in email signatures/emails in general
My boss has produced a Microsoft Publisher file which I have saved as
HTML. There are about 15 images with the file and a couple of XML
I want to insert this HTML into an email to send out to customers. I
have created a signature and inserted the HTML. When I create a new
email, this signature and the HTML page is displayed within the email
However, when sending it to recipients with virus email scanners
(mainly AVG) that insert scanning details into an email (such as "No
virus found in this incoming message"), the HTML does not display at
all. Can anyont s...Help requested in formulating Functions and script to create a mat
Visual Studio.net 2003, SQL Server Report Designer, SQL Query Analyser.
I have a table of milestones with data such as project, miletone name,
baseline date, planned date and actual date. My task is to produce a chart
that has months in the columns and for each month a set of blocks of data,
made by concatenating fileds form the table, for milestones due in that
month. I can extract the 'blocks' of data easily enough but when I put them
in columns each successive month starts on a new line below those of the
previous month. I need it so that the first milestone of each ...Extract Data Validation Input Messages and Titles
I have an Excel spreadsheet with approximately 40 different data validation
input messages and titles.
The spreadsheet isn't mine, but I need to get the input messages and titles
out of it to put into another spreadsheet. I know that I can cut and paste
each one, but this is painful, given that it is going to change, possibly
Can someone point at how to automate extracting the validation input
messages and titles.
The following code will insert a new sheet, and list the data validation
Dim ...Why doesn't active quote get used in Pipeline report?
Here's the scenario I'm trying to model:
1. Create opportunity. Manually enter a ballpark figure of $10,000.
2. Work the opportunity a bit, and determine the needs.
3. Create a quote, adding existing products, for a total of $15,000, and
4. Run the pipeline report. Revenue is $10,000
5. Go to opportunity and change to system-calculated.
6. Save and close.
7. Run pipeline
Result: Revenue is zero.
Expected Result: Revenus is $15,000
I'd expect that if I activate a quote, the quote now drives the forecast
revenue for that opportunity. I would expect that when I acti...Business Data Lookup 07-11-06
I have installed the Business Data Lookup add on which is supposed to allow
CRM data to be inserted into office documents such as a Word file.
Inside of Word 2003, I see a "Insert from CRM" button, but when I click on
it, nothing happens. It is just clicked, but no options come up after that.
Is this a bug?
Office Equipment & Supplies
I think it is. I experienced the same.
On top of that it will slow down MS Office heavily. Forget it.
> I have installed the Business Data Lookup add on which...Does Preview Pane create a virus vulnerability?
I have my Outlook 2002 set so that the headers are on top and a preview of
the email is below.
Does that open me up to the possibility of receiving a virus or malicious
code even if I don't open attachments?
Would anti-virus software guard against this?
It's possible, yes - but you should have good AV software installed anyway,
and a firewall - both are pretty much mandatory on all networked computers
(connecting to the Internet through a modem counts as that, too!) Your AV
software should be updated regularly - try daily if possible.
Keep Windows and all your office ap..."Program trying to access e-mail addresses" msg
Hi. I recently installed SP3 on my computer, and now I
get an odd message when I open emails. A box pops up
that says, "A program is trying to access e-mail
addresses you have stored in Outlook. Do you want to
allow this? If this is unexpected, it may be a virus and
you should choose 'No'."
My virus scan turned up nothing, and the "detect &
repair" function of Outlook did not change this. Anyone
have any idea what's going on?
Same here. After "yes" or "no" outlook stop responding.
Curious to find an answer!
Mel &...e-mail the current worksheet using a form button
I want to create a submit button that when I click on it, the current
worksheet/file will be e-mailed to someone. Instead of saving the
file, then inserting into an e-mail. I have seen this before in a
file before, but can't figure out exactly how it works. I happened to
notice in the VB Editor I saw something like...
Or something similar to that. I don't know any VBA.. So if that's
what I need to learn, then let me know.
Richard, check out Ron's site for a LOT of information on this
http://...How to bind an ActiveX control to a Data Control?
I am building an ActiveX control and I need to bind my
control to a data control when using it in VB6. My
control is a multi column List. I know I should add a
property called "DataSource" that returns the recordset
of the Data control, then should move into the recordset
and add the records one by one to my list. The question
is how can I add the DataSource property and be able to
read from the data control and retrieve the data. Is
there a direct way or should I do it manually?
...PDK Personal Data Keeper Timesheet Modification
Is it possible to modify the form for entering a timesheet in PDK? I would
like to have the project name as well as the project number display on the
time entry screen. Currently only project number displays on the timesheet
form, although you can see the project name in the related look up.
I would like to hear from anyone who uses PDK about how to make the product
simpler to use, or what product you are using in lieu of PDK to track time.
My e-mail address is email@example.com.
...Dynamic references in diagram source data?
Have encountered problems when copying and pasteing diagrams and their source
data areas. I wish to exclude the $ signs in the source data formulas in
order for the diagrams to retrieve data from different areas in the same
spreadsheet. This however seems impossible because excel automatically
reinsert the $ signs when I manually remove them from the source data
Any thoughts? Thanks.
...Outlook wont start, even as I had previously used it on the same l
Recently had a system crash occasioned by impatience with a Windows update.
After two weeks of tinkering, decided to reformat laptop back to factory
settings. Since HP restore will not work, had to reinstall most sofware
programs including Norton 360 and Office 2007Plus. Thereafter, most of my
files were recovered from the most recent Norton 360 backup. Problem now is
that all units of Office 2007 works perfectly except Outlook. It wont just
start. All suggestions to repair Office installation or Outlook failed.
Anyone with a similar problem and solution out there? Please help.
..."No indexers" on creating "New Shared Services Provider "
Hi to all,
I've this problem, I what to create the new and first "Shared Services
Provider", but on "Index Server" section I don't find any Index Server (in
What can I do? Where am I wrong?
Make sure you configured and started the Search services.
Daniel A. Galant
Imagine what we could be... if we could just imagine.
"Dario Concilio MCP" <firstname.lastname@example.org> wrote in message
> Hi to all,
> I've this problem, I what to creat...