Macro for Graph #3
For the following table, I have written the macro to obtain the graph
But the problem is the no. of column and rows can change... So I don
want to hard code particularly the first part of macro... Please help.
Keyword Date Total Of Value XYZ TUV RST
ABC 27/10/2003 7 7 11 100
ABC 27/11/2003 7 3 5 15
ABC 27/12/2003 7 10 200 25
ActiveC...need basic help setting up a graph
I am trying to set up a chart of days and times. The X- axis shoul
have the days of the week (mon, tues, etc) and the Y - axis should hav
various times of the day. I would like to have a line from on
specific time on one day to another specific time on the next. So,
point would be monday at 10:00 and the next would be tuesday at 1:00
followed by wednesday at 12:00, etc. Any suggestions?? Thanks fo
Message posted from http://www.ExcelForum.com
See my attachment. Is that the situation you explained?
I use formula
in column ...How do I export an Excel graph into a word document?
Copy, then go to Word, and edit-->paste special.
"jennyb" <email@example.com> wrote in message
...why do my graph axis titles become truncated
whenever i make an excel graph, the y axis titles are truncated. i am unable
to expand the text box which contains them. is this a glitch or what?
...Shaded 'radar' graph with markers
Good afternoon --
Excel seems to come with 3 canned 'radar' graph formats -- lines w/o
markers, lines w/ markers, and shaded area. The shaded area comes w/o
I want to use the shaded radar graph but, if some or all of the data points
are at the origin, then it's almost impossible to see. I tried to format the
data series to add markers, but it doesn't seem to be there. Is there some
way for me to do it? I use Office2003.
Thanks in advance.
Plot two series using the same data in a filled radar chart. Select the
second series (it's the one in front, so i...Grouped/outlined data only graphs when visible
When i group data, it has to be visible to appear on a graph. I also
want it to displaye when the grouping is collapsed.
I am charting data over a year. On the summary slide, i want to only
see the total of all the months, however on the accompanying graph, i
want to see how the data compiled over time (even when the grouping is
Can anyone help?
Sounds like you have the option to 'plot visible cells only' on.
Select the chart and the via the menus Tools > Options > Chart uncheck
plot visible only.
firstname.lastname@example.org w...How do you do a graph with a second Y axis?
I need to know how to do a graph that 2 Y axises. A three sided graph so to
speak with a Y axis on the left and right (different categories) and one X
Select the data as for a normal chart and click the chart icon.
Select the custom tab and choose column-line on two axis.
> I need to know how to do a graph that 2 Y axises. A three sided graph so to
> speak with a Y axis on the left and right (different categories) and one X
...Help needed for sorting the data and plotting graph
I am a newbie to the excel world. I have requirement of analysing some
data that I will obtain from symbian profiler. I will be having a .txt
file with values seperated with tabs so that it can be directly open
in excel. In that I have around 25 colums, first being sample interval
and rest are having data. My requirement is to plot a graph against
the sample interval with data from 2 colums. I can specify the column
name for plotting purpose. Once I plot the graph I should be able to
calculate the average value of one series for those interval in which
the other plotted series is cross...How to create Waterfall graph in excel (Vista)
Perhaps you mean Excel 2007 rather than Vista, which is the operating
Anyway have a read of Jon's articles on Waterfall charts.
Andy Pope, Microsoft MVP - Excel
"Leanne" <Leanne@discussions.microsoft.com> wrote in message
Have you looked at http://peltiertech.com/Excel/Charts/Waterfall.html
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"...Issues with Reconciling 401(k) investment Account
When I try to reconcile my 401(k) account, I'm running
the balancing "wizard", however none of the "Cash
Transactions" for the given period are being moved to
the "Investment Transations" as they have in the past.
So now, when I look at the bottom left when I'm in
the "Cash Transactions" account, it says "Updated on
6/30/03", but there are still cash transactions from
April until June.
Did I do something wrong? Or how can I delete the last
Thanks in advance for your help-
I need to get a line graph, with two lines on, chosing which data goes
on which line. I have had lots of trouble trying to do this already..
Tell us more about how the data is set out on worksheet; and how the choice
is made for Line A or Line B
Microsoft Excel MVP
<email@example.com> wrote in message
>I need to get a line graph, with two lines on, chosing which data goes
> on which line. I have had lots of trouble t...Nice Column Graph
So I have data like this:
Year Month #start #end
2001 1 4 2
2001 2 6 5
2001 3 7 1
2001 4 5 4
2001 5 2 6
I'd like to make a column chart where the year and month are on one
axis and then I have a column for each #start and #end for each
month/year pair. Is there a way to tell the chart wizard that I want
to use those two columns for the x axis and then the #start and #end
columns for the other?
Remove the 'Year' and 'Month' text from the 2 cells and then select and
use the chart wiza...Macro with line graph
I have huge data with different headers. I want to plot a single line graph
linked with a validation with the list of all the headers. The data in the
line graph should reflect only the selected header among the list.
For example, In the below example i should have a button command with the
validation list of all the three headers below apples, oranges and grapes.
By selecting oranges in the list, the line graph should pick only the data
from colA and colC.. like wise
ColA ColB ColC Cold
Row1 Time Apples Oranges Grapes
Row2 12:00 ...Graph: number of curves
What is the maximum number of curves (series) in a graph ?
In article <79axf.14930$W03.firstname.lastname@example.org>,
> What is the maximum number of curves (series) in a graph ?
Check XL help for 'Excel specifications and limits' (w/o the quotes).
It contains a section on 'Charting specifications'
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
Charting limits are,
Data series in one chart 255.
Data p...Scatter graph with text as marker ?
How do I replace the data point markers (diamond, star etc.) with
text which is unique for each data point?
Example .. Lets say we have this dataset:
Name: Alfa Beta Gamma
X: 1 2 3
Y: 2 4 8
The goal is to replace the ordinary markers with
the word "Alfa" for the point (1,2), "Beta" for
the point (2,4) and so on... ?
How about adding the alfa, beta, etc. as data labels (use Rob Bovey's
XY Chartlabeler available from www.appspro.com). Center the labels and
set the marker to none (double-click the plotted series, then the
Tush...How do I change the order of items in a graph legend?
Hello, I am trying to create charts for different timframes, have listed the
data in similar fashion in two different spread sheets. When I create
graphs, the order of legend is not identical in the two graphs. It needs to
be consistent. Appreciate any help along these lines.
You can use the series order option in the format dialog to change the
order. Double click a series to display the format dialog.
Note though that the series need to be of the same chart type and on the
same axis in order to manipulate the series order.
> Hello, I am...How to correct wrong investment type in Money2004
In my hast I incorrectly labeled one of my mutual funds
as a money market investment type. How can I correct
this fund back to a mutual fund type? "Details" of the
fund shows the investment type as Money Market but offers
no apparent way to change it. Thanks.
"Ed Haynes" <email@example.com> wrote in message
> In my hast I incorrectly labeled one of my mutual funds
> as a money market investment type. How can I correct
> this fund back to a mut...polynomial formula for a line graph...
I haven't looked at this feature in a couple of years.
Excel can give you the formula for a charted function...
what I mean is, given a few data points, it can create a
best fit curve, and display the function that it used to
Would someone remind me where, please?
Right click the data series and pick Add Trendline.
From the dialog you can choose the type of trend line and whether to
display the formula.
> I haven't looked at this feature in a couple of years.
> Excel can give you the formula for ...Line Graph with 2 lines
I am trying to make a line graph with 2 lines, each with its own separate
x-axis and y-axis values. I've tried but cannot seem to do this. Any help
would be great.
50 50 55 45
25 25 32 23
12.5 12.5 17 15
6.25 6.25 9 8
3.125 3.125 6 3
1.5625 1.5625 3 3
0.78125 0.78125 1 2
These are the two lines I'm trying to graph, with the x-axis being on the
left and the y-axis on the right.
"Need help making line graph with 2 lines" <Need help making line graph with
2 firstname.lastname@example.org> wrote in message
news:B41ABFE8-4BA4-49E2-BEEE-94DC38FFF851@microsoft....Setting up retirement investment
In Money 2004 Premium, does anyone have a suggestion for
setting up IRA mutual fund investments? Is it best to set
up an account called "Retirement Investments" and add IRA
investments to that account or is it best to create
individual accounts for each IRA investment?
It's best to create an IRA Account in Money to match each real-world IRA
account that you have. In my case, I have four: one traditional, one Roth
for both my wife and I to match our four corresponding accounts at Fidelity.
"Mike" <email@example.com> wrote in messa...excel chart showing movable graph at what point we make a profit
in a business would like to make a chart based on accumulated Earnings &
Profit/Loss for year to date, perhaps movable showing our break even point
and by moving chart to a another earnings figure what profit we should make.
For example put in earnings for YTD Profit/Loss YTD then I can move the
earnings part of the chart to show what our profit would be for a given
If For example if we earn $200 for year so far and profit is $0 but any
amount over that is 18% profit so I can move chart line to say $240 and it
will say what profit I will make.
Hope ...How to fill the area between lines in graph
You do this using area charts.
Andy Pope, Microsoft MVP - Excel
"DExcel" <DExcel@discussions.microsoft.com> wrote in message
Two methods are:
(1) Area chart
(2) Error bars from calculations on the worksheet
"DExcel" <DExcel@discussions.microsoft.com> wrote in message
...How do I completely remove any record of a deleted investment?
In Money 2000, I sold an investment and deleted the investment. Now I have
again bought shares in that investment but Money won't let me give the
investment the same name as it had before. It tells me I can;t use that name
because it belongs to deleted investment. But I have to use the exact name in
order for the transaction download to work. Any ideas?
You can make the investment viewable by making a dividend transaction to
that investment from any account. Once you've done that, you should be able
to undelete it.
"Randy Bratton" <RandyBrat...Money does not let downloaded dividend payments be assigned to cash portion of Investment account
I am using Money 2004 Small Business. I download transactions from
Ameritrade for my Investment account that has stocks and some cash
accumulated mainly from dividend payments.
This version of Money does not let me assign the dividend payment
dollars to the cash portion of the account, it insists on using the
dividend dollars to buy the stock of dividend payer, for example GM
paid $100 as dividend, it is downloaded as such but I cannot
assign/accept these dollars as cash, Money forces me to buy GM stock
Anu advice how to tame Money to make it accept dividend dollars as
cash into th...Investments Disappearing
Money 2004 Standard
I have been investing for about 6 months now mostly consisting of stocks.
Naturally, I have a lot of stocks I no longer own. The problem I am having
is that older investments are no longer showing in the 'Your Portfolio'
page. I have the option checked to show closed positions. In fact, many of
my sold stocks are there. There are a few, however, that are not. I figured
that something may have happened to my file and the transactions were lost,
but when I went to the individual account's page and the cash account page,
all transactions are there. ...