I would like to make a grafh with excell but seem to be very lost.
:confused: I would like the graph to go horisontal left to right
Like a time-line.
Thanks for any tips
dammit1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16311
View this thread: http://www.excelforum.com/showthread.php?threadid=278285
By 'time-line', do you mean a gantt chart?
http://peltiertech...Excel slow to epen with Network Connection
Excel 2003 has recently become very slow to open. Regardless of the
workbook / file. I have disabled all Add-In's and cleaned out the
folder. The slow down appears to be related to having a live
internet connection. If I disable my connection or pull out my
cable and launch Excel it opens straight away, if I plug it back in
re-enable it it takes 30-45 seconds to open. I have added Excel to
Windows Firewall exception list but it still takes around 15-25
open a workbook.
Any ideas what its doing? I have read somewhere online about it
bef...Pulling data daily from a differently named report everyday
I have a spreadsheet where I use formulas to pull data from multiple
reports on a shared server everyday. What I do is to save those
reports under a certain name everyday since the formulas have to have
the static report name in them to pull data. (For example, A1 may pull
data from c:\reportfolder\reportA, B1 may pull from c:
\reportfolder2\reportB, etc). In these report folders our IT group
runs a new report in it everyday but of course they change the name of
the report every day (to reflect the date) . . so in the reportfolder
there will be "reportA-3-12-2009", and "...Table relationships in Excel?
I have an excel file exported from SQL server. There are two tables
1. User (columns: id, name, address, etc)
2. Tasks (columns: id, userid, description)
Is there a way to display the user NAME insead of the ID in the tasks table?
Many thanks in advance! Saturnius
You could do a vlookup on the linked field. If id is the same in both tables
use a vlookup function
> I have an excel file exported from SQL server. There are two tables
> 1. User (columns: id, name, address, etc)
> 2. Tasks (columns: id, userid, description)
> Is...How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta.
While in an Excel Pivot table created in Access, I somehow became "stuck" in
a bar chart view. I'd like to view my data in "Pivot Table Form" not as a
chart. Is there a toggle button or some other way to get back to a Pivot
If it's an embedded Excel file, there should be sheet tabs along the
bottom of the window.
You probably had a cell selected in the PivotTable, then clicked the
Chart Wizard button, and it inserted a new sheet for the PivotChart.
Click on the other sheet tabs, and you should find the pivot table.
Jersey Girl wrote:
&g...Customizing multiple views
I was recently tasked with adding an extra column to the views on our leads,
and initially found myself having to add the column to each of the seven or
so views we were using one view at a time. I then needed to add yet another
column, which was again applied to each view in turn. This has left me
wondering if perhaps I've been stupid and missed something here, such as a
"parent" view which the others inherit from (this appears not to be the case
for the "Default Public View"), or some other way of making the same change
to several views.
Than...change excel pointer
Hiw can I change the colour of the white excel mouse pointer?
Not an Excel question since changing the mouse pointer applies to all apps.
Use Start|Control Panel->Mouse; open Pointers tab and make a selection.
I hope no one else uses the computer!
Bernard V Liengme
remove caps from email
"sarahc" <firstname.lastname@example.org> wrote in message
> Hiw can I change the colour of the white excel mouse pointer?
I'm using a different color mouse pointer...Converting Outlook XP .pst to Outlook 2007 format
I installed Office 2007 over my existing Office XP. I prefer to keep my .pst
file in a location that is easily found, I keep it in C:\1data\Outlook. When
I try to convert it to the new format it tells me the file is in use, of
course it is in use, I have to have Outlook open to convert. How do I get
around that? I still wish to keep it in the same location as my two backup
programmes, Outlook backup and Datakeeper backup, are pointed there. Thank
How are you trying to convert it?
Diane Poremsky [MVP - Outlook]
Author, Teac...How to programme this in excel?
This is what I want to know..
cell B1 & C1 is the cell to enter the duties of two staffs (namely X & Y).
B1 is for staff X, C1 is for staff Y. staff can chose any one of duty in B1
& C1 frm a dropdownlist of 10 different duties(like "Break shift", "10 - 6
PM", "10 - 2 PM"..and so on)..
We have another cell D1 E1 & F1 where we enter the staff strength in the
shop on three intervals of time (say 10 - 2PM, 2 - 6PM, & 6 - 10PM)
Assume D1 cell to show the staffs present in the shop during time interval
10 - 2PM, E1 for 2 - 6PM & F...Different margins on different pages
I am setting up a template for letters at work. The first page of our
letterhead has one ste of margins and all subsequent pages will have a
different sent of margins.
I know that section breaks can be used, but if staff copy and paste text
from existing letters into this new template, the section break moves.
Is there any way of locking the section break to the page? so the pasted
text goes over the top of it?
You could setup your document with a 'different first page' layout. That allows the first page to have a different set of margins to
the rest o...Different values for error bars in series
In Excel 2007, how do you put in different error bar values for each data
point in a series? So far I am only able to put in one value for all in my
See Jon's blog on the subject.
On 06/04/2010 15:52, wdwind1 wrote:
> In Excel 2007, how do you put in different error bar values for each data
> point in a series? So far I am only able to put in one value for all in my
> bar chart.
Andy Pope, Microsoft MVP - Excel
...Excel 2007: No screen refresh
I have a network which around 30 Windows XP pcs, incl. Office 2007
Pro. All updates are installed. Under some circumstance, Excel 2007
will not refresh the screen, for example when Excel was minimized and
will maximized. I saw this problem not on all pcs but on some. I did
also update the graphic card driver and on one pc I changed also the
graphic card. Do you know this problem? Is there a workaround?
...How to add a description to an excel table
how can I add a decription to an excel table?
I want to set a name and a description of a table content. So I know, what
data is contained in a table. My workspace contains more than one table.
Click on any cell in your table(s). Then Insert > Comment
> how can I add a decription to an excel table?
> I want to set a name and a description of a table content. So I know, what
> data is contained in a table. My workspace contains more than one table.
..."Excel needs to close"
Frequently, when turning my computer on, I will get the error message,
"Microsoft Excel for Windows has encountered a problem and needs to close".
It has not been left on nor was it used in the previous session of computer
use. I am using XP Home. How can I fix it or should I even be concerned?
Check to see what is starting up when you boot your computer up. See if
anything is in teh startup folder, check using msconfig as well
"Ed Mullikin" <email@example.com> wrote in message
> Frequently, when turning my comp...Can't save Excel using Save button,
When I try to save an Excel spreadsheet, I get a message saying "GWXL97.xla
could not be found. Check spelling of file name and verify that the file
location is correct." I have never named any of files by that name and don't
know what it refers to. I have to hit the "X" button on the upper right hand
corner and wait for it to ask me if I want to save it, then go through the
save process. This happens even if I try to save changes to an existing excel
This may help...
xl: close button is dimmed after groupwise is installed
http://support.microsoft.com...Unable to open embedded word document from Excel
I have Excel 2003 (SP3) installed on my computer. In an Excel file, I
inserted a word object (created from file, display as icon) and the insertion
When I try to open my word document from Excel, nothing happens. No error
message and the file doesn't open. It is like if my file icon is simply a
When I open the same Excel file with another computer(Excel 2003), I can
open my word embedded object easily.
In fact, I can insert Excel or txt object in Word document without any
problem but everything I insert in Excel doesn't work (word, txt, et...A Different CRM for GP
We are pondering the idea of implementing MS Dynamics CRM. However, I am
curious whether anyone else has had success in integrating a different CRM
product with GP 10.0. It's not that we don't like the MS product; I just
like to ensure I have covered all bases.
Our partner does not have any other recommendations as they have not worked
with any other CRM applications.
Any information would be greatly apprecaited.
GoldMine is a good product, very mature, and easier to maintain table
structures. There are links to GP but I cannot remember the fir...Copying spinners for each cell in Excel 2003?
I have an inventory tracking sheet that keeps track of my inventory.
I've added in a spinner control to increase/decrease a value in a
certain cell. In my worksheet, the value is located in column E, and
the spinner control is in column F. I have about 200 spinners to add,
and need to fill down the links to it's adjacent cell. I found
something related to checkboxes, but how do I adapt it for the spinner
control? The first value is in E3, and the first spinner is in F3.
Create 200 spiners in F3:F203 and link to E3:E203
Dim myRng As Range
Dim Spnr...2 users access calendar online with different rights
user A wants to give user B permission to see, add and edit entries in
user B is able to see, but not to add or edit entries at the moment
in outlook itself its working. user B can open the folder calendar of user A
and make entries and change entries
what have to be done that this is possible also with web access exchange ?
On Thu, 26 Oct 2006 14:09:29 +0200, "Mike Schwarz" <firstname.lastname@example.org>
>user A wants to give user B permission to see, add and edit entries in
&...character spacing Excel 2003
How does one get all numbers in a column to have set spacing instead
of proportional spacing? I remember setting proportional or fixed
back in the days of DOS, and haven't used it since and I'm unable to
find it in Microsofts online help for either Excel or Word (2003).
Try using a fixed width font like Courier or Courier New.
Microsoft Excel MVP
"Joe" <JOsterheim@gmail.com> wrote in message
> How does one get all numbers in a column to have set spacing instead
> of proportional spacing? I remember...Same column, different cell width at different row
I have tried inserting a break and split, didn't work. I just want to
separate the top half of a page with the bottom half so I can apply different
cell width on the same column. Or how would I be able to do this? Same
column but different cell width.
You can't do that.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Glenn Chung" <GlennChung@discussions.microsoft.com> wrote in
>I have tried inserting a break and split, di...Outlook 2007 mail templates
I have som old html mail templates i used in office 2003, i can't
figure out how i use them in office 2007, how do i install them into
html stationery or outlook template format?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to ...Fixed Assets
When using the Fixed Asset module, I am finding some small differences when
compared to the Depreciation calculated by the External Accountants for tax
purposes. Client would like to match exactly to the amounts calculated by
external accounts. What is the best way to fix this issue?
Need more info Patti. What are the depreciation methods/settings that
are creating the differences? Does this occur on every asset or just
MCP-GP, MCT, MVP
East Coast Dynamics
get your gptip42today at www.gp2themax.blogs...Outlook 2007 asking for Trusted Sites?
Each time my user opens Outlook 2007, a small box pops up saying "The current
webpage is trying to open a site in your Trusted sites list. Do you want to
current site: go.microsoft.com
trsuted site: www.usa.gov
After he clicks "OK" twice, Outlook opens fine. Very annoying...what's
causing this? Thanks!
...Selecting the correct records for mailing labels based on SQL Server view
I need to print some mailing labels. I work with an adp Access
frontend and a SQL Server backend.
The problem is this: I need to print address labels for all the people
whose birthday falls within a given month.
So far I have a SQL Server view that generates the names, addresses,
and birthday months (e.g. 1, 2, 3, ...) for the people I need to send
I have a report for the labels that is based on this view and includes
the name and address.
I have a form that brings up the label report in preview mode. On this
form I have a combo box that allows the user to specify the birthday