Sorting in excel charts
I have a chart in excel 2007
I want to sort rows 1-5 decending
and rows 6-11 decending
but when I select just that much and click to sort
it re-hilights all of the data in the blue bounding chart selection
is there a way to only sort a few rows in an excel chart
I cannot reproduce the problem. When I select 5 cells out of 11 in a column
Excel 2007 does not automatically change the selection.
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu
...how do i add a quadratic trendline to excel
i need to add a trendline for a quadratic equation for my math project but it
seems to me that its not available is there a way that i can do it?
im using windows XP home edition
select a polynomial of order 2 then click on the Options tab and request
that Excel display the formula.
will give you the quadratic coefficients in a worksheet.
> i need to add a trendline for a quadratic equation for my math project but it
> seems to me that its not available is there a way that i can do it?
> im...reports in "cash flow" with (red) expense amounts
I can generate the rpt ok, but some of the categories come
out in red and parens, showing they are backed out. I
don't want them backed out! I have tried re-entering, but
that's no help. Probably some boxed is checked, but I
can't imagine what so can't find it. Help in product was
no help, and I've read my MONEY 2002 FOR DUMMIES to no
avail, too. Hoping someone here can help!
In the cash flow report, Income will be positive. Black no parens. Expenses
will be negative. (Red w/ parens.) Is this what you are seeing? This is
because Income is cash flow in--like the r...Excel VBA Macro
I want to check if this statement is correct in excel VBA:
Const DataPath = "U:\DATA\PROGRAM\"
Workbooks.Open Filename:=DataPath + "MOPS.XLS"
Please advise. Thanks
It appears correct.
Although personally I would use & instead of + when concatenating.
> I want to check if this statement is correct in excel VBA:
> Const DataPath = "U:\DATA\PROGRAM\"
> Workbooks.Open Filename:=DataPath + "MOPS.XLS"
> Please advise. Thanks
Andy...Excel password #3
I forgot the password for my excel file.
I have tried some programs such as
Accent Excel password recovery,
advance office password recovery.
Neither did work.
Well, your options are to either remember the password or find a recovery
program that works for you. No guarantees - if you picked a really good
password it will be tough to break it.
Ben M. Schorr, MVP
Roland Schorr & Tower
Author: The Lawyer's Guide to Microsoft Outlook 2007:
"Sang-Wook...Excel caused an invalid page fault in module EXCEL:EXE at 0137:300
obtain this error message when opening Excel.
However , if I link to the internet it will then open without a problem.
Can anyone advise how this can / should be rectifyed?
do you get this error in all cases?. If yes probably a re-install could
> obtain this error message when opening Excel.
> However , if I link to the internet it will then open without a
> problem. Can anyone advise how this can / should be rectifyed?
...Question on Excel 2002
I am attempting to use objects from the control toolbox (e.g. chec
boxes), but I do not appear to have the "format control" option when
right click on the object (an option available on the previous versio
of Excel). Does anyone know if this can be added or alternate way t
select this, or if such functionality now requires VBA code. Thank
for you help
caser's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1652
View this thread: http://www.excelforum.com/showthread.php?thr...excel wont open file #2
I am trying to open a excel file, but a message comes up saying th
file is corrupt ,is there anyway i can open i
Message posted from http://www.ExcelForum.com
...How do I change the size of Value Axis Title box for an Excel Cha.
The title box cannot be sized. I must reduce the font to very small to
prevent truncating the title.
I would have thought I could drag the box to the size I wanted but I do not
get the chance to do so.
Instead of a Title, you can use a Text Box:
Select the Chart
Type the text you want in the Title
Press the Enter key
A text box will appear in the centre of the chart
Drag it to the location you want it, and format/resize as desired.
If you prefer, you can link the text box to a worksheet cell, and
display its text:
Select the chart
Type an equal sign
Click on the cell you want to link
Pr...Date filter in AFA reports
It will be important to add a date filter on AFA reports. All customers have
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" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=d6bc6c96-14cd-4660-a7a...how to use excel to do random sampling
I have a data set of 30 numbers. I need to use excel to draw 50 random
samples of size 5 and then compute the mean for each sample. How do I do
if your sample is between a1:a30 and your sample between 0 & 1.
in B1 type =Rand(a1) and copy and paste the formula to B30. if your numbers
are larger than 1 then use =Rand(a1)*100. Rand() gives you random sample.
> I have a data set of 30 numbers. I need to use excel to draw 50 random
> samples of size 5 and then compute the mean for each sample. How do I do
With, or without, ...Deleted timesheet resists in Reporting DB
On the one hand I hope for all of you that you can’t answer my question since
you never ran into it. On the other hand I hope that anyone has an idea what
I could try:
I have the situation that a timesheet was created at some day. A few days
later this timesheet was deleted. We don’t know exactly when that was done,
but it could be during a timeframe when disk space was full.
The issue is now, that we have the old timesheet data in Reporting DB, but
no information for that timesheetUID in Published DB. When resource create a
new timesheet for that period, there is an error in...CListCtrl in report mode and column header
I would like to have a CListCtrl in report mode with columnheader but
I would like the column header to be transparent and without displaying
How can I do that ?
mosfet a �crit :
> I would like to have a CListCtrl in report mode with columnheader but
> I would like the column header to be transparent and without displaying
> How can I do that ?
Or same question : HOW CAN I CHANGE COLUMN HEADER COLOR ?
"mosfet" <firstname.lastname@example.org> wrote in message
> I wo...sql server report 2008 export options
I would like to know know what are the options of exporting in sql server
I would like to export a report with about 10 sub or linked reports to a
format that you can work with a table of contents. From looking on the web
site looks like my best option is to export to Word.
Are there other export options that would work like exporting to xml and
creating a table of contents?
If not, how would you accomplish this task using Word?
...Excel Files Won't Open From Shortcut
The title's misleading but I couldn't find a way to express it succinctly.
If I have 2 Excel windows open, with one or more workbooks within each
window, and I click on an Excel file-name in Windows Explorer or on a
shortcut to an Excel file-name, nothing happens. If I close both Excel
windows and try it, the file will open. Or if I go to Files, Open, and
Browse to the file name it will open. This is both new and a pain in the
rear. As recently as 3 months ago I could open six or eight Excel files at
the blink of an eye, from Windows Explorer or from shortcuts. What change...multi formulas in excel
Please help, I'm trying to show margin or profit on a spread sheet the
formula I am using example:
=C4/C3 Where c4 equals 300.00 and c3 equals 100.00 answer is 33.3% but what
I want is the inverse or 66.7% I have tried =C4/C3-1 but this gives me -66.7%
I need the answser to be positive, example 66.7
MS Excel MVP
"the_catster" <email@example.com> wrote in message
> Please help, I'm trying to show margin or profit on a spread sheet the
> formula I am using e...find instances & report neighboring values
I am attempting to sub total amounts by month for a fairly large number
of items. I would like to have excel find all instances on one date
(Oct-05 or Jan-06 for example) and report all of the values in the cell
neighboring each (ex, if I am adding the Oct-05 values, I want it to
find the Oct-05 in d-4 and d-8 and report the value for e-4 and e-8).
Once the values are reported, I need the values added . I don't care to
see each value but I do need the total to be seen.
where A1 hoilds the date to test for.
(remove nothere from the email address if mailin...Office 2011 Excel Beta 3+ cell right-click context menu won't work
I've been running the beta versions of Mac Office 2011. Up until Beta
3, I could right-click in an Excel cell and get the context menu as
expected. Now, starting with Beta 3 and into Beta 4, I have lost that
functionality. Has anyone experienced this? I can't find a
preference/setting that would bring this feature back. This is very
frustrating and I can't figure out what may have changed to cause this.
On 7/14/10 10:17 AM, in article
Barry" <firstname.lastname@example.org> wrote:
> I've be...Help! Excel freeze the whole thing when start.
Excel problem in my office has been constantly bugging me. Now that
one of the computer can even start Excel, when we try to start it, it
gives something like "resource is not enough" message and then just
dies there. We can even fix it by removing it and reinstall it. Any
one has idea deal with this? Many thanks in advance.
Try cleaning up your windows temp folder.
And if that didn't help, try searching for your *.xlb file. It's where excel
stores your customized toolbars.
Windows Start button|Find|files
check out the size of that file. If it's huge, try r...Excel guru's Urgent help
I have a bunch of charts created in Excel97 that are driven from pivot
tables on another sheet. When the workbook is opened in Excel 2000
everything works fine except when you change criteria causing a macro
change the pivot tables, the source data range does not automatically
reset as it does in 97. I have to manually click on Source Data,
in the pivot table, and the range is reset, fixing the chart. I don't
know much VBA and I would like to hang a sub at the end of the macro
that would automatically reset the source range. Can someone help
I cr...Import information to Excel
I have a link to transfer data from an internet resource into my excel sheet.
I can only grab block of information from the webpage. Is there a way to
specify the inforation I want instead of having to link the whole block of
data? The reason I'm asking is when I link a block, several column of data
will be imported to Excel in one column. I use "Text to Columns", but that
won't help next time I refresh the data.
in <get external data> if you want the tables only you can specify. If
you want only one table then also you can specify. Only proble...Can you create a check box or radio button in Excel?
Try showing the Forms toolbar. There's a checkbox and option button on that
The control toolbox toolbar also has its own versions of these, too.
Thank you very much for your help.
"Dave Peterson" wrote:
> Try showing the Forms toolbar. There's a checkbox and option button on that
> The control toolbox toolbar also has its own versions of these, too.
> sf49ers wrote:
> Dave Peterson
...View/Print Individual Reports
Here is what I have:
I have a database for tracking therapy clients. Client data is in one table.
Therapy progress notes are in another with a one-to-many relationship. I have
a form w/ subform set up to receive the data. I have a query set up to tie
the two tables together and feed into a report. (Tables/Forms and Queries all
do what I want them to properly) Right now, the report contains data from
every client and progress note.
What I want is to be able to place a button on the subform for the progress
notes, so that when it is clicked it generates the report with just that...Counting in excel #3
I have a workbook of several sheets which have hundreds of
rows of data, and I want to make a summary sheet which
takes data from one column of each sheet. In the summary
sheet I want to see how many items are in the sheet within
a given range. For instance the table is titled gains
The ranges are 1-500, 500-1000, 2000-5000, 5000-10000, and
I'm pulling the data from column N of sheets titled NE NW
SE MW SW and GL. What counting formula could I use?
I think I'd add a new worksheet and then copy each of those column N's into one
giant column in that new worksheet.
...Excel and Access Linking
I am interested in linking the two together for a project at work. I
work for a construction company and I need to keep track our employees
and the work they perform. I also need to do this for our subcontracted
work also. We have about 95 clients and about 15 different crews
I am looking for some good reference books or web site linkings on
Access and Excel.
I enjoy this forum nad have found many useful topics.
Message posted from http://www.ExcelForum.com/