Odd chart type needed
I need a chart type that does not seem to be available in Excel 2007
I'm graphing a gamma ray emission spectrum.
The x-axis is photon energy.
The y-axis is number of gamma rays per second
The plot requires vertical LINES at the energy of each gamma ray.
The height of the line is the number of gamma rays.
The x position of each line is its energy.
The chart COULD be a vertical bar chart with very narrow bars.
But Excel won't allow bars that thin, and needs them equally spaced.
Is there a way to create such a vertical line plot in Excel 2007 (or
On Apr 13, 12:30=A0pm,...DSum help
Being new to vba and Access, I think what I am trying to do is out of
my realm of understanding. I have two querries that query the same
table "QtyUsed". One query "QtyUsed6Mo" filters results by the date
field to records within the last 6 months. The other "QtyUsedYr"
filters within the last year. I want to create a DSum that will add
all the records in the query that have the same "NSN" and add the qty
"Used" to another table "DataTable.QtyUsed6Mo and DataTable.QtyUsedYr"
Usually it is not good practice to store these calcul...Need to undo sync mess
I just picked up responsibility for an SBS WS03 server.
The customer has a Vista desktop.
The customer can not delete anything from his
My Documents as they all have green circles on them,
meaning they need to sync. The customer wants a
plain old put my My Documents on the server. Has
no idea how Sync got turned on in the first place.
How do I turn sync off and get all his My Documents
back on the server where they belong? I can not figure
out who is doing what to who. :'[
Maybe some help here...
Working with network files when you are...Need site for VB Tutorial
Can someone suggest some site to learn VB??
SMILE's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=488
View this thread: http://www.excelforum.com/showthread.php?threadid=26676
"SMILE" <SMILE.firstname.lastname@example.org> schrieb im Newsbeitrag
> Can someone suggest some site to learn VB...Help Required
I need a little help while working of MS Access 2000.
I have a table which contians two columns labellbed as A and B. In
column A I can either enter Vegetable or Fruit (combo box). Now what I
want is that if I select Vegetable in Column A list of Vegetables
appear in colum B and vice versa.
I have tried to write queries and have tried other methods too but I
haven't been successful. I will be very thankful if someone can help
me in this regard.
What you are asking is a very common question called a cascading combo.
NOTE: DON'T EVER USE TABLES FOR ENTER...DGView Binding (Really need help on this one, please!)
I've posted this issue a couple of days ago, but I wasn't clear, so I'm
I want to be able to bind a collection of "Rows" to a DataGridView para the
public fields aren't fixed. If each "row" was made out of fixed public fields
I know I could easily achieve this using BindingList.
My class structure is as follows:
I have a Field that exposes Name and Value attributes. Now, I also
have a class Fields which is basically a collection of class Field as you can
Fields : KeyedCollection<string, Field>.
So far everything ...HELP PLEASE
This is a multi-part message in MIME format.
Does anyone know how to get the animated sigtags moving on windows 7 =
put them on my e-mail they just stop still would appreciate any help
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
Are you a serious Entrepreneur in search of a business that has fabulous growth capabilities? The Wellness Business is the next great business movement. Would you like a proper exchange of values, value given for value received. Do your research on this Company and its exploding U.S. and International Expansion. See why our exclusive products, truly helps people.
Our optional marketing tool, Plug and Play, works 24hrs a day, 7 days a week for you. Take a tour and see how this automated e-mail system can help you expand pass your local area
www.p...Need to integrate a check and witholdings
Hello all. I need to create an integration that I have a customer id, check
date, check number, Check Amt, Witholding Amt and Adj Total Due Amt. I know
I have done this before but it has been a long while. What Destination do I
use for this "Cash Receipt"? and then how do I handle the witholdings (taken
rings a bell not sure if that is correct) etc. Thanks all for any advice to
...Help Me Please!!!
I used this forum back in May this year to find out how to make a drop
down list on which i can click on the name and it takes me straight to
that worksheet. This is working fine but i know need to add more names
to the list. I think i was given a formula to out in somewhere but i
cannot remember what it was or how to view
Can Someone Help me please!! :)
beng120's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23188
View this thread: http://www.excelforum.com/showthread.php?thr...cannot access online help in excel
online help works in all office 2003 programs except excel
...need some pointers
First, i'm sorry for not doing the usual things like scouring the
annals of this group and lurking a long time before posting. I need
some guidance and the sooner the better.
What i want to build is basically a database.
I need the names of all of the staff members i need to help train.
I need the plan of action for each staff member.
I need the dates, types and lengths of the trainings completed.
I need to total the training times, with the possibility to separate
the different types of training and total them also.
I need an easy to read front page, with the ability to select any or
I am using WriteFile function for writting some data to harddisk.
Is there any limit in size of data it can write.
Basically this function is writting imcomplete data.
I checked the contents of file. ( Writs encoded data to file then
decode the data using Winzip ( MIME data )
no of Bytes are at boundries like : fff, 9fff, ffff ...
Any idea why this is hapening ?
I'm not sure if there is a limit, or how to find out.
Are you checking the parameter that tells the number of bytes written to see
if it equals the number of bytes to write? Perhaps you can just keep calling
WriteFile...VLookup in VBA Help Needed
I am getting an "Unable to get VLookup property of WorksheetFunction class"
error on line "c.Offset(0, -1) =", even though VendorTable
Private Sub cmdUpdate_Click()
Dim c As Range
Dim lRow As Long
lRow = ActiveSheet.UsedRange.Rows.Count
For Each c In Worksheets("MarketList").Range("C2:C" & lRow).Cells
c.Offset(0, -1) = Application.WorksheetFunction.VLookup(c,
VendorTable defined here:
Worksheets("AAV_Table&quo...do people need to be out of GP for the backup
I was surprised to find out just now that, unlike with making a manual
backup of a SQL company database, you cannot use the GP 9.0 File...Backup
utility to backup a company if users are in that company. (SQL manual
backups DO let you make such backups, even if people are in the company.)
Now, let's say that you want to take advantage of the Schedule feature of
the GP backup window. Moreover, let's say that users are still logged into
GP while the scheduled backup is running. A "regular" SQL database backup
plan will allow a backup to be performed even if use...Internet site shortcut needed.
How do I put an internet site on the screen as a shortcut.
"Frank Martin" <email@example.com> wrote in message
> How do I put an internet site on the screen as a shortcut. Seems
Save it as a Favorite. Drag it from My Favorites to the Taskbar and then
to the Desktop if you want.
Imperial Beach, CA
And, or: show the menu bar>File>Send>Shortcut to Desktop
...occasionally changing tables
I have a database that requires fields to be added to tables and/or new
tables to be added 1-5 times per month. One of my forms is for new entries,
another form is to edit older entries, and a couple of other forms only show
filtered data (which is filtered via queries). Every time I make a change to
an existing table or add a new table, I have to update every single form.
Almost all of the forms look exactly alike, they are just connected to
different queries. The new info also has to be added to every query.
Is there an easier to may to make changes? Can the forms and queries be
base...Range.Select Using Variables
Dim firstrowOLD As Long
Dim lastrowOLD As Long
firstrowOLD = ActiveCell.Row
lastrowOLD = ActiveCell.Row
-need correct syntax for next line-
Range("H" & firstrowOLD : "I" & lastrowOLD).Select
-I get a Compile error: Expected List Seperator at the colon-
-not sure how this is different from Range("H25:I30").Select-
gradientS's Profile: http://www.excelforum.com/member.php?a...Please Help with Free/Busy
I am trying to setup a free/busy server and need help. I have got an account
setup with ftp and http servers running. I can publish .vfb file to the
server with ftp, but am having a problem when trying to search others file. I
got it to work with a file: share, but I need ftp or http. Please help if you
I had to uninstall Outlook from the MS Office XP suite because it caused a
problem with my printer. Is there a way I can get the installation files
for Outlook by itself to re-add to the suite? My setup CD is corrupted.
Please! Any assistance will be greatly appreciated!
No, you'll need the CD. You can contact Microsoft to obtain a replacement
set of CD's.
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Paul J. Perillo" <vze47j...Urgent!Need help with creating a Christmas PowerPoint slideshow
I'm creating a Christmas PowerPoint slide show of my family,can someone tell
me where I can download free Christmas templates for my presentation? And I
want to put this PowerPoint slideshow on Youtube to share with all my
relatives and friends. I tried to upload an.PPT file to Youtube but failed,
any idea? Thanks
There are some templates on office online:
MVP - PowerPoint
"Dwight" <Dwight@discussions.microsoft.com> schreef in bericht
new...Need a formula #4
I would like to have a formula that would calculate the following.
Starting in year 2007 and ending in 2024 if each year the amount went up by
3 % each year
My worksheet will have the years in column A and I would like the
calculations to show up in column B
Thank you to anyone willing to create this formula for me
If you have the years in A2:A19 and in B2 you have the start amount, in B3
and copy down to B19
Microsoft MVP - Excel
"Just Me" <No@isp.com&...Help with average formula
I'm trying to calculate average of figures as follows:
So the question is that if there is one row that has no numbers in it
how do I exclude it from the average... meaning that average would b
counted like this (10+20+15+5)/4 and not (10+20+15+5)/5.
Message posted from http://www.ExcelForum.com
If a cell is blank, it won't be included in the average.
"Juha" <Juha.firstname.lastname@example.org> wrote in message
> I...Chart percentage display needs to be neater
When using line charts with percentages at various intervals, the resulting
chart usually has the percentages displayed over the trendline and I end up
having to click each percentage and move them so they can be more easily seen
on the chart.
Is there a way to automate this either at the time I run the chart or once
You could select the set of labels, press CTRL+1 (numeral one) to open the
Format Data Labels dialog, and on the Alignment tab, choose the Above or
Below position option, instead of the default Left.
Jon Peltier, Peltier Technical Services,...Install Module choices mapped to Help Menu Module Listing
Hello, when installing GPv10 you have choices of what to install. For
example: EFT for Receivables, Electronic Bank Reconciliation,
Professional Services Tools Library, etc. But when you go under
Help>Options and display the registration report it's not a one-to-one
mapping of what you chose when doing the install. For example modules
listed in my registration report that are not registered are Cashbook
Bank Management, Bank One Commercial Card Integration, Bank One Direct
Paycheck Card Integration. I don't know if these are mapped to EFT
for Receivables or Electronic Bank Recon...