how do I print onto 8.5 x 5.5 note cards
The paper size of the note cards that I want to print onto is not shown in
the drop down box where you change paper size. How can I print onto this
Setup your printer first for this size. Page setup should reflect the size and
say it will print two copies per sheet on letter stock. If your stock is
actually the size you stated, you will have to setup a custom size in your
Mary Sauer MSFT MVP
"S.Gipson" <S.Gips...How to have the Y-axis values on both sides
I am working with a chart that where I would like the Y-
axis to be on both "ends" of the chart (right and left).
If that is not possible I would like the y-axis values to
be on the right side, instead of the usual left side.
Anyone knows how I can do this?
To get the y-axis on the right select the x-axis and on the scale tab of
the format dialog check the 'Value (Y) axis crosses at maximum category'
To get two sets of y-axes you will need to add a dummy data series and
move it to the secondary axis. If you use the original data in the dummy
s...looking for a yearly flow chart for amount spending for advertisi.
you may provide some more detail :-)
"maggie" <email@example.com> schrieb im Newsbeitrag
...Extrapolate to zero (n) rather than forecast x units
It would be useful when adding trend lines to be able to set 'extrapolate to
a number' rather than 'forecast x units along'. This would allow you to click
extrapolate to x=0 so that the trend line can be seen back to the axis. It
also means that you don't have to calculate the difference between the last
data point and the point you wish to extrapolate to.
Dave_S_UK using Excel 2003
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree&q...When any cell in row 19 (eg K19) equals X I want the cell in row 25 3 cells before K19 (i.e. H25) to eqaul Y.
Any tips will be greatly appreciated.
Re: When any cell in row 19 (eg K19) equals X
I want the cell in row 25 3 cells before K19 (i.e. H25) to equal Y.
One way to get it done ..
Copy right across to IV25
Above of course, assumes that there's only a single "X" within row 19 at any
time. If you got more "X"'s in row 19, it'll return only the result for the
1st one ...Linking Axis Labels
I have created a line chart where I need for the axis labels and title to be
changeable according to the contents of certain cells. I have achieved this
on the title and 'X' axis by using a text box, and linking it to the cell in
Does anyone know how I can do the same for the 'Y' axis, but have the text
rotated 90 degrees so that it runs parallel to the 'Y'axis line?
If you are using a line chart then you should be able to specify the
cells to use for the category labels. Right click the chart and pick
Source Data. On the series tab there is a...marks unread
One of the clients is using Outlook 2000. He is a blackberry user too.
For last one week, couple of msgs get unread. These msgs are opened
Anyone has similar problem?
Are there any tools/add-on scripts to find out 'read' item time-stamps?
What are the troubleshooting steps you might suggest?
> One of the clients is using Outlook 2000. He is a blackberry user too.
> For last one week, couple of msgs get unread. These msgs are opened
> Anyone has similar problem?
...Primary % secondard vertical axis don't line up
I am using Excel 2007 to do a chart that has a company's revenue presented
in columns on the primary vertical axis and the year over year change in
revenue presented in lines on the secondary vertical axis. The problem I
have is that in 1996, the company lost money and in 2008 it had a profit. I
would like to but seem unable to get the 1996 column to show below the line
while the 2008 column begins at 0. It appears as though the problem is
influenced by the secondary vertical column which needs to begin at 0.
Would appreciate help.
Excel 2007 Cha...why can't Y-axis cross the X-axis at zero
The problem I have is that the y axis crosses the x axis
at 1 and when I try to change that to 0 under format
axis>scale it returns a message saying "The Number must
be between 1 and 31999, Try again bla bla.."
Is there anyway to change that?
On Tue, 18 Nov 2003 10:27:52 -0800, "John Bess"
>The problem I have is that the y axis crosses the x axis
>at 1 and when I try to change that to 0 under format
>axis>scale it returns a message saying "The Number must
>...How to place a secondary y axis bar in a bar chart next to two primary y axis bars?
How to place a secondary y axis bar in a bar chart next to, not over, two
primary y axis bars?
Have a look at Jon Peltier's page.
> Hello specialists!
> How to place a secondary y axis bar in a bar chart next to, not over, two
> primary y axis bars?
> Best regards,
Andy Pope, Microsoft MVP - Excel
Is this what you want?
...Office X to 1.1.2
I'm using Office X, which I upgraded from Word and Excel 98. I have all the
original cds and copies of invoices. I'm trying to update to 10.1.2 and
ultimately to 10.1.5. The installer won't work. When I installed the
original 98 version, I made a typo when entering my last name. So that was
carried forward to OS X. Now I'm running Panther, and my name is entered
correctly in that. Could that be the reason the installer doesn't work? I
can't think of anything else. BTW, is it really worth updating to 10.1.5.
What are the advantages? Thanks very much.
In article <...Secondary Axis
I want to create a secondary axis, but when I go to chart area, format
selection I only get Format Chart Area and no option for <series option -
And yes it is legal SW.
Do I have to install somthing additional?
Firstly you need more than one series in the chart.
Select the series that you want to put on the secondary axis and Format
"BAZZ" <BAZZ@discussions.microsoft.com> wrote in message
>I want to create a secondary axis, but when I go to chart area, format
&...Flip axis or mirror...
How do I make a chart where
X 3 5
Y 7 12
Z 15 20
the numbers below A shows on the left side of the axis and the numbers below
B shows on the right side of the axis.
Sort of like when you look at charts that shows age and gender distribution
in a country - these charts usually have the shape of a christmas tree.
Also know as tornado or pyramid charts.
See these examples.
> How do I...Chart with x-axis as date/time
I have a spreadsheet with dates in column A and times in column B (when data
was gathered). I have a chart using the x-axis for column A (date). How can
I also get the chart to display the time? Basically, right now the x-axis is
in the format 09/24/06 but I would like for it to be in the format 09/24/06
at 12:00 (or something like that). Can I use a custom number format that
pulls data from multiple spreadsheet columns?
Thanks in advance for any help,
Combine the date and time into a single column (Excel stores these numbers
as a whole number date and fractional number time)....how do you split the scale (x-axis) on a curve graph?
In Excel, how do you split the scale on the x-axis to obtain a better
representation of a curve (scatter with smoothed lines) graph? I have many
points over a short range, but other points also far from that range.
If it helps, it is a stress-strain curve, where i try to show the yield
stress, the proportional limit, the ultimate stress, and modulus of
Now this is one that I have specific experience with as it is directly
related to my Master's thesis. I was looking at the yield stress of an
oriented polymer film at a pull angle off of the orientation axis. I...Group Month/Year?
I have a list of articles where each one has a created date.
How can I get a list of Month/Year where there is articles published?
> I have a list of articles where each one has a created date.
> How can I get a list of Month/Year where there is articles published?
Assuming you're using LINQ, I would use the "group by" syntax.
...Cannot reinstall Office v.X
Ok, this will probably show what a novice I truely am, but here it
goes. I have a G3 ibook on which I had been happily using Office v.X
I just had to have my hard drive replaced and, not suprisingly, the
Office program was gone. I've been trying to reinstall it and have not
had much success. Everything seems to go smoothly until I try to open
Word (the only one I've tried so far) When I try to open it all I get
is that blasted spiral. I uninstalled it and sent it to the trash,
emptied the trash, and tried to reinstall yet again. No luck...just
that darned beachball. Anyone got a...Year End Close
I am in the process of closing a calendar and fiscal YE for Dec. 31/07. When
I go to process the close, I get an error message that says that the Retained
Earnings account 3300-000 is a P&L accounts and must be a Balance Sheet
account to close. I checked the account setup and it shows the Retained
Earnings 3300-000 as being a Balance Sheet account with a credit..Anybody
have any suggestions?
1. Can I rib you a bit? Why are you waiting unitil March to close the year
that ended 3 months ago? One of the biggest selling features of Great Plains
is that you can close the ...Printing on 5.5" X 8.5" card stock
All the card templates I've seen are set up to print on 8.5" X 11" paper. I
want to make my cards on 5.5" X 8.5" card stock and am having no end of
difficulty getting the Page Setup and Printer settings so that what I see on
the screen and in Print Preview is what comes out on the page.
Invariably, I'll set it up correctly on the screen, with the text box
centered in the bottom half of the front. When I print it, however, the text
box runs off the page to the lower right corner.
Thanks for the help!
You need to setup your printer for a custom size. Ar...Axis dates pulled from a cell
I want to set the minumum and maximum on a chart's X axis by reading values
of two cells. Is this possible?
Jon Peltier has instructions on his web site:
> I want to set the minumum and maximum on a chart's X axis by reading values
> of two cells. Is this possible?
Excel FAQ, Tips & Book List
Min. and max. axis values can be set from cell values only with VBA
support. For a readymade solution see
AutoChart Manage...Dynamic axis scale
As suggested by 'SA' of 'ACG Soft' in another post under 'Flexible default
y-axis labels in Microsoft Graph', I tried the following code to try to
programmatically control the X-Axis scale of a chart in an MS Access 2003
report. I get an 'Object doesn't support this property or method' error on
the 'Set objAxis = ...' line. I also tried using the ADO 2.8 Library instead
of the already selected ADO 2.5 Library reference.
Any suggestions? Thanks in advance!
**** Suggested Code ****
Dim objGraph as Object
Dim objAxis as Object
Set objGraph =...format axis grayed out
I have charts I do for trend data. In Excel 97 these charts worked
flawlessly and I could adjust the axis scales to make it all legible.
Since migrating to 2000 these charts no longer work as before. The x
axis usually has way to many markers and the text all runs together. I
can no longer go into the format axis dialog and change it the way I
want to, the option is grayed out. What has changed and how do I get
around it? A small sample of the date is below. The typical datasheet
hold 5900+ records and a chart might use 1400 or more records in the
DATE TIME ZONE 1A ZONE 1AA ZONE 1B Z...Grouped stacked bar chart with % on 2nd axis?
I'm trying to create a chart that is grouped and stacked - with a % variance
line on a second y axis.
I am trying to show performance against budget in different groups, with
budget used and budget remaining in one stack, actual money used in the
second stack, and then the 2 stacks grouped for different business units.
On top of that I want a % variance line on the second Y axis.
You can stagger the data like this:
Budget Used Budget Remaining Money Used % Variance
Company A 150 75
...2 Axis Charting with Column and Line Formats
I have a 6 series chart, with two axis'.
The primary axis is in column format, and the secondary
axis is in line format.
I want to add a seventh series (plotted on the secondary
axis). Excel does this but changes the four series to now
be plotted on the primary axis with the column format.
I can change the fourth series to be plotted on the
secondary axis, however it is still displayed in the
column format (and now being plotted in front of, rather
than beside the first three series).
Excel seems to plot the first half of the series in a
column format (which ever axis is on), ...Y Axis : Dynamically Hardcode Min/Max Values?
I have a number of data tables in a summary topsheet. I have added a dynamic
table that uses the indirect function to populate this grid and generate a
graph for only the data our execs want to see.
If I choose the "Auto" feature to assign the Min/Max Value of the Y Axis,
some of the lines in the chart appear too flat... I need to be able to assign
Min/Max Values for the Y-Axis based on my criteria, not Excel's default
selcetions (i.e. the min value should almost never be 0 on these graphs, but
from chart to chart, some are 10 some would be 10,000).
I am using Excel 2003 ...