not able to link chart points from same series
I'm working on a chart that pull information from several pages.
Tha table is able to plot information correctly in the graph but I can't
seem to link the dots on the chart with a line.
Everytime I try a linear chart or a scatered chart with smoth lines, the
lines start from the x axis and reach the dot rather than connecting dots
from the same series.
suggestions would be greatly appreciated.
If the points are not in the same series (i.e., the data source is from
different sheets, not a single summary sheet), you will never link them. If
you have gaps, true actual blanks (n...Excel, how do I change the column headings from letters to number
I have a spreadsheet that has numbered columns as opposed to the standard
letters. How can I change this back to letters?
Go to the Tools menu, choose Options, then the General tab.
There, uncheck the R1C1 reference style setting.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"lazybee" <firstname.lastname@example.org> wrote in message
>I have a spreadsheet that has numbered columns as opposed to the
> letters. How can I change this ...Exchange 2000 DST Changes
How is one supposed to address the DST changes for Exchange 2000 if
they do not have extended support to get the patch? Will Microsoft be
providing a workaround like they did for Windows 2000?
I'm referencing the following article:
It states :
What to do before you run the Exchange tool
Install DST updates
Before you run the Exchange tool, make sure that client and server
computers are updated correctly with the operating system and
application DST updates. These updates must be installed in the
1. Install the Windows DST upda...Naming charts on own sheet
I have a series of charts (which are all contained on their own sheets).
I need to name each of the charts (as they will be used by someone else in a
I have tried clicking on them and also pressing shift before clicking on
them, and I am not able to change the name in the name combo box.
Can anyone advise me of how I can change the names.
Thanks for your help.
If you have chart sheets you can change the name by simply changing the
sheet tab name.
What you described is the method used on chartobjects, which are usually on
Andy Pope, Mi...Changing Item #'s
Is it possible to change the item #'s after the item has already been entered?
No there isn't in the "base" product, but MBS does have a tool that you can
use called Item Modifier - this will allow you to change an Item number from
one value to another.
You can email this address below and they can answer any questions you have
about the tool and can tell you what the cost of it is.
Hope that helps you out,
> Is it possible to change the item #'s after the item has already been entered?
...loan amortisatio chart not updating
I use MS Monet 2007 premium. I have created a loan amortisation account
which breaks up my monthly instslment into pricipal and interest. The loan
commencd from 7 October 2005 and is for a period of 5 years. The problem is
that the loan account does ot show any loan instalments beyond 7 October
2006 (exactly 1 year after the commencement). Why is this happening. Why
is the account not updating with instalments which have been debited to my
account after 7 October 2007.
Were you depending on downloaded transaction data for this account? Did the
download link br...How do I make a chart with several times during a day
This seems like it may be a simple thing, yet I can not for the life of
me figure out how to do this (or at least semi-easily with VBing it for
I have a simple table filled with the following information (example
12pm 5pm 10pm
11/20 5 4 7
11/21 5 4 7
11/23 5 4 7
11/24 5 4 7
11/25 5 4 7
So basically I am keeping track of a numeric value three times a day. I
would like to make a chart of it with...Outlook color scheme
I've seen several different installs of Outlook 2003.
Some have an orange interface, some blue, some grey. I'm
not talking about Outlook web acess, but the local
installed copy. Can anyone explain this? I would like to
figure out how to change the interface color scheme.
It uses Windows color schemes. Change those from Display Properties
(Control Panel or right click you desktop).
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will ...Adding a certain text label in a excel chart
I am plotting in regularly basis a certain set of data in excel.
Based on some data analysis this set of data has to be fitted to these
y = 1/x^a (1) and /or
y = b/x^c (2)
from data analysis, constants a, b and c are found and are placed lets say
in cells A1, B1, C1.
On my graph, I am putting then two small text labels where the real equation
is displayed: smth. like: y = 1/ x^3.45 and / or y = 0.256 / x^3.12 The
whole process is similar with excel curve fitting, when the “show equation on
chart” is checked.
Thank you in advance
My question is: Can ...survival chart
Does anybody have an idea how it would be possible to
trick Excel into making a survival plot? That is a stepped
graph ploting cumulative survival on the y axis and time
slots on the x.
Any suggestion would be most appreciated.
I don't have a 'survival plot' per se, but you could look for ideas on
my web site. The cumulative probability plot sounds like a possible
If it doesn't give you any idea, post back with some typical data, and
we'll have a look.
- Jo...Chart "Benchmark" Line Graph Question
I am generating a graph of many team's monthly audit productivity percentages
(bar graph) with a "benchmark" (line graph) at 95% (y axis) across 6 month
period (x axis).
The problem is that the line graph appears on the graph but the ends of the
line are centered in the end columns (left & right). Is there as simple way
to extend the benchmark line out to the edges of the graph?
Have a great day and live life with passion!
...Chart printing issue in Excel 2007
A spreadsheet with charts was created using Excel 2003. I have Excel 2007
and saved it in compatibility mode.
I inserted a couple colored lines on the chart and created my own legend
based on these. A couple of issues:
1. When I close the file or even minimize, 2 of the colored lines on a
couple of my legends disappear upon reopening.
2. When I try to print a chart, it looks good in Print Preview, but then
looks magnified,half off the page, and only one of my drawn lines is printed.
When someone with 2003 prints, the sizing is correct, but all of the
colored drawn lines are missing...trying to link maps and pie charts
I was trying to link sales data stored in an excel table with a specific
country in MapPoint. This software allows you to do this very easily. You can
even picture the data in piecharts (% sales for each competitor).
However there is very little flexibility with the look of the result: you
cannot choose the color of the slices of the pie, you may not display data on
the graph, and the maps do not look very professional.
I know it is possible to link automatically a table with a shape in visio.
Can this shape be a given country/region on a map? Can the callouts have th...Changing named range reference depending on a cell's content
Where to start?!
I've got the following formula pulling data in from a secon
spreadsheet within the same workbook:
We have 8 different locations ("MICH" being one of them) that we nee
to be able to access. I can write a nested IF formula that looks a
cell I7 (that contains a list of all 8 locations) and, depending o
I7's content, brings back the desired values.
I was hoping someone in the forum could help me write a simpler formul
that would not have 7 IF statements embedded in it.
Any help w...Using "fixed" decimal place function data for charts
Is there a way to graph data which utilizes the "fixed" function for decimal
places? When I try this it will not graph, as the data has become text or
something - even though I've selected number in the cell formats.
If you've fixed the number of digits using only number formats, the values remain
numeric, and they should chart just fine. This means selecting the range, going to
the Formatting menu and selecting Cells, and on the Number tab, selecting Number in
the category list, and setting a number of digits.
I'm not familiar with a "fixed function". I...Range Names with Charts
I would like to use rangenames to specify the data sources for a chart, but
Excel does not seem to like this. I have tried entering the rangename in the
.... and various other formats.
Surely there is a way to do this ....?
try either depending on whether the named range is local to the sheet.
> I would like to use rangenames to specify the data sources for a chart, but
> Excel does not seem to like this. I have tried en...Stop changing of languages in Word 2003 when typing letter.
While typing a letter in Word 2003 it changed from English to what looked
like Arabic language. I have rebooted 3 times and started over and still
the same occurs. I even copied what I had in English to an email in Yahoo
and sent it to myself and rebooted. Came back to that same email and copied
it to a new email that I started to myself, and when I started typing it
would only type in what looked like Arabic language.
This happened to me once a couple of weeks ago, but never occurred again
What do I do?
In the Language dialog box, turn off the option to autom...Strange behaviour: show/hide formatting symbols reveals old change
In Word 2007, I'm getting some strange behaviour in a document that was
authored by someone else. Track Changes is switched off, all changes have
been accepted, and everything looks as it should in whichever view I happen
to choose (Print Layout, Draft, whatever). But when I click to show
formatting symbols (in whatever view) a whole lot of old changes - deletions
AND insertions, ostensibly all accepted, and from before the document got to
me - appear in the document, making it quite tricky to work with. These old
changes are impervious to anything I try to do with them
E...Column and Line Chart
I am making a Custon Chart using the First -Column and Line Chart. When I
setup the chart it makes the last column a point instead of a column. When I
go in to change the type of Chart it makes the bar much bigger than the
others. I know you can go into Format and decrease/increase width- but I
can't believe there is a not a way to tell excel to make this a column on
setup so they are all uniformly spaced. How does Excel decide whether it is
a point on a line or a bar?
Hi Nikki -
Excel simply splits the number of series between the lines and columns. If you wa...Color change in cell when > 49.99
I need a cell to change color if the value inside the cell reaches 50 or
higher.either text or cell shade. just so it catches the users attention.
im running excel 2000. and i have this currently in the cell that i want to
aplly this to:
have you tried conditional formating?
>I need a cell to change color if the value inside the
cell reaches 50 or
>higher.either text or cell shade. just so it catches the
>im running excel 2000. and i ...Area Chart Question
I am graphing an area chart off a table of numbers. Is there a way to show
the summary totals in the data table that I am showing on the graph without
having the totals appear on the area graph itself?
Unfortunately the data tables are not going to give you a lot of
flexibility. Whatever is in the chart is going to show up on the data table.
To get around this restriction, I would suggest creating a data table made
of worksheet cells as opposed to using the standard data table. The link
below describes the process:
http://www.pdbook.com/index.php/excel/a_simple...Date/Time Show When Changes Made
When changes are made in a table or form, I want the date and time to appear
showing me when changes were made in any of the fields.
How can it work?
It's not possible if you're working directly with tables.
Using foms, you have to put code into the form's BeforeUpdate event to
update the row's LastChanged field (which, of course, you have to add to the
You might find what Allen Browne has at
http://www.allenbrowne.com/AppAudit.html to be useful.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Beame...How to implement a progress bar on a status bar
If I want to implement a progress bar indicating process of some algorithm
or function, how should I programme to make the progress bar appear on the
status bar in foot of the window? Is there any sample code I can follow?
>If I want to implement a progress bar indicating process of some algorithm
>or function, how should I programme to make the progress bar appear on the
>status bar in foot of the window? Is there any sample code I can follow?
I've not used it, but this may do the trick:
Showing progress bar in a status bar pane
http://www.codeproject.com/...OWA and password change
I have OWA in the DMZ but the mail server is behind the DMZ. I have no
problems accessing OWA but I do have a problem see the users on my DC. The
real issue is that I am trying to have users change their own password
within OWA and need to know what ports I need to have open without any
security breach. I need to know what is safe to open and what's not safe to
have you seen this articel s?
F...formatting of charts changes when copying from excel 2000 to 200.
When I copy a chart from Excel 2000 and paste it into Excel 2003, some of the
formatting is lost. In particular, scale and axis formatting. Is this a
programming issue or can it be corrected easily.
First one would answer why would you copy charts from 2000 to 2003, why not
make them in 2003?
Second and more important - how are you copying them - there are maybe 20
possible methods of copying a chart from one program to another. Please tell
us exactly which steps you use to do the copying. Also, exactly what
formatting are you loosing, what do you get instead?