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
...Access 2007 and Vista code problem
I am developing a database on a XP SP2 machine. On a form I have created
some buttons with event procedures that run 2 queries and open a form. I
sent the db to someone running Access 2007 on a Vista machine and nothing
happens when she clicks the buttons and there are no messages.
I know nothing about Vista so thanks in advance for any help.
Might be a reference problem, have them open the open a code window and
click tools references. See what says missing and tell them what should be
there, Add it and it should work. Duff
"Tim Reid" <TimReid@discussions.micr...Outlook 2007 Search always returns no matches
Any search I do in Outlook 2007's new search box returns no matches.
I watched the Indexing Status as it progressed, and now it says "Outlook has
finished indexing all of your items"
But, searching on anything, even the word "The" or "a" returns no results.
I'm searching all Outlook items. I'm on an Exchange Server via VPN.
Anyone have any suggestions?
I uninstalled Office and re-installed and the problem went away...
"Tom" <email@example.com> wrote in message
> Any search I do i...Publisher 2007 frequently crashes
I'm having some difficulty with Publisher 2007. Whenever I try to open a
particular file, the program crashes. I get no error message, except that
Publisher needs to close. I've run Office Diagnostics (twice), with no
results. I can open other Publisher files. The file that I am trying to open
is an internal website for the company I work for. This file began acting
strangely a couple of weeks ago - it wouldn't insert a duplicate page for a
while, but I found a workaround, so I didn't worry about it. However, now I
think that it may be a part of a larger probl...Add PowerPoint 2007 to Office Basic
I have Office Basic installed on my laptop and need to add PowerPoint. What
is the most recommended, easiest and least expensive way to do this?
...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...Fractions Number format
Is it possible to do a custom number format for cells such that fractions
are displayed. I'm guessing not because there'd be a limit on what fractions
you could display, but I would probably only be interested in showing a half
as the little 1/2 (alt,0189 I think) rather than .5
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.478 / Virus Database: 275 - Release Date: 06/05/03
There are a limited number of fractions that can be shown under
Gord Dibben Excel MVP - XL97 SR2 & ...Outlook 2007 Calendar -> Outlook 2003
In the past I could forward appointments and birthdays from one PC to
another, if both PC's had Office 2003. I just tried forwarding a birthday
from Outlook 2007 to Outlook 2003 and it doesn't work. I get the email in
2003. Open it, open the calendar item, then click on Save & Close. No
error message. But it's not there. Neither in the current month or for
next year. I forwarded it as a reoccurring item, that's the only way it
will let you do that.
Has anyone else been able to do this?
Or, is this a backward compatibility issue?
It's odd.... this works fine for...Some Excel formatting functions taking a long time to work #2
Excel 2000 SP3
When I use some formatting functions for the first time in a
session, such as bold, increasing font size etc, it takes up to 30
seconds to work. Meantime Excel is locked up until it completes that
formatting call. I suspect faulty DLL?
Has anyone experienced this? How to fix (other than a complete re-
Any advice appreciated.
On Nov 5, 8:39=A0am, Piri <wiremu.pare...@hotmail.com> wrote:
> Excel 2000 SP3
> When I use some formatting functions for the first time in a
> session, such as bold, increasing font size etc, it takes =A0up to 30
> secon...compact database in VBA access 2007
I have recently upgrade to office 2007 from office 2003. To compact a
database from within the database itself, I used the follwing code.
Unfortunately it no longer works in access 2007. Is there some similar code
that will work?
Public Function FncCompactTheCurrentDB()
CommandBars("Menu Bar"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
On Thu, 28 Jan 2010 17:34:01 -0800, SL <SL@discussions.microsoft....How to save Japanese characters in CSV format of Excel ?
I would like to know, how to save the Doubly-Byte characters.For example,
Japanese in CSV of Excel.Here are the steps, I tried.
1. Open Excel
2. Copy pasted the Japanese charactesrs in a cell.It is displaying the
3. Save as CSV(Comma seperated file)
It is saving as ??????.
Thanks in advance for the info.
...Creating Text Box in Publisher 2007 Crashes the Application
Hello, we have a clean install of Publisher 2007 under Windows XP SP2, and
when we try to create a text box in a document, (both an existing document
and a blank document), publisher crashes. Office is fully patched.
I ran Office Diagnostics from the help menu and no problems were found and
the issue persists. Any thoughts on how to resolve the issue?
See if selecting a different printer as default helps.
How to view error signatures if an Office program experiences a serious error
Mary Sauer MSFT MVP
http://of...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...MS Access 2007 code not running
I have created a brand new database in Access 2007 and linked some VB
code to run on Form_Load. This code worked perfect with no problems
the day I created it. Now today I opened the same form and it is not
running the Form_Load code anymore (and yes it is still there, I did
not delete it). I got frustrated so I copied and pasted the code to
Form_Current and several On_Change events and set breakpoints at the
beginning of all the events just to see if it was the Form_Load that
was not triggering, but NO events are triggering my VB code. Any
See this page:
http://accessjunkie.com/fa...Date format 04-11-06
Is there a possibility that the dates used in all the entities are not in
the default format mm/dd/yyyy but in dd/mm/yyyy.
I already adapted the Organisatonal settings, that only adapts the journal
but nog the dates of an appointment.
Does anyone have an idea?
...MS Project 2007 question
I am developing a simple schedule with no resources but 2 tasks out of 100
are hazardous and I would like to make the schedule so that when these tasks
occur, no other tasks can occur. In other words, even though all tasks are
moving around as the schedule is being developed, I would like to make sure
no other tasks can be scheduled wherever these 2 hazardous tasks fall. These
2 tasks are serial to every other task in the schedule. Is there a way to do
Thanks for your help.
Create two milestones. Use milestone 1 as the successor task to all tasks
th...Office 2007 Templates & Themes
Is there anyway the content for Office 2007 at the MS Office web site
could be made available to Office:Mac users. Currently need to have OGA
validation via ActiveX control or from Office for Windows programs.
Surely Mac users could be given access!
We have asked that question. We don't have an answer yet (at least, it
wasn't "No", that would have been quick!).
They are trying to work out how to let us in without letting in all the
people using the competitor products.
I think they will set up a mirror on the MacTopia site that will allow us to
reach the ones tha...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...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.