Print pages in collated order
I have a program that I am putting together...it allows a user to use a ToggleButton to print out a variable number of pages depending on how many products have been chosen.
The problem is when the pages print, they come out by individual product, not collated sets (e.g., if I want to print six copies of each product it will print out six copies of product number one, six of number two and so on). I want to be able to print them in order (e.g., one of product one, one of product two, etc…so that eventually six full sets are printed out).
Here are the string of commands that I have so far...i...Make lines on a graph appear with a button
I need to create a graph with 40 or so lines graphed but only one up o
the graph at a time with the use of buttons. I would really appreciat
a hand, I am very new to this level of Excel. Thanks
Message posted from http://www.ExcelForum.com
Select all the data, and create a line chart
Select a cell in the table
From the dropdown list in one of the heading cells, select an item
The chart will display the data for that item
geistritter < wrote:
> I need to create a graph with 40 or so lines graphed but only one up on
> the graph at a tim...how can I change the size of each cell consistency?
how can I change the size of each cell consistency? I mean width and height
of each cell. Thanks!!
You can't change the size of an individual cell.
You can change the width of column(s) or
the height of row(s)
- to a specific width
- to autofit a selection.
Format, Column, width, specify width or autofit a selection
Format, Row, width, specify height or autofit a selection
You can double click on the border between two column headers
or between two row headers to fit row or column to selection.
If you want a program...XY scatter graph
How do I attach dates to data points when the x&y values are not dates?
One way is to use Rob Bobey's free addin, Chart Labeler.
gps tech wrote:
> How do I attach dates to data points when the x&y values are not dates?
Andy Pope, Microsoft MVP - Excel
How do i make a graph predict the next value from 3 tables with info
eg Table 1 has 5$ profit
Table 2 has 3$ profit
Table 3 has 8$ Profit
how do i make a graph which predicts the next set of values from these
peabushmartin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27399
View this thread: http://www.excelforum.com/showthread.php?threadid=469414
The mechanics of getting a chart to predict future values is easy.
Chart your data in the desi...Corporate Name Change
How does one change the name of a stock (and symbol) when
a company (such as AOL) decides to do so
Select AOL from your portfolio, right click and choose "see details"
You can rename it and change the symbol there.
"Wade" <email@example.com> wrote in message
> How does one change the name of a stock (and symbol) when
> a company (such as AOL) decides to do so
Thanks ... I get an error stating the ticker is already
in use. How can I get around this (is there a global
ticker li...Changing Time To Different Timezones
I am a new user having just acquired excel 2007 and would appreciate any
help. I have a column of dates
along with time in CST. I live on the west coast and
would like to have excel convert the time part of each
entry to PST, or maybe jump to EST. How do I do
this. The columns are in this format:
Going down the columns, the dates change but the time is constant with
the example showing 9:20 am. It would be nice to have a selector button with
the choice of 0 for CST
-1 for MST
-2 ...Work Orders #4
Ok lets see, where to start...
The scenario is..
The customer at the store is buying two items. One he will take home with
him now and the other will be shipped. We would like to be able to make a
payment for the shipping. The shipping carriers have been defined and we have
a 'by weight' situation table setup.
What is the best facility/procedure for this? (Layaway, Work Order?)
Can we make a payment on this without shipping or picking up the final item?
What is the impact and procedure if we want to return the 1st item and use
the already recieved payment for the balance of item ...Graph within a graph
I am looking to have a pie chart show general information and then have
another pie chart show a section of the origional in greater detail. Is this
Have you tried using a Pie in Pie chart?
"Jen Kulak" wrote:
> I am looking to have a pie chart show general information and then have
> another pie chart show a section of the origional in greater detail. Is this
That is what I am trying to figure out how to do. I know where the option
is, but for some reason I cannot figure out how to enter the data correctly.
"Barb R." wrote:
&g...Change closing amounts after Z
Probably a stupid question, but one of my cashiers closed the register
without entering closing amounts and now our Z report reads that we were
short. Does anyone know of any way to go back and change those totals, after
a Z has been done?
Jen: Not a stupid question. if it was, there would be a lot of stupid people
asking that same question. To answer your question in short - it's not easy.
You have to get into the guts of the database and make changes via SQL.
These changes need to be made in several places. Unless you are very
comfortable with database administration, I ...sales graphs
How can I create a graph that would show sales/dept on
the Y axis and years or months on the X axis?
use a pivot chart/table in excel. You must create a datasource forst.
"irene" <firstname.lastname@example.org> wrote in message
> How can I create a graph that would show sales/dept on
> the Y axis and years or months on the X axis?
...Input value changing on refresh
I am working on a budget system. The user can apply a budget by month
against an account or by year and apply a spread which distributes the total
by 12 i.e. 120 so 10 in each month.
There are two option buttons. One for by month and one for by year. There
are 13 text boxes underneath running from left to right. The months start at
April and end in March. The 13th box is the total.
The bug is that when you enter data and choose by year and then decide to
change a month, when you switch back to by year the total has not updated.
The data in the months are correct though. When you...Resizing Graphs
I have problems with Excel when there are tons of graphs i hve to create with all the graphs being on one page. Having to resize all of them when they are all ALREADY different sizes is a pain. I know how to hold down the control key and select them and resize them all at once, but some or still larger than others unless i resize them individually. Is there a way to make them all the same height adn width some how? or is this just a dream? Must i resize all of them individually?
I personally use an add-in (.xla) which includes the following code (you can
pick up the size of a chart with ctrl...How to change Me in contacts?
I've duplicate entries of my name in Contacts. If I go to delete one of them
I get an error message that says that entry is designated as "Me" and to
select another entry in the contact menu and designate that as Me. I can
select another entry, but I don't see the menu where you designate it as Me.
Can you help?
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
On...Creating a Line graph
I have data that I want to put in a simple line graph: The data is
I mark the 6 cells, select insert chart / line and get a chart with both A
and B labels on the x axis. I go to "select data source" and try "switch
row/column" and get A and B as series names in the legend. How do I get the
label A and the values 23 and 87 on the x axis, and label B and values 200
and 500 on the y axis please?
(Congratulations Microsoft for making something that was so easy and
powerful in Excel 2003 an absolutely primitive disgrace...Event 8213 Error code: 0xc007052e after changing administrator pw
I am getting event Event 8213 Error code: 0xc007052e on my exchange 2003
server. This started after we changed our administrator password. Is there
somewhere that I cas update the password?
"RaptorsFan" <RaptorsFan@discussions.microsoft.com> wrote:
>I am getting event Event 8213 Error code: 0xc007052e on my exchange 2003
>server. This started after we changed our administrator password. Is there
>somewhere that I cas update the password?
All of the Exchangeservices run under the Local System account.
Changing the password of a user should have no effect ...Graphs on Forms
I am having a problem getting a graph to display the variables along
the right axes. The graph sits on a form which is linked to a parent
query. The graph's information comes from a separate crosstab query
that is linked to the form via fields from the parent query. The
graph fields are day (horizontal axis), race time (Y-axis) and race
distance (series field). Unfortunately MS Graph automatically plots
the day field as series and the race distance on the X-axis despite
the fact that in the crosstab query, I have assigned 'day' as a column
heading, 'race distance' as ...How can I control the order of boot seqence
I have a (sticky-note like) program that loads at startup and stays in the
system tray. It loads just fine if it loads early in the boot sequence, but
if it loads toward the end, it leaves its tab in the task bar. The only way
to get rid of this is to right click the icon in the systray, choose about
(which opens a box with the version number) and click the OK on that box. I
know this isn't really a big problem, but just annoying.
Is there any way that I can control the order of the boot sequence without
resorting to third party software? I'm running XP Pro SP2 with ...joining data points on graph
I am merging two graphs and one has 23 data points, the other has 9. The
category axis will have 23 data points but the 9 points are spread out, i.e.
they may be at points 1, 3, 7, 15 etc of the 23-point scale. At the moment
the graph will only join points that are beside each other; how do I get them
to connect to the points that have spaces between them?
minihana wrote on Fri, 10 Feb 2006 11:29:04 -0800:
m> I am merging two graphs and one has 23 data points, the
m> other has 9. The category axis will have 23 data points but
m> the 9 points are spread out, i.e. they may be...help with changing sumif to sumproduct
In ExcelXP this sumif formula is not working and so I thought to try
and change it to a sumproduct but I have been un-successful in several
attempts to reconstruct it :-( The issue is the sunif will not sum
the values in more than one column as in I need the values in columns
N and O summed and the values in columns R and S summed.
=(SUMIF('PIP '!$A$9:$A$150,"Jan",'PIP '!$N$9:$O$150))/(SUMIF('PIP '!
On Aug 10, 7:33=A0am, bobh <vulca...@yahoo.com> wrote:
> In ExcelXP th...I have to compare two sheets for changes
Hi I have to try and compare 2 sheets and highlight the cahnges, what is the
best way of doing this in VBA, I was going to try and do it cell by cell but
I was wondering if there was a quicker way?. Any help would be much
Maybe you can make use of conditional formatting, e.g. if you want to compare
newsheet to oldsheet which is an earlier version of newsheet, then apply CF
on newsheet! Select A1 then select used range on newsheet and create CF with
Choose a pattern and press OK!
„vqthomf” ...Automatic Graphs/ Dynamic Graphs
I have a list of test results, one row for each participant. (Each result is
in a seperate column)
I need to make a graph of all of their results when I click on their names.
Obvously I cannot create a graph for each one, as there could be hundreds of
participants, I need it to create a graph using relevent cell references for
each person on the fly.
I have seen this done in the past, but am unsure on how to accomplish this
Thankyou for any help you can give me
Maybe you used one of these sites previous to get your information.
http://peltiertech.com/Excel/Charts/Dy...Order in court!
Me and some dude are writing a MemoryLeakTracker.
It works pretty damn well, but we have a problem:
(it's encapsulated in a single class, and i overrided the new/delete GLOBAL
operators and used some macro trickery)
How can i assure that it's constructer will happen BEFORE ALL other global
variables classes constructers, and that his destricter will happen AFTER
ALL other global variables classes destructers?
I'm really stuck on this one so if you can help, or need some more
clarification on my problem
JUST SAY ;)
thanks for your time.
>Me and some dude are ...Change color of "selected" (highlighted) text in Word 2008 for Mac 05-17-10
"Selected" text is in a light blue color, which is difficult to see against
the white background. Is there any way to change this color to a different
color which is more easily visible?
Previously answered. See the thread you started 16/05/10 17:35.
On 17/05/10 07:58, Eric74 wrote:
> "Selected" text is in a light blue color, which is difficult to see against
> the white background. Is there any way to change this color to a different
> color which is more easily visible?
In articl...Drawing Graphs
I would like to create an application that displays one or
more graphs on tabbed pages in a single window. These
would be straightforward XY coordinate line graphs of the
type you would typically see on the face of an
oscilloscope. Although my experience with MFC has been
sporadic and minimal, I don't want to buy some 3rd party
package to do this. While I could do this the hard way
(i.e., get out my copy of Prosise's book and start
reading), I was wondering if there is a standard class
already in existance to do this, or maybe some standard
Windows functions. When...