Changing chart types with series
I currently have a graph comprised of 4 different series. 2 of the series
are bar graphs, 2 others are line graphs. The problem is that one of the bar
graphs is overtop of the other bar graph meaning I can't see that series.
I've tried going in and changing it by changing the overlapped bar graph to a
line graph but I can't seem to do it. I've right clicked, selected chart
types but I can't change only 1 series of the graph. Is there anyway to do
Sounds like one column is on the primary and the other is on the secondary
axis. You need ...Macro
Hello, I'm trying to sum certain cells in macro, however, the cell range is
not fixed;(i.e cells are based on variables)
Herebelow is an example of the macro but it's giving an error at the sum
funtion (would appreciate if you could help me find the mistake):
Dim i As Integer, x As Integer, y As Integer, z As Integer
For i = 2 To 15
y = i - z
x = i - 1
Cells(i, "H").Formula = "=Sum(Cells(y, "H"), Cells(x, "H"))"
z = 0
y = 0
x = 0
...Please help me decipher the result of COUNT.
Following data from A1:A7
=COUNT(A1:A7,2) returns 4.
I don't understand where the four occurrences of 2 come from.
22.24 = 3 occurrences
12/8/2008 = 2 occurrences
total of 5??
I know I am missing something. Please tell me.
Is there a tool that I can use to trace? I tried the formula auditing
toolbar, no luck because there is no error and trace precedents is not
have a look in the help index for COUNT
email@example.com...If statement result appearing in different colors
Is there a way to write an IF statement where the text will change color
depending on the result? eg
=if(x=0,"RED-colored text","BLACK-colored text") where 'RED-colored text'
would appear in RED, etc
Take a look at Format|Conditional formatting.
> Is there a way to write an IF statement where the text will change color
> depending on the result? eg
> =if(x=0,"RED-colored text","BLACK-colored text") where 'RED-colored text'
> would appear in RED, etc
> Thank ...Conditional Formatting using result of Cell Formulas
I'm trying to make a conditional format when the result of a formula
results in a value being entered in a cell.
I'm using Excel Xp and my formula is as follows.
I've tried using formulas like >0, <>"", <>BLANK etc. but they all
seem to fail. All cells are formatted, even entirely blank cells, as
if the condition has been met.
BTW, is this formula better strategically than the above formula.
If ...Count results from query with no results
I have continous form with an unbound text box [keyword] and a button
[search]. There is also an unbound textbox [numberofresults] that counts the
number of records returned. If the search produces no results, the
[numberofresults] needs to read 0, instead it is just blank. What is the
proper way to show zero results as 0 and not blank?
It depends on how you are doing your search? Do you have a function? Are
you just filtering the recordset?
email address is invalid
Please reply to newsgroup only.
"Ryan Tisserand" wrote:
> I have continous form with an un...changing CRichEditView color without changing the selection?
I'm trying to change the color of a portion of text inside a CRichEditView
control. The only way that i know of to do this is to highlight the text and
then set the character formatting to change the color.
Just wondering if there is a way to avoid highlighting the text and yet be
able to colorize it?
"MrPolite" <kderakhshanAtMSN@msn.com> wrote in message
> I'm trying to change the color of a portion of text inside a CRichEditView
> control. T...how do I change a cell permanently to PM from AM?
I would like to do this permanently to the template, so that I have
timesheets that I don't hav eto change everytime I input my time data. Thx
The question is not clear so here are some suggestions
A1: 11:00 PM ---> B1: 11:00 AM
Menu:Data>Validation... Allow:Time, Data:Less then or Equal to, End
Hope it helped
olasa's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17760
View this thread: http://www.ex...How to paste Conditional Formatting to other cells but using different data cell
I've made a spreadsheet that has a column for days of testing and
another column that calculates the actual days it took for testing.
Each row has a different day requirment of when testing should be
complete. How can I format the column of "actual days of testing" to
color the cell in red with bold type when the value of this cell is
greater than the cell of "days of testing"? I tried conditional
formating, but this only works for one row, when I tried to paste the
format to other cells it used the data source from the first row. It
would be too time consuming to indiv...sql result different to excel result
Just wondering why I am having such problems rounding figures, when I round
the same figure on an Excel Sheet, I end up with a different end result to
what appears in sql.
The Excel Looks Like This.
Net Vat Total Allocated Result
900.00 157.50 1721.38 1721.38 1057.50
150.00 26.25 1721.38 1721.38 176.25
The Result field is a calculated field and is rounded to 2 decimal places,
the calculation is in brackets next to the title name.
The Table in SQL has the same structure but the net, vat,...Visual Basic:Change on event
I wish to reset the properties of several worksheet controls on the
entry into a cell. The visual basic help suggests using
Sub Worksheet_Change(ByVal Target as Range)
What is the syntax to be used here is it
Sub Worksheet_Change(ByVal .Range("C11"))?
or Sub Worksheet_Change(ByVal .Range("C11") as Range)?
Sub Worksheet_Change(ByVal ("C11") as Range)?
I am using Excel 2004 on OSX 10.4
put in the SHEET module
private Sub Worksheet_Change(ByVal Target as Range)
if target.address="$A$11" then
do your thing
...Why does change in IV00102 update DEX_ROW_TS in IV00101?
We've had some performance problems since upgrading to GP10. In researching
this problem I discovered that the item quantities table, IV00102, has an
AFTER UPDATE trigger called zDT_IV00102U that updates the item master table,
IV00101 (specifically, it is setting IV00101.DEX_ROW_TS to the current date
We had auditing set up on IV00101, thinking that auditing changes in a
master table would not have much impact on performance, but because of this
trigger every time a document posts that changes inventory quantities our
auditing on IV00101 fires also. What is th...Changing the System Date
can anyone tell me the code for changing the System date
from the program.
>can anyone tell me the code for changing the System date
>from the program.
Try the SetSystemTime API.
MVP VC++ FAQ: http://www.mvps.org/vcfaq
In article <firstname.lastname@example.org>,
> Hi there,
> can anyone tell me the code for changing the System date
> from the program.
SetSystemTime changes the date. On NT-based systems, you'll have to
enable the SE_SYSTEMTIME privilege before that can succee...How do I change the column headings in Excel?
I have a new computer at work and when I opened excel, i found the columns
are labeled with numbers, just like the rows. This is very confusing. How
do I change them back to letters like it should be?
Go to Tools>Options>General and uncheck the R1C1 Reference Style checkbox.
(remove nothere from the email address if mailing direct)
"scmagnum" <email@example.com> wrote in message
> I have a new computer at work and when I opened excel, i found the columns
> are labeled wi...Change the mail Subject
When I choose to send my SOP Blank Invoice Form to a mail recipient
(pdf), information is populating the subject line and body of my e-mail by
default. Specifically the name of the report is populating the subject line.
Is there a way to change this? I would rather see the Invoice number or
customer name populating that field.
Out of the box, no. When you print a report to screen it loses all
knowledge of what report it is (or where it came from). That's why when you
then send to pdf the best the window can do is use the title of the output
window as the s...Updating cells using input boxes
My problem is that i am using Input boxes to update a spreadsheet. I
have two coloums i want to update for two diffent type of information.
I am currently trying to use
MyInput = InputBox("Enter Students Name")
Range("Sheet1!N20").End(xlDown).Offset(1, 0).Value = MyInput
MyInput = InputBox("Enter Fee")
Range("Sheet1!O20").End(xlDown).Offset(1, 0).Value = MyInput
But this seems to update the first colum ok and move down updating as
required, but it just replaces the value in the second coloum and
doesn't move ...why cut and insert cells only works randomly?
It seems that cutting and inserting cells in the spreadsheet, errors every
other time and locks the excell spread sheet...
You'll have to be more specific, but you might find the answers to such problems
as inserting rows, using OFFSET with formulas. And you will probably find why
extending formulas and does not work for you. -- if any of those are the problem.
I don't know what you mean by locking the sheet, have you turned on sheet protection
or have merged cells in your copy..
David McRitchie, Microsoft...Cell comments
Is there any way to stop cell comments resizing when inserting new rows
above or below the cell with the comment, as at the moment if I insert a
row above a row which has a cell with a comment, the comment will resize
in height and it's very very very annoying.
flib's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15323
View this thread: http://www.excelforum.com/showthread.php?threadid=269492
You could set the properties of the comment so it doesn't s...How to replace a function with its result or resulting reference in a formula?
How to replace a function with its result in a formula? For example,
How to replace a function with its resulting reference in a formula? For
example, =HLOOKUP(1...)+HLOOKUP(2...) with =b11+z11.
I need to replace in 1000 cells automatically.
"Dmitry Kopnichev" <firstname.lastname@example.orgDelete> �������/�������� � �������� ���������:
> How to replace a function with its result in a formula? For example,
> =INDEX(...)+INDEX(...) with
> =r...Pivot Table not populating cells
I have a set of data which I need to put into a PT: Level 1 is Surname and
level 2 is First Name. I've sorted it within the PT by Surname then First
name. I have 15 instances of the name Jones. When the PT is produced it
only shows one instance of th word Jones and then the rest of the lines below
(ie the other 14) have no data. The next column to the right has all 15
First names but the only one with Jones next to it, is the first one.
How can I get my PT to show ALL surnames next to all the first names please?
Thanks in advance,
The row headings show once in a Pivot Tab...Formula to return numerical, text result?
I need to create a formula that based upon three possible factors, wil
return one of two calculations or a text message.
If cell B="Good", the formula in cell C returns "Text"
If cell B="Better", the formula in cell C returns cell A*.3
If cell B="Best", the formula in cell C returns cell A*.5
Thanks in advance for any tips
burgeon's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2023
View this thread: http://www.excelforum.com/showthread.php...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...Hide results
I am putting together a summary spreadsheet of dates from seperate worksheets
in an excel file. In the summary sheet I reference the 'end' date from the
summary sheet. If there is no date in the original file, what formula can I
use to leave that cell blank/hide on the summary sheet? The way I have it
now the results show the default of 1/0/1900
Here is the formula used to reference the info from.
"bigred72" <email@example.com> wrote in message
...Sum in another cell with reference to another
I need to add cells which only have reference to another eg:
PNS Kilbirnie 2.0
NW Newtown 1.0
NW Island Bay 1.5
NW Metro 1.0
PNS Kilbirnie 1.0
eg: Need to add only the "PNS Kilbirnie" totals but these are also in other
columns similar to above. At the moment these two columns are A & B, then I
need to also add the Kilbirnie from column C & D as per above
One way to get this delivered in 10 secs. Do a 5 sec copy/paste stack up of
the data in cols C & D below that in col A & B, then create a pivot on the
combined data, placing the ...Rounding actual results
I've got a grid that says:
Maths: 5 25
English: 7 25
And so on.
I'm wanting to work out how much time is devoted to learning in the whole
week. What I've got so far is:
Total learning time: =A1+A2...
all totals in
My current answer for hours is 18.
I'm stuck with what to do with the minutes column. so far, I've got an