2 scale in a single chart
I have 2 scale one in thousand dollars and the other one in million dollars.
Is it possible to place the thousand scale in the left column and the million
scale on the right? However due to the huge differences. eg. the chart will
plot from 3 thousand to 10 milion, you will see a big gap there. Which make
the chart looks ugly.
If only I can change the million units inbetween the thousand units.
Can I change the different units in the right and left side of the scale?
It is not clear what you want and where you are stuck.
Do you want to know how to create 2 series one shown on the prim...Changing the order of a chart legend
I have a stacked column chart and would like to reverse the order of the
items in th legend table (my aim is to place the legend on the right hand
side of the chart so that the key lines up along side the appropriate point
in the stack).
Now, I'll forewarn you-- this is an odd situation that I'd never seen
before, and I've been using Excel for a long time now. So, please bear with
me, and if you need to read this through a couple of times, or more to get
it, I'm trying to be clear enough, and concise enough to keep you from
getting too confused.
a colleague of mine opened a workbook that had some worksheet functions in
it, as well as some named fields.
As she explained to me what was happening, it struck me as odd-- not
something I'd seen happen before.
There were numerous named fields...How to email a shared calendar as iCal or other format
A user need the ability to email her bosses calendar to other interested
parties. She can do this for her own calendar but on her bosses shared
calendar the email option is greyed out. The boss only wants the secretary to
have calendar only access. Currently has Editor rights and is using Outlook
2003 with MSES 2003 on Windows 2003.
...Trendline in chart
I was trying to form a trend line in a chart with following input data
in Excel 2000:
After plotting the chart, I added trend line (Polynomial with order 6,
set intercept = 0) along with its equation, which read as below:
y = 6E-07x6 - 3E-05x5 + 0.0006x4 - 0.0057x3 + 0.0215x2 - 0.0318x +
1.1429 and R2 = 0.9998 ------ (Eq. 1)
Though the trend line in the chart neatly fitted over the curve,
however, when I used above equation and fed in same val...switch x and y axis in chart
In excel 2003, is it possible to display my chart so the x, or category, data
goes up vertically and the y, variable data, goes horizontal. In other words,
I want to display the x axis and y axis in each other's place, switched with
If it's a column chart, you could use a bar chart instead. For a line
chart, Jon Peltier has instructions here:
> In excel 2003, is it possible to display my chart so the x, or category, data
> goes up vertically and the y, variable data, goes horizon...Chart x-axis and name problem
I have a quite complex workbook in Excel 2007 with several charts, including
a xy scatter chart with 3 series. The number of points plotted has been
gradually increasing, and when it exceeded 185 on each series, the x-axis
(which is set to Auto for the minimum) suddenly switched to displaying 0 as
the minimum point, thus pushing the plotted area to the right of the chart. I
verified that if I exclude either the first or last point on the series, the
display is OK.
At the same time, all charts sheets lost their names, and became chart1,
chart2, chart3. Renaming them appeared to work, bu...Changing the File Naming Format
I currently drag emails from Outlook to various job folders on a larg
network. The default filename for an Outlook message is the email'
subject line. Often times many messages will have the same subjec
line. Can I change the way Outlook names files? I waste a lot of tim
changing file names when archriving emials. It would be great to ge
Outlook to save the messages/files as the email's RECIPIENT/SENDER NAM
and DATE. Is there a place to specify how outlook names its emai
~~ Message posted from http://www.ExcelTip.com
~~Vie...automate 2500 cut/paste/format from internet to EXCEL worksheet
I'm trying to automate repetitive steps. I have 2500 account numbers i
column "x" of an EXCEL 97 SR-1 worksheet running on Win 98 with 320 M
60% free. I'm trying to retreive the 2002, 2003 & 2004 assessed value
for each account and place them in the appropriate worksheet cells (o
the same line as the account number). So far, I've completed 13
accounts, but doing this step-by-step (below) seems wasteful. An
suggestions would be WELCOME!!
1. Make sure Control Panel Internet Connection Privacy lever is set a
"medium" or below to allow cookies.
2. Fi...removing auto-format /smart quote characters from excel and access data
someone passed me an excel doc with all the smart quotes
and microsoft auto-formatting turned on. i can't for the
life of me get the auto-formatting out of those documents.
- i have saved as text and opened in wordpad
- i have tried opening word, turning off the
autoformatting, pasting the text.
- i have copied/pasted and sent to myself in an text email
(the auto-formatting came out, but the text wrapping
Hi Caitlin, if its a DOC it is a WORD document, if the extension is XLS then
you are in the right NG. Please cofirm.
Gilles Desjar...I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet.
I want in one worksheet to relatively link to/reference cells in
another without changing the format of the current worksheet. I.e. I'm
working on a budget. In "sheet 1" I want to view the employees and
their billable hours sorted by the teams the employees belong to. I
want each employees row/info to be linked to "sheet 2", where it
contains all the same info, but the sort is by employee position, not
In otherwords I only want to enter information into the sheet sorted by
position, and have the sheet by team automatically pick it up. I also
want the abi...XPath Query format...
I am not getting any nodes back with the following XPath Query. Please look
at the XML that follows the code:
XmlTextReader xtr = new XmlTextReader(this.fileName);
XmlDocument xd = new XmlDocument();
XmlNode xnRoot = xd.DocumentElement;
XmlNodeList xnl = xnRoot.SelectNodes("/Envelop/Docs/Doc");
// I have also tried:
int count = xnl.Count;
// The count here is always 0 for me...
Here is the XML...
<?xml version="1.0" standalone="yes"?>
<SDSJob xmlns="http://www.tempuri.org/S...How do I put a formula in a dialogue box; to be placed on a chart
I want to create a separate little box on my chart that will contain a
formula that references cells not necessarily contained in the data ranges.
Microsoft Excel 2002 on a WinXP SP-2 operating system. It would look like a
text box in the upper right corner of the chart, but would contain a formula,
You mean you want to link the textbox to a cell? Select the textbox, then
type = in the formula bar and click on the cell.
You cannot build a full-fledged formula in a textbox like this; build the
formula in a worksheet cell, and link the textbox to this cell.
Jon...Number and text format in the same call
I'm trying to change the format of the following"
123-45-678 -- in other words, adding the dashes. Some of the numbers are the
same 8 digits, but also have a letter. They are currently:
In a helper column put this formula and copy down.....then do Copy >
PasteSpecial > Values on that helper column to eliminate the formulas and
delete the original column if desired.
Vaya con Dios,
"Jim Davis" <Jim Davis@discussions.m...format cells: decimal or integer needed
When I try to fromat a cell and want to change the
category under the number tab I get an error message that
tells me "Your entry cannot be used. An integer or decimal
may be required." Deciaml places is highlighted but when I
enter any number in this field I get the same error
message. I have to right click the title bar of the
Format Cells window to close it. Sometimes I then get an
Application Error- Error access violation(0xc0000005).
Address:0x308047fe. How can I get rid of this bug?
I'm not sure if this will work.
But I tried this.
I used a macro to format my ...Copying a Conditional Formatting Formula
I am tyring to copy a CF formula, using Copy - Paste Special -
Formats, but it is not retaining the relative references within the CF
formula. Am I doing something really silly here thats preventing this?
My CF formula is
This is in D8, so in D9:D31 I expect only A8 to change to A9; A10 etc,
but it stays at A9 in the cells D9:D31
Have you tried using the format painter?
Select D8, activate the format painter and drag down to D9:D31.
Hopes this helps...Formula to change text format to BLOCK CAPITALS
I have created a spreadsheet to record names of guests invited to an
event, with a yes/no drop down list [column B] to record their response
to the invitation.
I want to create a formula which will convert their name [columns D &
E] to BLOCK CAPITALS if I record a 'yes' response. I don't know how to
make this happen, beyond knowing I have to write some kind of formula.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
I have text direct from a US system in a report, the text is a US date eg
01/30/2004. I would like to complete an aging report and need to find an
easy way to convert text 01/30/2004 to 30/01/2004 to allow excel to recognise
this as a date.
I have around 400 lines of data to convert so dont want to have to do this
can anyone help??
Highlight the column
Click on <Format><Cells><Custom> and in 'Type' enter dd/mm/yyyy and click on
"Suzanne Bond" <SuzanneBond@dis...Document map without ToC
Is there any way I can get the Document Map to show without listing the ToC
entries? It's pretty annoying seeing the same headings twice and 50% of the
time inadvertantly clicking on the ToC entry not the paragraph heading itself.
TOC styles have body text paragraph outline levels and so should not be
caught by the document map. But the document map sometimes changes paragraph
outline levels based on the formatting used. Modifying the TOC styles
should get rid of TOC entries in the map.
>Is there any way I can get the Document Map ...Formating Large (200+GB) FAT32 Volumes Appears to Generate Errors
There are several Knowledge Base articles concerning FAT32 on Windows XP,
particularly 314463 and 310525.
The Disk Manager will not format a partition as FAT32. Using the HELP text,
the appropriate FORMAT command would appear to be:
This gives the following error message:
"This volume is too big for FAT32."
Changing the cluster size to 128K (/A:128K), gives the following error
" The specified cluster size is too big for FAT."
Is this a known problem? The KB articles imply that the F...Conditional Formating #3
Is there any way to conditionally format more than three
conditions in Excel 2002 on XP? I'd like to color code
cells by year quarter and need 4 colors. Thanks
You're lucky. 4 colors is the maximum if you use the default color.
For example, set the colors for Q1-Q3 with CF 1-3, then set the cell color the
normal way (Format toolbar) for Q4.
"Ron" <firstname.lastname@example.org> skrev i meddelandet
> Is there any way to conditionally format more than three
> conditions in Excel 2002 on XP? I'd...Chart will put 0 data points on graphs for non-zero cells
I am attempting to make a chart with data from column A1-A7 using a
scatter chart. The corresponding Y values in B1-B7 don't always have
data in some cells. For example, if cells B1 & B2 are coded with if
The "blank" that is returned is forced to zero on the chart. If I have
the conditional statement FALSE out, or TEXT out, the chart still forces
the data point to zero.
rollinn95z's Prof...conditional formatting across a row, based on value in a single ce
How can i format a whole row ( change the colour, font, fill) by using the
value in a single row to conditionally format it
In CF, change condition1 to Formula Is and use a formula like
or whatever the formula is, just make sure that you absolute the column.
(remove nothere from the email address if mailing direct)
"oaode" <email@example.com> wrote in message
> How can i format a whole row ( change the colour, font, fill) by using the
> value in a single row to conditionally...too many different cell formats in excel
Can't insert row on excel due to above error. How do I
fix it? Any ideals? The version is 2002.
Check out this jassy
XL: Error Message: Too Many Different Cell Formats
David McRitchie posted this
Leo Heuser posted a macro 2001-05-06 in programming as a very major revision of the macro in the eee007 article.
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
"jassy" <firstname.lastname@example.org> wrot...GP2Bank Formats
Hi, we are using GP2Bank to create eft files for payment.
We have noticed WBC NZ ( westpac New Zealand) has been rejecting the files
created from GP (we create .txt. files not .aba) and it's still having prob's.
Anyone else experienced this before?
Great Plains Administrator - Australia.
Hi you wanting to generate the file for Australian or New Zealand westpac?
If for Australian bank, you need to choose the WBC Auz format.
"steeko" <email@example.com> wrote in message
> Hi, we are using GP2B...