Secondary Axis Data Series "Clumping"
I have a chart that has 3 data series. 2 are related to percentages and are
tied to the primary axis. The third series is a whole number, and tied to
the secondard axis. it has always displayed properly.
For some reason the data tied to the secondary axis is "clumping". That is,
all 17 data points are displaying before the second category tick. The
first 2 series' data is displaying just fine.
What have i done wrong?
What are the chart types of the three series?
Peltier Technical Services, Inc.
> ...How can you add the same data series to all charts in a workbook
I have numerous charts on separate worksheets in one workbook and would like
to add the same data series to all the charts. I have tried highlighting all
the worksheets and adding the series to no avail.
I'd save your workbook, just in case this doesn't work as I think it should.
You can select the series in the chart that includes the series and copy the
formula for the series. It looks something like
Paste that in each chart you want to add it to.
"MBubier" <MBubier@discussions.microsoft.com> wrote in message
news:AF363BA3-47A2-4364-89D8-02A60...Inserting (and extracting) pictures into word
1-I used ctrl-PrtScreen to copy a graphic on my screen.
2-Then I opened a word doc and hit Ctrl-V to insert the graphic into the
Here is my Q: How can I retrieve the graphic from my word document and turn
it into a JPG or other graphic file?
Why I want to do this: I want to create a collage with the graphics.
To do so, I need to extract the graphics from the word document and
transform them into individual, discrete graphic files that I can manipulate.
Can I do this?
If so, how.
I thank members of the community in advance for any help you can provide.
David R...How do I prevent tekstoverlap in inserted graphics?
I have no clue what tekstoverlap is. Do you mean text overlap? Are you asking
Mary Sauer MSFT MVP
"SD" <SD@discussions.microsoft.com> wrote in message
...problems printing multiple copies on one page, only prints 1
Hi there I am trying to print four copies on one piece of A4 paper, the
system and printer resizes the document and prints it in the top left hand
corner, but no other appear on the same page
Verify your work area is � or less the size of your paper stock.
When you go to print select
"Print multiple copies per sheet."
"Gary" <Gary@discussions.microsoft.com> wrote in message
> Hi there I am trying to print four copies on one piece of A4 pap...MVC2: linking from one area view to another area view
I am working on an MVC 2 app. I have 7 different areas in it which has a
view that should be accessible from the home page (or anywhere else really).
The links most likely will go in a sitemap and get put on the apps master
page. Either way, How would I say link to Headlines/home/ from the apps
...filtration of worksheets tallying 2 million seperate phone numbers
Hi, I am a loan officer at a mortgage brokerage. We have
recently put the new nationwide no-call list on an excel spreadsheet.
have 2 questions for you. First: is there a way to make excel have
rows than 65,536 (preferably like 2 million) as the colorado part of
national no-call list is about 2 million. And second;can you tell me
filter one workshet against a second with 30 columns and 65,536
filter feature I use only takes into consideration the left-most
~~ Message posted from http://www.ExcelTip.com...adding multiple contacts at one time from a received email
Is there a way to add multiple contacts from the header of an email
sent to me as part of a distribution group? I know I can right-click on
them one-at-a-time and do "Add to contacts..." but that's a nuisance
for 50+ addresses. Is there a way to do this in bulk?
for a reply.
I don't think so.
Outlook trainer and author of Productiv_IT with Outlook
<firstname.lastname@example.org> wrote in message
> Is there a way to add multiple contacts from t...Can multiple versions of Money coexist on a PC?
I'm running Money 2004 but have a copy of M 2005 someone
gave me. WIth all I've read here I don't want to replace M 2004
with M 2005. I'd like to run them in parallel until I see if I
prefer the newer version, based on all I've read here.
Is it possible to install M 2005 on a machine with M 2004 and
have them run separately?
Yes you can. You should install 2005 in a different directory to 2004.
Downloads direct from your bank will go to the newer version by default.
When you run Money, you need to make sure you open the correct file with the
correct version - ie do...Multiple Google Calendars and Outlook
I run an app called Google Calendar Sync on my PC. It sync Outlook 2010's
calendar with that of the Google one.
I've since created a second calendar in Google to try and separate work events
from social ones.
However, Outlook 2010 and this sync program can't see the second or subsequent
I was hoping that someone here has a way or has seen a way to get Outlook to
sync with multiple Google calendars.
I can do it for you.
Please reply if you want it.
> I run an app called Google Calendar Sync on my PC. It sync Outlook 2010...date data type is not a date??
Following is code I am running. I intend to compare two dates. One date
(orderrg.value) is from a spreadsheet and is defined as a type date. The
other date is the system date. However when I check to see if the
orderrg.value is a date via ISDATE, it fails. Following the code is the
prinout from the immediate window. It looks to me like it should be able to
recognize it as a date, but yet it doesn't. Does anyone have any ideas?
Private Sub Workbook_Open()
Dim wscommission As Worksheet
Dim nindex As Integer
Dim lastorder As Integer
Dim sheetname As String
Dim orde...One exchange user, cant send email to another particlular user
I have a problem its is only a 1 way problem, user a
cannot send mail to user b, user b can send mail to user a.
both users are on the same exchange 5.5 server.
This means that user b is not recognized as a valid recipient.
Check the properties of user b in the Admin Program and make sure you have
an e-mail address stamped there.
"Please do not send email directly to this alias. This alias is for
newsgroup purposes only."
"This posting is provided "AS IS" with no warranties, and confers no
"Nema J" <ne...SUMIF/COUNTIF with missing data
Right now, I'm using the following function to get the average of column B,
given that column A has a certain criteria:
Which works fine, except that for some of the entries whose A column says
"blue" there is no data in the B column, so the denominator is off. How can I
account for missing data in this function?
Thanks in advance.
OR try the below...Consolidating Sheets into 1 new one.
I have a workbook with 52 worksheets, each following the same format.
(The sheet lists salespeople by name in collumn A, and statistics for
each person across the next columns B - F.)
I want to bring all the data for each of the weekly sheets and
consolidate it into the same format on a summary sheet.
Here's the problem: I have to deal with employee turnover.
The first weekly sheet might have in column A starting with A1 Steve,
Tom, Mike, and Joe in A4.
The second weekly sheet might have (starting in A1) Steve, Tom, Joe,
Jim, and Mary in A5.
Week 3 might just have Joe, Jim, and Mary....Chart data labels are not correct or not displayed
I have some charts that I've been using for a long time and I notice that
sometimes the data labels do show correctly or not at all. Can someone help?
Can you give us a few more details.
What type of chart (line, XY, column) ???
How is your source data setup?
What do you expect to see for labels, what are you actually getting?
With a little more information, I'm sure we can help.
"Bolton User" <Bolton User@discussions.microsoft.com> wrote in message
>I have so...X, Plus, and Star marker styles do not show all data points
In a scatter chart, the X, Plus, and Star styles simply mark the right end
of each string of data; data points to the left of that position don't show,
unless I use a background color different from the Chart's background.
The square, diamond, triangle, and circle styles show all the data.
Is there a property of these 3 problem styles I should set to make them
display like the 4 that work?
Thanks for any help.
I've never noticed a problem like that. You're saying the markers only
mark the last point in a series? Are these charts you're doing your...moving worksheets between workbooks
I have three workbooks that I'd like to consolidate into one workbook
with 3 sheets. Workbook #1 contains linked cell references in
workbooks #2 and #3. How can I move the worksheets from workbooks #2
and #3 into workbook #1 while maintaining the integrity of the linked
I don't now how this will affect the links, but you can move worksheets this
-Open all the workbooks invovled
-Right click on the tab of the sheet you want to move and choose move or
copy from the popup menu
-In the new dialog click on the dropdown to select the workbook...When I select to insert a page break, it is not inserting.
I have a spreadsheet that is set up to print to fit on one page. However,
when I try to insert a page break to split up that page, horizontally or
vertically, it is NOT inserting. However, if I set up to print at 100% its
size, it's 16 pages long, page breaks will appear, but I don't want to break
up 16 pages. Help!
Next time you're in file|page setup|page tab, set it to print 1 page wide by 1
Ok your way out of the dialog.
Then go right back into that file|page setup|Page tab.
Note the "adjust to" percentage.
It's probably less than 100%.
Sele...Transforming a worksheet's functionality?
Hello Everybody. How is your Friday?
Okay, is it possible, using a recordable Macro or VBA, to change a
For instance, I have a workbook with one Formatted Data Entry sheet and one
No-Format Archive sheet that stores all the raw data (no formulas) for future
retrieve. Is it possible to change the Data Entry sheet from user input mode
to archive retrieval mode?
In data entry mode, Column D and G are blank to allow for user input. In
archive mode, Column D and G would need formulas which grabbed data from the
corresponding cells on the archive sheet.
...selecting chart data range using arrow keys
In the past I have been able to select the data range (ie source data) for a
chart by (a) clicking on the little square button at the far right end of the
source range, which brings me to the spreadsheet; and (b) then using arrow
keys to move around and SHIFT select data.
OK, I can still do this. But the rub is this: I used to be able to
CTRL-arrow around to select ranges, which is very handy in big spreadsheets,
since it can bring you to the next full cell (like using the Scout (#9) in
But now I can't CTRL-arrow around anymore to select chart data, leaving me...How do put a group of addressee's into one batch to all receive e-
I have a committee and want to inform all of an upcoming meeting. How do I
put all the committee members into an address where I click one time and have
all of them receive the e-mail?
make a Distribution List of them in your Contacts.
> I have a committee and want to inform all of an upcoming meeting. How do I
> put all the committee members into an address where I click one time and have
> all of them receive the e-mail?
"jkundert" <email@example.com> wrote in message
news:67F9568C-65C2-4543-8892-4C0A3E35947D...I can't recieve new mail from one contact
I can't recieve new mail from one specific contact. I can recieve replys
from him but any new messages that he sends do not go through. We have
redone the address in the address book but this dod not help. Any thoughts?
"Paul" <Paul@discussions.microsoft.com> wrote in message
> I can't recieve new mail from one specific contact. I can recieve replys
> from him but any new messages that he sends do not go through. We have
> redone the address in the address book but this dod not help. ...Converting Worksheet to all 'Upper'
I know how to change lower case columns to upper case with th
=upper(cell) function. Then once the new 'upper' column is complete
copy, then paste back as 'values' and then delete the old 'lower
Gosh, I have over a dozen columns to convert in each worksheet. Isn'
there a way to convert the whole worksheet to upper in one fell swoop?
While I'm here, I'd like to thank all those regulars here for the hel
they have contributed on a daily basis to all of us not s
You have saved many thousands of hours of frustration, and I, for one...Display Multiple images
#LEO CHIN SIM# wrote:
> Just want to check whether is it possible to display multiple images using SDI instead of
> If yes, any hint on how to begin?
It is possible to display anything using SDI. You can paint multiple
images on one view, or you can use splitter windows and display
somethin...Moving data to new exhange folders
Hi, I just changed my outlook email accout to use a
Microsoft exchange server. This created new folders
(inbox, calender, tasks, etc) in outlook that exist on the
server. The problem is that all my data is in the old
folders. How do I move the data (for instance all of my
calender entries) from the old folders to the new folders?
Go to old folder and change the view to by category. Press ctrl + a to
select all items in folder. Select Edit | Cut. Go to destination folder.
Change view to by category. Select Edit | Paste.
"Dave" <firstname.lastname@example.org> wrot...