How to select series in chart?
I know I asked this question before, but (sigh) I cannot find the
answer now, when I need it of course.
How can I select a series in an Excel chart (XY Scatter) using the
keyboard, not the mouse?
The issue is: I have overlapping series, so it is difficult for me to
select a series by moving the mouse cursor to a point in one series and
right-clicking it, as I normally do.
Someone once mentioned a ctrl and/or shift key combination (I think)
that would allow me to select each series explicit in round-robin
fashion. That is what I am looking for again.
More generally, how could I have found...double clicking and draging a column in a chart to chg data
in Excel 2003, double clicking on a column in a chart and then dragging the
column up or down would change the data in a table upon which the chart
How does one do this in excel 2007?
That feature has been removed in 2007, there is no way to do it.
If this helps, click the Yes button.
"Tom of inns" wrote:
> in Excel 2003, double clicking on a column in a chart and then dragging the
> column up or down would change the data in a table upon which the chart
> How does one do this in excel 2007?
&g...Linking a Chart with graphics to ppt
when I create a chart with scatters, which carry graphics like
and link this to Powerpoint, the graphics are shown there in a very low
quality with large pixels.
Any ideas how to improve this?
Thanks in advance,
...chart MAcro to change on activecell
Here is the macro below.. The only problem is that the columns change every
month. so range (columns)keeps widening.... I have sorted it by selecting
range upto column N. so it is provided for all 12 months.
But now the "Grand total" column which is always the last column also gets
included..(.which shouldnt be included in the range for the chart)
Is there a way to modify this macro ?
Dim ThechartObj As ChartObject
Dim Thechart As Chart
Dim Userrow As Long
Dim CatTitles As Range
Dim SrcRange As Range
Dim SourceData As Range
If Sheets("summary").Ch...Multiple stacked bar charts
I have a project where i have to chart the compliance of three groups over a
number of months. So for each data set there is a Compliance#1 stacked upon
NonCompliance#1, then Compliance#2 stacked upon NonCompliance#2 and finally,
you guessed it, Compliance#3 stacked upon NonCompliance#3.
When i design a chart in excel it wants to place everything on top of each
other producing one column of six not the required three columns of two for
each week in the display. Can anyone point me i the right direction for
you can achieve this effect by having two layers in your x axis
the at...transparent areas in charts?
How do you create transparent areas in imbedded charts? (for Excel 2003).
When I click on "Format Chart area", then "Fill effects", there is a place
where you can change the transparency settings, but it is faded out and will
not work. Any Ideas?
You can make most elements totally transparent. Ignore the transparency
button, which is only for decoration. Instead, if you set an element's area
to none, the element will be transparent.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech....printing 2 charts on single page
Using Excel 2k, Win 2k
I was trying to print to line charts on a single page to demonstrate the
corelation between the two data sets.
I would like to print in portait mode with one chart on top of page and one
on bottom. Excel only seems to offer putting chart 2 on a separate page or
embedding it in chart one.
I am not very familiar with excel charting capabilites can anyone suggest a
...Using mouse wheel in VB editor
Just tried using the mouse wheel to scroll within visual basic editor in
excel but it wont let me. How can I turn this feature on. I am using Excel
Thanks in advance.
This is a known problem with the latest MS mouse drivers. You
can either install version 4 of the drivers (current version is
5), or use FreeWheel, and freeware program at
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"fullers" <firstname.lastname@example.org> wrote in message
ne...Send to certain person using specific email account
I send an email to a certain receipient but don't want to use the
default email account.
Is it possible that when I send to them (plain text) , that it will
choose the other account I want to use to send it? Please advise how I
set this up.
I do not believe that this can be achieved automatically through standard
use of Outlook as you need to manually specify the name of the account to
send from if different than the default.
However, it would be possible using the Outlook object model. An Addin would
need to be developed that monitored each mail item prior to sending. If the
d...Use exchange from a trusted domain
I have domain a and domain b. Domain a is all set upp with exchange etc.
Domain b was bought, and they don't have exchange. I have trust between the
domains and file sharing and authentication are ok.
What we want to do is, make users on domain b and let them use the exchange
(on a seperate storage) on domain a.
The users on domain b must logon to domain b, but need to have mailbox on
Domain a are running on win2003 and exchange 2003. Domain are running on
win2003 with forest and domain ready for exchange.
thanks in advance,
Outlook is behaving strangly with the "through the selected account"
Each time I restart Outlook the rule fails. When I go in to check on the
rules I get told that the rule is "invalid". and the "SELECTED" account
is no longer selected.
Each time the criteria the account needs to be selected by changes.
For example with the following data
Account Name Email Account
One time I go in and it's asking me to select the account ...Single click selects multiple cells
When clicking on a single cell multiple cells are selected. The one time
solution for this is to zoom in or out. This is problematic as 60% seems to
be the zoom that works most of the time but at this zoom level the cell
contents do not display. The time lost and the frustration that builds is
killing my productivity and office attitude. Please give all of us a permanet
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" butt...Renaming Partial File Names
Is it possible to rename part of a file name? (almost like a find and
replace) My database pulls in the excel file names from a directory, with
it's subfolders and contents as well. Every file begins with "Kay Form".
Kay no longer works in our department, and I'd like to run a loop that
replaces "Kay Form" with "Featured Track". I don't know how to do a partial
Thank you in advance!
Message posted via AccessMonster.com
Checkout the Replace function. I...Using Access 2003 on client to see Sharepoint 2007
Testing a Sharepoint environment and I can easily manipulate and run the
database from Access 2007, but when I try to use Access 2003 it wants me to
save the database to a location. The Access 2003 has the compatiblity pack,
but it seems to not work when I download it.
So the question is using Sharepoint 2007 and posting the Access 2007 format
to it, can a user go to the sharepoint site and use a 2003 Access database
that has the compatibility pack and open without having to download it?
Message posted via http://www.accessmonster.com
Send check for $500.00 to: David A Jenn...Shortcut for inserting names?
I am building many formulas, each with many named cells as part of it.
Currently I have to go to Insert | Name | Paste with the mouse each time I
want to insert a name. I looked in Walkenbach's Excel Bible but couldn't
find any mention of a keyboard shortcut or other shortcut. Is there one I
could take advantage of?
I've got Excel 2002.
...Getting rid of selection
How can I get rid of the selection rectangle? It seems that it's always
there, with a heavy black rectangle, or there's a light black rectangle
marking where it was.
I'm trying to get rid of it altogether, so I can capture an image of the
sheet for use in a webpage.
I can achieve the effect that I want by selecting a cell which is
outside the area that I'm trying to capture, but now that I've found
that I cannot get rid of it entirely, it is driving me nuts trying to do so.
You could al...How Use ShellExecute with a CMemFile
I need to store files of various types (such as .doc, .xls, .jpg, .pdf,
..wmv, ...) in a database. Upon retrieval of such a file I have the file as
data in memory in a CMemFile. I need to then "display" the file in the
aproriate application. If I were to write the CMemFile to disk and create
an actual file I could then, of course, use ShellExecute() to launch , say
Word to display a .doc file.
However, I would much prefer to avoid the overhead of writing the data to an
actual file and then dealing with having to detect when the User is done and
cleaning up the file I had ...Can i use conditional formating on a cell when it contains a formula?
I am trying a "conditional formatting" on a cell that contains
formula, but it didn't work.
"If cell value is equal to 0 then font - white" This doesn't work,
If i use this condition on a cell without formula it works just fine.
sit's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=262
View this thread: http://www.excelforum.com/showthread.php?threadid=26784
are you sure your formula returns an exact zero?. Could you post the
formul...Indirect Method for Name Box Variable? #2
The reason I want to do this is that I have to collect data on a dail
basis but I have to display it on a graph on a weekly basis.
I select the entire week of cells and give it a name like week52.
The following week I have to select the entire week and name i
Everything is set up that I can just copy and the numbers will progres
for whatever length of time I need to graph (months, years, etc) excep
Maybe I'll just go back to using the range of cell numbers.
Chris Bre...Using INDIRECT within functions
I learned a bit from JLathman in a previous post but tried to use the same
methodology with this formula (also learned from this Group to get the last
entered value in a column) without much luck.
The original formula was this with 2009 sheet being static:
Trying to make it dynamic I tried the following without success:
=LOOKUP(INDIRECT("2,1/(" & O1 & "!$H$3:$H$65536<>"")," & O1 &
Did I miss something or are...Selecting the Right Text Alignment for a edit box doesn't work
When I select right text alignment in the edit control properties, the text is still left aligned when I run the program. What am I doing wrong
"Dan" <email@example.com> a �crit dans le message de
> When I select right text alignment in the edit control properties, the
text is still left aligned when I run the program. What am I doing wrong?
I've no idea :-))) You can open your RC-file as text, and make sure it has
the ES_RIGHT style set, thus:
Hi, i need an macro to select all filled cells in range C10:K90.
Can this be done?
xlNumbers + xlTextValues).Select
If you want to select xlErrors and xlLogical add those to xlNumbers +
Jacob (MVP - Excel)
> Hi, i need an macro to select all filled cells in range C10:K90.
> Can this be done?
"Jacob Skaria" a scris:
> Range("C10:K90").SpecialCells(xlCellTypeConstants, _
>...How to use count for calls per hour
I am trying to create a pivot table and chart that will show me the # of
calls per hour by day for a range of dates Aug 1 - Sept 19. My data looks
like this where each line is the date and time of the call:
How do I get a count of the # of the calls per hour by day?
8/1/08 12:48 AM
8/1/08 1:53 AM
8/1/08 2:36 AM
8/1/08 3:24 AM
8/1/08 3:37 AM
8/1/08 4:04 AM
8/1/08 4:44 AM
8/1/08 4:55 AM
8/1/08 4:58 AM
8/1/08 7:02 AM
8/1/08 7:28 AM
8/1/08 7:43 AM
8/1/08 7:47 AM
8/1/08 7:56 AM
8/1/08 7:58 AM
8/1/08 8:13 AM
8/1/08 8:33 AM
8/1/08 9:07 AM
8/1/08 10:28 AM
8/1/08 10:38 AM
8/1/08 10:44 AM
8/1/08 ...copy chart from Excel to Powerpoint
I am trying to copy a chart from Excel to Powerpoint, but the button is
grayed out and it won't let me copy it.
You can convert the chart to a GIF (a picture) with my Excel Objects converter.
> I am trying to copy a chart from Excel to Powerpoint, but the button is
> grayed out and it won't let me copy it.
...Help! charts disappearing, new charts crashing powerpoint
When i open a presentation the charts vanish...i have restarted, they come
back. I try to edit a chart, and it crashes powerpoint after a few clicks.
What can I do...whole afternoon going crazy!
If you are using v 2007 there is a hotfix which is meant to cure some chart
john ATSIGN PPTAlchemy.co.uk
Free PPT Hints, Tips and Tutorials
> When i open a pres...