Displaying hidden data on a chart
I have a number of data series in a table on sheet 1, and this data is
plotted as an x-y scatter in a chart on sheet 2. I want to hide a column in
the table, but when i do this the related data series disappears from the
chart. Is there a way to hide a column whilst still having it plotted on the
chart? At the moment I have just set the column width to 1 pixel, which is a
Yes, select the chart and then via the menu Toosl > Options > Chart.
unchecked the Plot visible cells only.
Nick Terry wrote:
> I have a number of data series in a tabl...Secure deletion of data from Exchange server networks.
I would like to completely eradicate messages from my exchange server network.
When I say eradicate i don't mean detonating my servers and melting them
down for scrap or running 'Boot & Nuke' disks but i want at the very least to
overwrite the clusters on which the data was stored so as to prevent recovery
of the data without examination of the disk platters.
This as far as I know, would require:
Deleting messages from the server message store.
Deleting entries from the server logs.
Deleting messages from the client .ost file.
Deleting entries from client logs.
Running a...CRM E-mail editor
When you are in a client record in CRM and click the 'Send E-Mail' button to
send them an email, is there any way to get this to open in Outlook? My
colleague has asked as there is no spell checker in the editor and his
signature is not attached etc.
...Excel 2007 Pivot Table Question
Is there any programming way to change data sources within a Pivot Table, we
need to switch from a UNC to a drive letter?
Thanks in advance
...Value filter missing in pivot table
I have a spreadsheet that totals sales and commisions based upon a date
range. Basically I've got two worksheets. One with the raw data, and another
with the pivot table based upon the raw data.
I've been unable to validate my totals as compared to other established
reports. After digging into the report, I see that I'm missing 1 specific
sales associate's data in my pivot table. I can clearly see a lot of data for
this associate in the raw data sheet.
While in the pivot table, I can go to the row label, and value filter, but
this one sales associate is not ...Purge trailing space in a table
Below does not purge trailing space in a table:-
Fred Smith trailing space (no merge cells and anywhere in table rows)
What vba do tables require to clean up properly please?
Dim s As String
If Len(.Range) = 1 Then Exit Sub
s = .Characters.Last.Previous
While s = " " Or s = Chr(13) Or s = Chr(11)
.Characters.Last.Previous = ""
s = .Characters.Last.Previous
That code does not relate to tables per se, but to a document generally. In part...Dots running across table. Help!
I've created a table with one row and one column, but later I added a second
row. When I added text to the second row, suddenly the last row moved to
the next page, even though Print Preview showed that there was enough room
for the row and text. When I tried to move that row back to its original
position, I notice black dots on either side of the table, which act like a
page break. I can't get the row and text back to its original page. What do I
What's going on? Is there a way to get rid of the dotted lines so that I can
place the last row with the rest of ...Code to select data
Hi - I am using v2007 and want to know code for selecting from row 2 to the
end of populated data in a spreadsheet. The length of the data will vary
everytime. Any help gratefully nreceived. Thanks. Anita
Assuming you mean you want to select entire rows, give this a try...
Dim LastRow As Long
LastRow = ActiveSheet.Cells.Find(What:="*", SearchOrder:=xlRows, _
If LastRow > 1 Then Range("2:" & LastRow).Select
Rick (MVP - Excel)
"Anita" <Anita@discussions.m...Linking to an Excel Pivot Table
Does anyone know how to break the link between an Excel pivot table that uses
Access as it's data source without recreating the pivot table? It links to a
network drive at work, I need to relink to my local drive but it keeps
looking for my "m" drive on my network at work.
...Data in columns
In Access 2007, I have a table that looks like this:
EquipID Text (5)
Obs Text (255)
I need a report that looks like this:
Equipment A1 A2 A3
User MF FO MF
Bolts secured Y N Y
Instruction Manual Y Y N
Packaging ...Cannot change Gantt ownership to a user with Deny on New Project
Our system is Project Server 2007 with SP2.
For a division with a PMO department – all project managers can edit Gantts
and create new Gantts. We want to change it so that only project managers
which are PMO members can create Gantts. The PMO members will create the
Gantts, change ownership to the rest of the project managers, and the project
managers will continue from there.
The change is to deny the single permission of creating a new Gantt from the
project managers, which are not PMO members.
I don’t want to create two separate and almost identical project mangers ...Un-linked table.
Is it possible to have a text box or combo box in a form that has information
in it from a table that is not linked to any other tables??
On Thu, 2 Aug 2007 13:16:03 -0700, tflett <firstname.lastname@example.org>
>Is it possible to have a text box or combo box in a form that has information
>in it from a table that is not linked to any other tables??
Why do you ask?
John W. Vinson [MVP]
...Change IP address of exchange server
Hi , Thought this would be an easy question to get an answer to, but had no
luck with my searches...
I need to change the ip address of my exchange server, but want to make sure
that won't screw anything up...
I thought that its ok to do that, but because the server is also a dc I want
to make sure.
Thanks for any help on this.
Feel free to change the address. While possibly not required, I'd recommend
Make sure that there are no hardcoded host files or WINS or DNS entries for
After the change, clients might not be able to connect fo...Extra Spaces with copied data
I recently had to copy a large amount of data from my company's website.
When I copied it over to Excel all cells had trailing spaces, 5 spaces
to be exact.
What I need to know is how do I sweep through and get rid of all those
extra spaces. They are interferring with calculations and sorting of
Thanks for all your help.
shane24's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=4770
View this thread: http://www.excelforum.com/showthread.php?threadid=490089
Tr...Bar data not displaying
I am trying to create a bar chart that refers to a set of cells which are
calculating the remaining time after subtracting the differences between
beginning and end times from a static time value (1:15) using the following
The B2 cell refers to the static time of 1:15 that is formated as h:mm. If
there is no start and end time values in the range and therefore the cell is
assigned a IF-FALSE value of 1:15, when the bar chart is created there is no
bar value displayed in the chart. If...Adding information from a form into a table
After data is entered into a form how can I add it to an existing table?
If it's a bound form (the norm), you don't have to do anything. Forms are
intended to be "windows" to tables. A bound form will automatically write
its data to the table when the current row loses focus.
If it's an unbound form, you have to add the data yourself, either using a
SQL INSERT INTO statement, or using VBA and a recordset.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"carrie" <email@example.com> wrote in message
...Auto-Forward Rule Changes Sender to Me
I work part-time at a college that just upgraded to Exchange. With
their old mail system, I set up a rule to auto-forward all my mail to
my main POP account, which I monitor using Outlook. With Exchange,
the auto-forwarding rule changes the sender to my email address. This
means that when I hit reply, the response gets sent to me. This is
not what I want.
The school help desk people tell me that's the way it is and they
can't do anything about it. This seems like such a common situation
that someone would have developed a fix for it. If anyone is familiar
with this situation, I ...How to get data from Yahoo calender ?
I am developing an application in VC++/MFC to fetch the data from the
I searched the Yahoo developers site but i am not getting any clue
that from where to start.
Can anybody tell me that how to start?
Means suppose i would have user's Yahoo ID and Pswrd then which URL
should i call so that i will get the Yahoo Calender data(Events in it
Thx in Advance...
I have changed some of the user roles and permissions in my Exchange 5.5
Administrator, however the permissions do not take effect until I stop and
restart the Exchange services or reboot the machine.
Does anyone know a solution for this?
In the past this has not been a problem and the changes became immediate.
From what you describe, I suspect you are falling foul of the 2 hour cached
permissions issue. See the KB article link below. Note that the article
only references the Primary NT Account - it applies to all permissions,
--...How can I change word spacing in an entire document at once
here is what my word docs do....
They may be looking at the same thing, but they each h ave very
studying it closely. She is telling herself that her interest is
academic, but that might n ot be the
here is what it should look like: thirty five years old with sandy hair that
just might be starting to thin at the back and a waist that is just a bit
thicker than he would like
I want to fix the entire doc at once
It looks like you're saying you want to replace one text with an
entirely differen...Microsoft CRM Data Migration Framework could not initialize
I've got CRM 3.0 installed with roll-ups. I've installed the DMF so I can
import a large number of records but each time I try to start it up I get the
above error. The detailed information says :-
* The Microsoft CRM Server is not responding. A WhoAmI() call did not succeed.
* SOAP Server Application Faulted
Nothing is showing in the event logs and I've checked that the IIS service
is working correctly and the databases is also contactable. I'm not sure how
to go about troubleshooting the problem because I can't see how I can trace
what its doing. I've ...Delete based on another table
I can SELECT but I cannot DELETE as follows.
DELETE Transcript.*, Transcript.SEM
FROM Transcript INNER JOIN YYYYFx ON Transcript.YYYY = YYYYFx.YYYY
"Song Su" <firstname.lastname@example.org> wrote in message
>I can SELECT but I cannot DELETE as follows.
> DELETE Transcript.*, Transcript.SEM
> FROM Transcript INNER JOIN YYYYFx ON Transcript.YYYY = YYYYFx.YYYY
> WHERE (((Transcript.SEM)="3"));
In the query design right-click and bring up the query's propert...Usage data
I am interested in developing an application that monitors data usage. For
example, I need to know how many rows that a user accesses from specific
tables; maybe also, what columns they access. This data should probably be
gathered at the data-access layer because it would be more certain and not
make me rely on having to parse ad-hoc queries.
Does SQL provide any sort of monitoring tool that can give this data?
SQL 2008 has a lot of features and built in reports... also maybe
performance dash board? (It's a seperate installation package)
...change opportunity step name filed to custom entry??
we want to remove the workflow process from our opportunity section. to
do this we would like to have the step name field being fed by a custom
field that i created, and currently being used by the sales staff.
crm 3.0 on server 2003 sp2
--- news://freenews.netfront.net/ - complaints: email@example.com ---
...Changing case #4
Is there a way to change case for several cells. In Word,
you go to Format, Change case, and then you select all
upperlower, lower, Title, etc.
Does anyone know if there is a way to do this with Excel
In Excel you need a macro if you want to change case in the same cell
See this webpages
Here are three macro's for changing text cells in the selection
Dim selectie As Range
Dim cel As Range
On Error Resume Next
Set selectie = Range(ActiveCell.Address &am...