Chart Formatting #5Is it possible to have a series data point (2) change colour if the value
drops below that of data point (1) and revert back again if it rises above
that of data point (1). (And possibly be a third colour if it is equal in
value)?
Sandy
http://peltiertech.com/Excel/Charts/ConditionalChart1.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"Sandy" <sandy_stephen@DELETEhotmail.com> wrote in message
news:Oz9eTpN4HHA.5724@TK2MSFTNGP05.phx.gbl...
> Is it possible to have ...
chart disappears #2In excel 2007 I have data on a sheet from which I created a chart. I then
moved the chart to its own sheet. I updated the data once a day for a couple
days and the chart was also updated. Then one day I open the file and the
chart is gone. The sheet it was on is still there. The data sheet is still
there, but the sheet is gone (or not visible?) and I can't figure out why or
how to get it back.
This is happened twice now and is getting quite irritating. Any thoughts?
I have been unable to reproduce this. I did what you did but my 'day' was
about 1 1/2mins. The chart su...
What's the best chart style for graphing questionnaire responseI have to graph responses gathered from a 7 question survey given at the end
of training courses. Scale of response is 1 thru to 5 with approx 12
attendees on each course within 15 training sessions. I'm using Excel 2003.
I would recommend The three D Column Chart with the questions as catagories
and response level as series (Set up 5 series ) Count the number of "1"s
for question 1 and enter this value into series 1 at catagory 1 do this
for alll of the responses and all of the response levels.
"gemini1215" wrote:
> I have to graph responses gathered f...
to make column letter dynamic in chartsI know there have been previous posts on this but I am relatively
new
to VBA and am having trouble adapting it to my needs
I have many charts in a sheet. i want to make their souce data
dynamic. the source range of charts are like sheet1!$B$9:$CN$13
where $B$9 is starting range and " $CN$ " is ending range.
for every chart the starting range is different but the ending
Datarange is of same Column "$CN" . i want to make the column Letter
dynamic ,Row number are Static ... from "CN" it has to change it to
"CO" in all the charts.. Every occur...
Getting a chart on the webHi folks,
I am hoping someone out there might be able to help me or give me some
advice. Here is what i am trying to do.
I have a list on a Sharepoint site with numeric data i want to show
graphically. Now i can create the chart in excel via a web query when i
export the list. As the data on the list changes, refreshing the book
changes.
But what i need to do is get the chart on the site, linked to the date,
dynamiclly refreshed, linked to the list with the data.
Any advice on the cleanest way to do it?
thanks
ben
...
charting same cell across multiple tabs #2How do you create a chart reference to that it will chart the same cell
but across a range of tabs.
Example, I have a years worth of tabs on a sheet, MMDDYYY, all with the
same format on the sheet. I have a value that is in the same cell on
each tab and I want to see the trend over several months, from tab x to
tab y.
I thought this would be the formula: ='08042003:10142003'!$R$4
But I get the error: reference not valid.
Thanks, Ron.
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from htt...
Name of the sheet where the formula result isI use max()and min() in the result sheet to define the max
and min values in 10 sheets where test data are. How can I
display the sheet name of the result from the
calculations? For example, if the result of max() is from
sheet 1?
Thanks a lot
Catherine
You will probably need a macro to search the sheets for the values. I
would probably be a good idea to keep searching to the end of the las
sheet to check for duplicates
--
Message posted from http://www.ExcelForum.com
This might not work for you, but I'd lay out part of my summary sheet like:
Sheetname Max (this formula...
display number as number nameI want to get the number name of the corresponding number i enter.
Hi
see:
http://www.xldynamic.com/source/xld.xlFAQ0004.html
"Kamala Kannan" wrote:
> I want to get the number name of the corresponding number i enter.
...
howto: saveas with file name from a cell in the current worksheet #2see subject
bob,
You can do it with vba. Here's a small snippet that you can assign to a
command button. Where "A1" is the cell that you are using to name the file.
This will save in the last folder you saved to.
ActiveWorkbook.SaveAs Filename:=Range("A1").Value
HTH
Bigpig
"bob" wrote:
> see subject
BigPig,
Thank you. I have that part, but what if I wanted to add in a specific
folder to save it to? Where would I add the folder string? That's where my
real issue is. Thank you again.
ActiveWorkbook.SaveAs Filename:=???????Range("A1&...
Cached Mode disables addressing emails with First Last name formatIn Outlook 2003 (just upgraded) using Cached Mode, I notice that I can no
longer address emails with a simple, normal name (e.g., "john doe"), even
though that name exists in the Global Address List. (Previous Outlook
versions allowed this when synching to an offline folder was enabled.) Now
when I attempt to address an email with the "FirstName LastName" format in
the To box, I get a dialog stating that "Microsoft Office Outlook does not
recognize "john doe" " . This only happens when Cached Mode is enabled.
Am I faced with a choice here: I...
MS Money 2004 User NameIs there anyway to change my user name? I have moved and
had to change my email address, so I would like to change
my user name also. It had a comcast.net, now I would like
a hotmail.com as a user name. Please tell me how to do
this.
In microsoft.public.money, megan megliseno@hotmail.com wrote:
>Is there anyway to change my user name? I have moved and
>had to change my email address, so I would like to change
>my user name also. It had a comcast.net, now I would like
>a hotmail.com as a user name. Please tell me how to do
>this.
Patience.
Go to Money's help...
error getting the encoding name from an XmlTextReaderXmlTextReader myXmlReader = new XmlTextReader(args[0]);
string en = myXmlReader.Encoding.EncodingName;
//Console.WriteLine(x);
Error:
Unhandled Exception: System.NullReferenceException: Object
reference not set to
an instance of an object.
HOW CAN I GET THE ENCODING NAME ? Basically determine the
encoding type.
Also How can I "set" an application wide Encoding ? I want
all modules and everything to stick to and conform to UTF-
8.
But somehow some methods automatically go to UTF-16
xmlguy wrote:
> XmlTextReader myXmlReader = new XmlTextReader(args[0]);
> string en = my...
Chart title #4Hello everybody. How to name the chart (title) with the value in a cell. say
B1.
Thanks to you all
With regards
Sridhar
Select the chart title, click in the formula bar, & type = then click in B1,
& accept the formula.
--
David Biddulph
"yshridhar" <yshridhar@discussions.microsoft.com> wrote in message
news:39D32BA9-7109-4ED2-8F83-E9CE99D3501A@microsoft.com...
> Hello everybody. How to name the chart (title) with the value in a cell.
> say
> B1.
> Thanks to you all
> With regards
> Sridhar
Sorry Mr. David. I could not follow you. Chart|c...
chart with color automationHow can I create a bar chart with color according to an excel column
conditions. For example I have a graph with all salemen and in excel I have
a column which describe which products with the amount of sale column.
By look at the color I would know which product and the sale amount?
Thanks in advance
Daniel
Below are links to a couple of examples:
http://www.cellmatrix.net/index.php/auto_color_chart_bars_version_1/
http://www.cellmatrix.net/index.php/auto_color_chart_bars_version_2/
--
John Mansfield
http://cellmatrix.net
"Daniel" wrote:
> How can I create a ba...
Problem printing a scatter chart with more than 2706 rows of dataI have encountered a problem with Excel 2007 recently. A scatter chart, with
smooth lines, based on 2706 rows of data will print correctly, but if I
expand the data to include 2707 rows of data, the printout lacks the plot of
the series data. the gridlines are there, axes, even the legend showing the
color for the series data, but plot of the data is missing. I have a program
which plots data for 3 columns with 4096 rows. The printout works just fine
using Excel 97, but not for Excel 2007.
Can anyone give me a clue about what is happening here?
--
Terry G. Capps
Excel 2007 chokes ...
Calculation/Sum based on Name Box
Hi,
scattered all around in my big excel sheet i have named some cells by
name. And now i need a easy way to sum up the values in thos cells.
One of the cell name box values i have used "L11x361", "L11x362" and so
on (just changing the last number).
I also need the sum to to calculate from "L11x361" to let's say
"L11x3615" even tho i only have used up to "L11x369". This is just if i
in the future add some new cells to this series.
If i just try to type
"=L11x361+L11x362+L11x363+L11x364+L11x365+L11x366" (and so on up to
value 1...
file name/directory prints outevery time i print a word document, it also prints a sheet with the file
name, directory, date, characters etc. how can i stop this from printing
every time?
Go to the Print dialog (Ctrl-P) and uncheck "Document Properties."
On Apr 13, 12:15=A0pm, Laura24 <Laur...@discussions.microsoft.com>
wrote:
> every time i print a word document, it also prints a sheet with the file
> name, directory, date, characters etc. =A0how can i stop this from printi=
ng
> every time?
In the Print Options, clear the check box for "[Print] Document properties."
...
Chart series legend font size keeps shrinkingExcel 2007.
I set the font size at 10pt, but it seems that each time I open the file,
the font size gets smaller. By the time it gets to 7pt or less, it is really
annoying and I re-set it to 10. It should stay at the size selected by the
user, not choose its own size.
...
how to make language independent a chart applicationHi, I'm facing up with this problem:
I wrote an application which dinamically creates a chart via VBA.
This chart MUST be built in this way:
Set costChart = ActiveSheet.ChartObjects.Add(Left:=50, Width:=800,
Top:=30, Height:=400)
costChart.chart.ApplyCustomType ChartType:=xlBuiltIn, TypeName:="Line
- Column"
now, the problem is that the application must be language independent,
and in other languages different from English, the TypeName "Line -
Column" is not understood.
The kind of graph is mandatory (from customer specification), so I
must use ChartType:=xlBuiltIn...
naming rangeHi,
I have many worksheets in a workbook and I tried to define a name for
one worksheet only. For some reason, after I defined it(by selecting
the range and typing a name in the range name textbox), this name shows
up in other worksheets as well. Also in the �Define Name� dialog box,
the worksheet name does not show up next to the range name. What do I
do so it shows up? How do I define a name that�s unique only to one
worksheet?
Thanks.
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www....
Changing the name of a table that then relates to a queryI changed the name of a table that relates to a lot of queries.....these now wont work....how do i resolve this....thanks for ANY news!
Submitted via EggHeadCafe - Software Developer Portal of Choice
ADO.NET Recursive Hierarchical DataSet Technique
http://www.eggheadcafe.com/tutorials/aspnet/f492b744-8326-4671-a7c3-9143dd2c6da3/adonet-recursive-hierarc.aspx
1. Change the table name back to its orginal name.
2. Download Rich Fisher's excellent Find and Replace add-in and change
everything to match the new table name. If you register it (one of the best
$37 I've ever spe...
How do I get my address book to display in last name order?I've tried the solution suggested to a previous user but it hasn't worked.
Any other suggestions?
You tried what suggestion in what Outlook version? Don't forget to restart
Outlook.
--
Russ Valentine
[MVP-Outlook]
"calian armed man on in" <calian armed man on in @discussions.microsoft.com>
wrote in message news:9004A005-6117-41E6-A4EB-2BFED9A3E5CB@microsoft.com...
> I've tried the solution suggested to a previous user but it hasn't worked.
> Any other suggestions?
Have you tried this link?:
http://office.microsoft.com/en-us/assistance/HP0103...
Combining rows with duplicate namesHi I have data that contains a mix of numeric and text fields and rows with
duplicate names. I would like to combine rows with duplicate names into one
row. Here is the example of my data:
Name | Company | City | #ofaccounts | commission
---------------------------------------------------------------------
Jon Smith | CompX | NY | 5 | 500
Jon Smith | CompY | Toronto | 10 | 3000
Jon Smith | CompY | LA | 15 | 1000
Jane Doe | CompZ | Detroit | 25 | 2000
Jane Doe | CompZ | Detroit ...
Help needed to modify macro to convert User IDs to NamesHello
I have a macro which I've been using for quite some time. This macro allows
the user to identify the User IDs of people listed in the spreadsheet.
However, I now need a macro to do the reverse. That is, it needs to find the
names of people whose User IDs are listed in the spreadsheet. If possible, it
would be great to list the given name and surname in separate columns,
although I could do this separately via another macro.
Is it possible to modify the existing code below to achieve what I want
(i.e. so
that it does the reverse of what it currently does)?
I...
outlook 2000/auto name fill in won't workWhen making new email messages and using contacts already
entered the auto name fill in option doesn't work. Is
there a place to turn on this feature? Everyone else
I've asked (and the books I've read) say this is an
automatic feature! But not on my outlook 2000.
Any help is appreciated. I'm tired of typing
Outlook 2000 doesn't have an auto-complete feature. It has an auto-resolve
feature. If you enter an abbreviated form of an existing Contact, Outlook
2000 will attempt to resolve it to that contact. If it underlines it green,
it means it found a match. If it und...