Creating a Combination Bar Chart with 2 Lines
I am trying to create a bar chart with 2 line series. The Y-axis for the
vertical bars would be on the left and the Y-axis for the 2 line series would
be on the right (3 series were defined). The horizontal axis for all series
are calendar months (Jan, Feb, etc.) Every time I setup the chart my chart
only displays a single line, ignoring the other line series. The vertical
bars come out fine.
Any thoughts on what I am doing wrong?
Don't use the built in types. Make the chart using all columns. Select a
series that you want to change (click on it right in th...Hidden data when pasting from html page into Excel?
I have a situation where I copy a report, which is generated as an html page,
into Excel for analysis. When a new copy/version of the report is available,
I copy and paste the new data over top of the old in Excel.
I've noticed that the size of my Excel file is growing after each copy/paste
situation. To manage this, I can delete the worksheet where I paste the data
and reconstruct it. After doing nothing else, saving the workbook results in
an immediate reduction of file size. If I simply select everything on the
sheet and delete, the file size does NOT go down; I have to delet...Algorithm to combine identical items in a list
I have a rather large worksheet that contains a list of all items in a
warehouse inventory. I would like to be able to combine duplicate
items as new inventory is added.
Each item has (among other fields) an item ID, a color and a
condition. I would like to combine only the lines where all of these
fields are identical, summing the quantities in each record, and
recalculating the cost based on the cost field in each record.
Currently, I do this by starting at the top of the list and comparing
each record to all of the records below it to the end of the list.
This is rather time-cons...Outlook 2002 and Retrieving Data Error Message
OS is Windows XP SP1
Email - Outlook 2002 SP3
Error Message: Outlook is retrieving data from the Microsoft Exchange
Server <server name>. You can cancel the request or minimize this
message to the Windows taskbar until Outlook closes the message
Other Related Issues: At times, the message displays the correct
server name and sometime it does not. At times, it displays the name
of an active directory server. This only happens to workstations
located in an remote office connecting to the exchange server via
ADSL\VPN connection. We have one exchange 2003 server - public...URGENT!!! Problem with row data being truncated in a copy worksheet sub #2
Dave, Thanks for responding. I tried this but I could not get it t
work in conjunction with the entire module. It dies right afte
copying and PasteSpecial Values It does not kill the temp file or loa
the newly created sheet into an e-mail. Any Ideas
DoctorV's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=514
View this thread: http://www.excelforum.com/showthread.php?threadid=26863
You may want to post your current procedure.
> Dave, Thanks for respon...Search Multiple Worksheets #2
Is there a way to search trough multiple worksheets for a specific value?
Other posts have mentioned to use VBA, but I have never used that before. If
anyone can give me some advice on using that or a type of formula to perform
that can search multiple worksheets.
There may be other ways but, while holding down the ctrl key select each of
the worksheet tabs you want to search in then select Edit|Find from the
menu. Type in the value you want and it will go to the first instance of
that value. Now if you are wanting to preserve a specifice value for
reference or ???, then...Add the same field twice to a pivot table but filter one of them?
In my datasheet, I have a "cost" column and a "date" column so each
cost has an associated date. In my pivot table, I've added the "cost"
as a field, which shows the total and this is fine. However, I'd like
to add the "cost" as a field again and this time selecting which dates
to include in the cost number so that I have two cost fields side by
side. Is something like this possible?
That is not possible in the same PT.
You will need to set up a second PT based upon the same data set as the
first but do NOT use the same Pivot Cache to save ...map data (x-y axis) with diffent series name
I have a set of x-y coordinate data set and i would like to plot them showing
the respective series name. Is there an automatic way of doing this without
haing to plot the data points separately. eg
Name x y
A 1 6
B 2 3
C 3 4
D 4 2
E 5 5
.. . .
.. . .
.. . .
I will like to have a plot of x and y with A, B, C as series name without
having to plot the points one after the other.
Here are a couple of free addins that allow you to link data labels to
Rob Bovey's Char...Match formula to match values in multiple columns
Hi all, does any friend know that how can I make below formula work
I am not sure I have understood correectly. Please go through the below example
With data as below if you need to retrive the name of the 1st Rank holder
D2 = 1
D3 = London
In D4 apply the below formula
Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar'...Noob Question For Selecting Multiple Fields On A Form
In versions earlier than 2007 I would be able to go to the Menu Bar and
click Edit -> Select All to select all fields on the form.
Now, my question is... where in 2007 did the put that functionality? If
Microsoft removed it from there... where did they recreate it?
"SQLSQUIRREL" <SQLSQUIRREL@discussions.microsoft.com> wrote in message
> In versions earlier than 2007 I would be able to go to the Menu Bar and
> click Edit -> Select All to se...opening excel worksheet
Operating System: Mac OS X 10.6 (Snow Leopard)
whenever I try to open an existing excel worksheet it opens very short. I have to drag it down to the bottom of the screen, is there a setting that i need to adjust?
No, simply SAVE the workbook after you adjust it.
Next time, it will open at the size you want.
On 27/03/10 6:42 AM, in article 59bb6065.-1@webcrossing.JaKIaxP2ac0,
"firstname.lastname@example.org" <email@example.com> wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
> wh...Multiple AND OR functions
Is it possible to make this function work?
I need to find out if Cell B9 = Z and if Cell AE9 = 35, if this true then
check cell J9 and check if it equals 1, M or C then return the value as 1000.
(that bit works OK)
I also want it to check if an alternative statement is true if the first is
false whereby it checks the the same set of cells but this time, check if B9
=A+, if Cell AE9 = 35, if this true then...Moving a row from one sheet to another wrongly leaves blank-row artifact.
Moving an entire row within a sheet in Excel XP is implemented
Select the entire row, cut it, go to the target location, and Insert
Copied Cells. The target row is inserted (pushing all rows below it
down), and the source row is deleted (bringing all rows below it up, as
NOT so when the target is in another sheet in the same workbook.
Excel inserts the target row correctly, but fails to delete the source
row. The row still exists (only it's blanked out). You have to remeber
to, tediously, return to the source and delete the blank row. Which
means that if you intende...Offline Address Book, Multiple Administrative Groups
We recently deployed an additional Exchange server in our organization and
placed it into its own administrative group, now users on the new server are
getting 8004010F errors in Outlook when attempting to download the offline
addresss book. The users who are on the original server do not receive these
errrors when downloading the address book.
If anyone can provide some assitance it would be greatly appreciated.
It's look like this
"jballin" <firstname.lastname@example.org> wrote in message...Multiple copies of E-Mail messages
I am using Outlook 2002 (10.4219.4219) SP2 with a Windows XP Professional
Just in the last couple days I've started to experience a problem with
incoming e-mail messages. I use Outlook to retrieve e-mail from at least
four different accounts, from at least two different servers.
When I receive a new e-mail message that is addressed to one of these e-mail
accounts, I get two extra copies of that message, and each of these extra
copies are addressed to two of my other accounts. So what I end up with is
three copies with three different TO: addresses. This only happens ...Outlook is trying to retrieve data from the Microsoft Exchange Ser
I keep getting a msg saying "Outlook is trying to retrieve data from the
Microsoft Exchange" everytime i try and send a mail... the mail then gets
stuck in my outbox. I still receive all email and this only happends over
one particular broadband connection??? If i use dial up it works and if i go
to some other broadband connection it works... any ideas?
> I keep getting a msg saying "Outlook is trying to retrieve data from
> the Microsoft Exchange" everytime i try and send a mail... the mail
> then gets stuck in my outbox. I s...Macro to generate 120 Graphs and put them into ONE sheet
The attached files has 120+ items that need to graphed against the date
I have tried to write a script that would automatically graph but ca
1) Get the For loop to generate multiple graphs
2) figure out how to arrange the grpahs in ONE sheet neatly
Any help is greatly appreciated.
Thank you !!!
Message posted from http://www.ExcelForum.com
sorry - here is the fil
Attachment filename: tester.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=66758
Message posted from http://www.ExcelForum.com
If you don't n...how do i switch to a right to left worksheet
Do you mean this ?
Regards Ron de Bruin
"li" <email@example.com> wrote in message news:C02DC0F7-14E2-4424-8A62-8191E853C48B@microsoft.com...
under Excel Options
"li" <firstname.lastname@example.org> wrote in message
...Saving data #2
I need to save data (results) from a base spread sheet program that i use on
a weekly basis. i am in the middle of building this program, and have just
discovered macros, but this, along with links is about my current knowledge
how can i automate to accumulate data from the base spread sheet (program)
when i clear all data from the program to produce fresh results the following
week, and to keep past data up to date and available for further use.
Any help would be appreciated.
With a combination of formulas and dynamic named ranges, it is possible to
just add the ...Parse multiple text lines into 1 line in excel
help. I am an excel beginner and can't find out how to turn multipl
lines of text into 1 row in excel. It's probably really easy but m
manual is USELESS. Can anyone help
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
You're a little short on details. If nothing below fits the bill post back.
"Multiple lines" is how many and is each line in a separate cell down one
Do you want all lines to go into one cell?
You can use this form...Automating transfer of data in cells
I have a time management spreadsheet with data stored
against work type and date. I need to transfer this data
into a similar but more comprehensive spreadsheet and
wonder whether it is possible to automate this task by
using the work types and dates in a macro (I have almost
10 months of data to transfer), along the lines of check
date, check worktype, where argument is true enter data
from cell. I think I need to use visual basic, but I
can't find out how in the help screens.
Any advice is much appreciated.
This is not difficult providing you keep your data in simple tables...Multiple SMTP Address
If a user is set up to have multiple SMTP address setup in active directory.
When they send an email in outlook how can they chose which one it is from.
You can only do this, in the setup you describe, by using a 3rd party app
such as ChooseFrom from www.ivasoft.biz
> If a user is set up to have multiple SMTP address setup in active directory.
> When they send an email in outlook how can they chose which one it is from.
On Tue, 31 May 2005 06:41:03 -0700, "Shane"
>If a user is s...Printing a worksheet in two (or more) columns
I've got an extremely long spreadsheet table comprising two columns of data.
I'd like to print these data in a more compact form - in the same way that
the entries are organised in a telephone directory.
Say on average my page is 50 rows high - my first two columns on page 1
would appear on the left hand side and be rows 1 through 50, row 51 would
continue at the top of the page, but on the right-hand side. Row 101 would
appear at the top left hand side of page 2, etc.
I'd like to keep the orientation of the columns in portrait (I did find a
printer-associ...Get Access Data into Excel
I am using excel macro to get data from access database.
My sql query gives me 5 records or more than that.
I am able to pull it different cells.
But I want all the 5 results in single cell.
im not exactly sure what your trying to do, but maybe something like this
will do the trick
dim accval as string
accval=accval & " " & rs!:xxx
loop it till rs.eof=true
> Hi All,
> I am using excel macro to get data from access database.
I have a CSV data file wot looks something like this -
This data i...