Linking a cell to a chart title
How do I link a chart title to a cell reference in another
worksheet? I have over 200 graphs in one spreadsheet and
need a quick way to update the titles when mgmt changes
for each sales team.
...Help With CD Label Design In Publisher
Can anyone point me to a (I suppose) downloadable template to create a CD
label in Publisher 2003?
I'm looking for:
1) A label template where I can adjust the position of the CD Label to match
the sticky labels that I use.
2) A template where the text on the CD wraps (internally) to the curve of
Thanks to all who are able to help me on this.
It's a 106 miles to Chicago. We got a full tank of gas, half a pack of
cigarettes, it's dark and we're wearing sunglasses.
"Gary Clarke" <firstname.lastname@example.org> wrote in message
When creating a simple bar chart, how can i create it so that it doe
not include items which have a zero value.
For example, my data may go like this:
Assuming that the values change on refresh, how can i avoid the grap
including the empty "vans" item showing zero????? WITHOUT Having t
re-plot it each time.
jjj's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=742
View this thread: http://www.excelforum.com/showthread.php?thread...Source data, in Chart Menu, is grey and not accessible.
I set up a pivot table and designed a chart, saved and closed out of the
workbook. Upon returning to work on this project, when selecting the chart
menu to work with my source data, the source data is grey and not accessible.
What might be causing this and can I correct it?
It's a pivot chart. As soon as it's created, it's linked permanently to the
pivot table, and you cannot change the source data. you cannot add more data
that's not in the pivot table to the chart, nor can you remove data that is
in the pivot table from the chart.
Jon Peltier, Microsoft...M05 Category and Sub-Categorys
Without a doubt, this is the coolest Money program yet. I purchased
Microsoft Money 2005 Deluxe and have spent time today finding that all my
banks have been added to direct downloads. It is so much better. My
experience thus far makes me think that the doom and gloom naysayers here
are just not doing things correctly, or they screwed up at some point
because this program is excellent.
To be fair though, while I do enjoy the software as is, I wonder if anyone
has figured out how to change the program to have one entry box for the
category and the next box for sub category? I mean, this...Chart color.
Excel 2000 chart is losing color when pasted into Outlook
2000 email message. Any suggestions?
How are you copying/pasting the chart? If you copy the chart as a
picture, using the As Printed options, and if you have a black and white
printer installed, you may well get a gray scale image. Try copying as
a picture (hold down Shift while selecting Copy Picture from Excel's
Edit menu), using On Screen options.
Jon Peltier, Microsoft Excel MVP
Donna L. Olson wrote:
> Excel 2000 chart is losing co...What are the zig zag lines under text?
I've got tiny black zig zag lines under my text. They're not spelling errors,
because spell check is completed. I can't view what the document layout
looks like because of these nasty little lines.
Word 2007, print layout view.
It indicates hidden text. If you toggle off the ShowAll command, the text
Terry Farrell - MSWord MVP
"Pamoola55" <Pamoola55@discussions.microsoft.com> wrote in message
> I've got tiny black zig zag lines under my text. They're not s...Recovering Master Category List 'after' reformatting C
I have made a "ghost" copy of my computer to an external hard drive, then
reformatted "C" and reinstalled everything, via original disks (Win XP),
including Outlook 2002. By making a ghost copy, I have a fully functional
external hard drive. If I connect it via the USB to the computer, partitions
receive a new letter in sequence. The old C drive is now S in the external
drive and all the files are fully accessible, except, as it turns out, access
to the old registry.
In this process I lost all my own Categories in the Outlook Contact book,
even so they were...Visio Gnatt Chart
Curious as to how you create page breaks. I click on the
the apropriate box Under view drop down) which shows that
the page break function is on. However, I can't figure out
how it works. I assumed it works much like the page break
function in Exel, Word, etc. Subsequently, when I attempt
to print, it only prints one page.
Try the Page Setup function under File \ Page Setup.
It is dependent on your printer settings
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bill Heckel" <WHeckel@mco.edu> wrote in message...New Email to a Category of Contacts
Strange problem, I have set up a number of categories to easily allow blast
emails to my network of contacts. I select a category (no more then 19
contacts), then action, create, new message to contact, and receive the
"Some of the contacts do not have email addresses ......"
The email is then missing a number of contacts. When I look at those
contacts, their email addreses are populated correctly. Also, I can create
emails to them one by one, but never grouping more then one together.
I'm using Outlook 2007 on Windows 7 64 bit. Thanks in adv...widows media centers tv
I have installed a tv card that actually came with the computer. Some german
name haupp something. It used to work, now it doesn't. The media center
tells me that it is a hardware failure, but I doubt that. How can I
reinstall media center?
...need variable time axis available in XY chart for area chart #2
I am unable to use different X axis in the Area chart, which is available in
the X Y charts. How do I use the X Y chart features of variable X axis to
make the area chart?
...Multiple Numbers on ONE Label
I have several thousand labels I need to print. I would like to put up to 4
part numbers on each label (Avery 5164). These labels will placed on boxes
that hold product. Some labels may only get 2 or 3 part numbers per label
depending on size of the part. My part numbers are classified as S,M,L. Can
this be done? Example...
ABC123 - small
ABC234 - large (max 2 numbers per label)
ABC345 - small
ABC456 - med (max 3 numbers per label)
BCD123 - small
Print a Quantity of a Label
The article assumes you have a Q...Memory Leak when copying charts to another worksheet
I have a BAD memory leak when I copy a chart... even a blank chart to
another worksheet. It eventually causes excel to crash.
In my example, the sequence to crash excel was as follows:
- Copy Chart 5000 times (loop) - less times would work too, and you'd
see the increase in private bytes as you go along
- Copy method of range class failed
- Clicked End button on debug message box
- Closed Excel
- Message: The picture is too large and will be truncated
- Excel.exe - Application error. The instruction at "0x300dc756"
referenced memor...Category sync Outlook 2007 WM6.5
My boss had brought a new smartphone and want to reorganize his
He is actually sorting all his contacts in his Exchange contact list
(via Outlook) and he would like that his assistants helps him.
I've shared his contacts list to his assistants and they cans see and
add contacts in his list.
Now the problem is about categories...
The assistants can see some categories (about 9) but not all of them
(about a dozen)...
they see them without colours but we dont care :)
Can someone explain me that? Is there a limitation? I give "Editor"
p...Synchronizing off line folders, off exchange.
I have setup the synchronization of an exchange mailbox, into an ost
an a laptop.
My problem is that each time the sync gets half way, at the exact same
place, the process hangs and outlook hangs.
I have been told to try resetting some type of list in exchange.
Does this mean anything to anybody?
What version of Outlook and Exchange?
Any errors in Application Event log on server?
> Hi all.
> I have setup the synchronization of an exchange mailbox, into an ost
> an a laptop.
> My problem is that each time the sync gets half way, at the ex...Outlook & Word XP: How do I print labels for Christmas cards?!
I get some incredibly frustrated with MS Word & Outlook sometimes!
Especially when it comes to trying and make it print a bunch of labels for
me, for addressing Christmas cards. According to the online help I can
start in Outlook's Contacts and select those I want to send messages to.
Fine. I've done that.
Now what?! The instructions don't say, and I just can't lay my head on the
keyboard and hope to learn what I'm supposed to do next. I suppose the
online help could help, but I don't know what the "correct" key words would
be, so I cannot enter the k...Printing labels for an Assembly item
RMS 2.0 - We've created and Assembly item that includes two separate pieces
to be sold together. We want to be able to sell these items as one piece,
but need to order them as separate pieces.
When we sell the one piece, we need the inventory to detract from each item
We've set up an Assembly item to do this.
But, now we cannot figure out how to print a barcode label for the Assembly
item set up.
Is there a way to do this?
Nope. RMS cannot print a label for an assembly item.
I wish I had better news, but that's the facts.
Pathetic, but true.
You...center-center text in a table
In microsoft word I can format the text center-center, or center-left, or center-right, ... in a table. But can publisher do so? If Yes, how am I going to accomplish this.
Right Click > Format Table
"If you don't know where you are going,
any road will take you there!"
...Media Center problems.
I am having a bit of a problem with Media Center on my new Windows 7 x64 bit
Firstly, I am unable to remove a folder from the media libraries list for
'Recorded TV.' When I try to remove this folder from the list, I am unable
to. There is a tick beside it that I am unable to remove. I am also unable
to remove it manually windows explorer as access is denied due to needing
permission from NETWORK SERVICES.
Secondly, I am unable to start the Windows Media Center Receiver Service.
When I try to, I receive the following error message: "Error 0x80070...How do I make a chart I have generated in Excel into a jpeg file.
I have a chart that I generated in Excel that I need to make into a jpeg file
so I can resize it and drop it into a web site article. Any help would be
greatly appreciated. I have ACDSee 8 software for the resizing and dropping
into the web article I am working on.
You wrote on Sat, 19 Aug 2006 14:04:25 -0700:
PT> I have a chart that I generated in Excel that I need to
PT> make into a jpeg file so I can resize it and drop it into a
PT> web site article. Any help would be greatly appreciated.
PT> I have ACDSee 8 software for the resizing and dropping int...Partial Grid Lines
I have the same problem as 'newbie' posted on 8/4/05 (see below). Some of my
grid lines have vanished and do not print at those same cells. I have tried
hiding them and saving the worksheet then turning them back on and saving the
worksheet again. It seems that only certain cells are missing. The data in
those cells does not overrun the cell to hide the grid. Any suggestions?
Subject: Where are my partially missing grid lines? 8/4/2005 9:57 AM PST
By: newbie In: microsoft.public.excel.misc
In some of my worksheets it s...Want to use left and center footer in same page
Enter the left footer text in the left footer box, and the center footer
text in the center footer box (and use the right footer too, if you want).
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
"wjs-matt" <email@example.com> wrote in message
...Timesheet Add Lines function ?
There are times when filling out the timesheet, folks will need to add
lines to the timesheet via the "Add Lines" button. Does the list
that holds the projects/tasks to choose from get larger and larger?
Is there some event or trigger that causes a project/task to no longer
display in the Add Lines dialog box of the timesheet?
To the best of my knowledge, the Add Lines feature will continue to show
every project to which a user is assigned at least one task until the
Project Server administrator deletes the project. This means the l...Change the label in bottom menu.
I am rather new to the whole Microsoft CRM thing, and perhaps m
question will seem silly or is directly answered somewhere else, bu
after a day of googling i couldnt find any solution
So back to my question: is there any supported way of changing th
labels for the built-in items at the bottom of MS CRM 1.2 we
interface. If there isnt any supported way for achieving this, - the
where this data is kept, and what are the chances that changes lik
this will be the same for the next releases of MS CRM
The question extends to a larger problem though: we need to translat
every single item ...