Column graph problem
I have a report that displays Global Variables returned from a Public Sub
after calculation. It is in a table format and each cell is a TextBox:
lblNSD No. lblCS No.
lblName1 txtNSD1 txtCS1
lblName1 txtNSD2 txtCS2
lblName3 txtNSD3 txtCS3
lblName4 txtNSD4 txtCS4
The first part has been done and works fine. Now I want to add a column
graph (Excel graph) below this table. Can anyone tell me how to feed these
variables (value) into the column graph or is there an easier way to do this?
Jeff...AP Trial Balance Report Issue
We have a GP 10 SP1 install that out of the blue, the AP TB report with
options report had two vendors that when the report printed - it left blank
pages and even printed the summary for the two vendors on top of the report
headers. We have done everthing from check links to reconcile to drop the
PM00400 to recreate the Rerports.DIC even though this is not a modified
report. Any suggestions?
...Excel page formatting and column wrapping ?
An interesting conundrum for anybody who is up to the challenge.
Essentially what I'd like to do is have a small code book printed fro
an Excel spreadsheet. Each page would come out looking roughly like
this' (http://www.licious.net/misc/spreadsheetcapture2.gif) .
Currently all of the formatting is being done by hand where each pag
is hand-formatted with extra cells near the bottom (for futur
additions) and each half of the page being divided up into two sets o
columns. Basically the columns snake from top to bottom, left t
right. Then the next page is done in the same fashion, le...left far column plus and minus signs that expand rows
I have a file outputted to excel that has in the far left column, left of
the row numbers, a plus or minus sign that seems to group about 3 rows every
so many rows. Is there a way I can clear all this grouping? What is it?
It's grouping, Randy! :) Could be one of two methods:
Data-->Group and Outline-->Clear Outline
"Randy Starkey" <randy.starkeyNOSPAM@NOSPAMvictorychurch.com> wrote in
message news:11b4v312lukv113@c...Autofiltering not working in certain columns
I have a spreadsheet with 15 columns and 130 rows. The autofilter drop list
arrows work fine in some columns and in other columns they refuse to
function. In the latter columns when youclick on a drop list arrow it just
blinks, no list falls down.
I have been unable to find any common reason why the autofilter list won' t
appear in these columns. I am using Excel 2001 for Macintosh.
Thank you for any help someone can provide.
...Wrapping text in column
In Excell 2007, how do you set a column to wrap text?
I tried it and even though it seems to allow me to do it when I select
column and check wrap text from Format Cells, it doesn't work. It only
works when I select one cell and select wrap text.
This is a bit irritating as I have many cells in a column to do this to.
I find that this happens when I paste from Word. If I have the fields set
as Vertical/Top and Wrap Text - then I paste any data from Word, it goes to
Vertical/Bottom and NOT wrap text.
If I paste data from my Textpad program that spans multiple line...Column charts with multiple data in each column
I have five months worth of data that contains a product and their quantity
used. I need a column chart that has the months on the x axis and the
proportion of the product in each column for each month. When I try to make
the chart it throws all the data for all the months into one fat column. Can
How are your data laid out? A cross-table with products (or months) as
column headings and months (or products) as row headings? If so, a
100% stacked column chart should do the job.
If you have data in a single table form, i.e., column headings are
month, product, and qu...All in one peripherals?
Is anyone using an "all in one" card reader, pin pad, signature capture
device. If so what is the make/model and your opinion of the device.
None of these work with RMS out of the box.
TPI Software has a tendering add-in that allows the use of the Ingenico
Entouch 1000 - see http://www.tpisoft.com for details, or call your reseller
Tiber Creek Consulting
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all ca...Impossible to balance
I`m trying to download and the balance my American
express account. But when I reconcile all transactions it
won`t balance for an amount equal to the diference
between the 2 amounts "whay you owed last month"
and "what you owe now" that I entered in the dialog box.
If I force to balance, it says that the starting balance
is not the same in my registers and the one Money
Is someone experienceing the same problem?
>I`m trying to download and the balance my American
>express account. But when I reconcile all transactio...Difference between balance due on statement and balance due in system?
A client of mine had a recent server mishap that caused them to lose 3
months of sales data. Fortunately, they keep paper records of customer
charges and were able to adjust the customer balances accordingly.
This worked for most of the statements. However, there is a small
group that is really throwing me for a loop. This group of statements
is printing a new balance due that is completely different than the
balance due as listed in the customer manager. The difference between
the correct amount and the mis-print is exactly the amount listed as
"Previous Balance" on the statement. ...Combine data from multiple rows onto one row in separate columns
My table looks like this:
Sample_# data1 data2 data3 data4 etc..
0000001 0.1 0.2
0000002 0.2 0.2
0000003 0.1 0.2
I receive data at different points in time and it thus I end up with
multiple sample_#'s and various data columns filled in. I would like to
combine all the data for each sample into one row.
I would like it to look like this:
Sample_# data1 data2 data3 data4 etc..
0000001 ...separate columns (three letter code)
Hi, does someone know how to separate text from one column into two columns?
I have columns like
Everytime, three capitals in the end (which is a code).
Is it possible to separate that, and put it in another column?
Thanks in advance.
--Select the range/column needs to be changed.
--From menu Data>Text to Columns will populate the 'Convert Text to Columns
--By default the selection is 'Delimited'.
Keep the selection and hit 'Next'.
--From the Step2 of the Wizard from the options select comma and hit Next.
H...Excel: is it possible to move column contents into a line
Excel 2000: is it possible to move column contents into a line?
ie move column contents A B C to become Column headings A B C.
How is it done.
I used to be able to 'transpose' on earlier versions of Excel but am unable
to find it here.
Copy your cells
select the new location
edit|paste special|transpose (at the bottom)
Remember that you can only use 256 columns.
> Excel 2000: is it possible to move column contents into a line?
> ie move column contents A B C to become Column headings A B C.
> How is it done.
> I used to be able to 'transpo...Aged Trial Balance & Last Payment Info
Is it possible to get the last payment date and amount put on the aged trial
balance - receivables management?
I have found the last payment date and last payment amount fields listed in
the Global Fields section of the RM_Customer_MSTR table but am not able to
drag it onto the report. I am guessing that it has to be done with VB, but I
am not sure where to find the data. Can anyone help with this?
> Is it possible to get the last payment date and amount put on the aged trial
> balance - receivables management?
Its in RM00103 - RM Customer Master...when import EXCEL to ACCESS, the date format excel column title changed...
when linking EXCEL to ACCESS, the date format excel column tilt
changed in ACCESS table.
Excel column title :
In ACCESS linked table
Why and how can I keep the date tile as linked table fields name?
Attachment filename: try.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=57659
Message posted from http://www.ExcelForum.com
are your Excel columns real date values (just formated as 'MMM-YY')?
...Change table to not split rows
This is a little thing that has annoyed me for years. I would like to change
the normal template so that for tables, they do not split rows across pages.
Have no idea how to do that. It always defaults to split rows across pages.
Just checking ... you did open the template from within Word, uncheck
the "Allow row to split" box in the Table Properties > Row panel, make
and undo some change in the text area of the template (to be sure Word
knew you'd made a change and needed to save it), and saved the
On Mar 11, 12:57=A0am, NevilleT <Nevil...@discuss...Previous Balance on the Customer Balance
I have a request from a client, where they want to print at the top of their
customer statement the previous balance from the prior month customer
...making 2 cell in one
in A1 it says John 1n B1 it says Smith, how can i poot both wards in c
with a spac
Message posted from http://www.ExcelForum.com
check out your other post about 9 minutes prior to this one.
"yoem >" <<firstname.lastname@example.org> wrote in message
> in A1 it says John 1n B1 it says Smith, how can i poot both wards in c1
> with a space
> Message posted from http://www.ExcelForum.com/
In C1, enter =A1&" "&B
Message posted from http://www.ExcelFo...Account association and monitored email address one more time
I have changed the monitored email to Kay@discussions.microsoft.com since the
last time I was in contact with Todd Berger to keep my real email private,
just as he asked since the last contact. It has been a month or two.
Now I just changed back to my real email account, but on reading Todd's past
posts, I decided to keep it at Kay@discussions.microsoft.com, which should
show according to our past communication.
If Todd is reading this, please confirm within 24hours.
.....Since it might take another 24 hours for my changes to take effect even
though I had changed back to the same ...Hide unused rows and columns
In excel 2007 i would like to hide All rows and columns except for the few i
have data entered into. Any advice? Thanks
Hide Rows and Hide Columns are on the Home tab, Cells group, Format,
Visibility, Hide & Unhide
"kyleb" <email@example.com> wrote in message
> In excel 2007 i would like to hide All rows and columns except for the few
> have data entered into. Any advice? Thanks
...Lines and columns in charts
I am trying to create a 'Line - Column on 2 axes' chart with the market share of 5 companies on one Y axis and the total market volume on the other (X axis is months). I want the market shares to be lines, and the market volume to be columns. I can set which axis each series relates to, but I can't change those series to lines if they are columns, and vice versa.
You can select a series, then select a chart type from the Chart Type
dropdown on the Chart toolbar.
Or, create your own combination chart -- Jon Peltier has instructions on
his web site:
http://www.pel...Hide column is empty, not including header (row 1)
I'm lost on this one, but I'm sure there is simple macro code to do
this. I need this in a macro as I'm massaging data that beyond
removing empty columns.
Dim myCol As Range
Dim wks As Worksheet
Set wks = Worksheets("Sheet1")
For Each myCol In .UsedRange.Columns
If Application.CountA(.Range(.Cells(2, myCol.Column), _
.Cells(.Rows.Count, myCol.Column))) = 0 Then
myCol.Hidden = True
...Start balancing the account after many months of not balancing
I am trying to start balancing my money account after a couple of years of not doing so. I stopped one month because of a problem in the download from the bank and I've never been able to get it straightened out since. I would love to just accept what the bank says I have (it is at least real close to the truth) and start anew from some recent monthly statement. The alternative of closing the account and opening a new one just seems too extreame for the circumstances. Can anybody tell me how to get back into balance? Thanks.
In microsoft.public.money, bballard wrote:
>I am trying...I want to apply a formula to an entire column.
I keep a running checkbook balance in a worksheet. Can I apply the formula
to the entire column (which has an alpha header) without having to drag the
fill handle down manually?
Here is one I have used.
[h7] = [d7]
Set frng = Range("h8:h" & Range("a65536").End(xlUp).Row)
.Formula = "=h7+d8"
.Formula = .Value
"kitcox" <firstname.lastname@example.org> wrote in message
&g...Columns numbered instead of alphabetical.
I have XL that opens with numbers across the columns that
should be alphabetical (ie A,B,C is now 1,2,3). I need
to get the column headers back to their alphabetical
form. The rows are still numeric so now A1 is 11 B1 is
12 etc. Never seen this before and have ran current
virus scans on pc.
goto 'Tools - Options -View' and uncheck "R1C1 Reference Style"
"Chris" <email@example.com> schrieb im Newsbeitrag
> I have XL that opens with numbers ...