Weekly bar charts assumes i mean daily bar chart
I'm trying to creat a simple bar chart that shows open tickets and
closed tickets week by week. I have 3 weeks of data and the bars
themselves are ok (20 open 6 closed). However, when using the date as
the horizontal axis, Excel inserts the 6 days of the week between each
miles stone. So, if I want to see the number of tickets each Monday,
Excel creates the chart with all the other days of the week, which have
no data. I'm left with 3 bars standing apart. How can I get each
Monday to stand next to each other and hide the intevening days?
P.S. The cells the chart is ba...Show goal in chart
I have the months in column A and the data in column B. I am doing a bar
chart - everything working fine. Now I need to add the goal as a line going
across the chart. How would I do this?
For instance, the goal is 50. So I want a line going across the chart at 50.
Thanks in advance.
Here are some examples
> I have the months in column A and the data in column B. I am doing a bar
> chart - everything working fine. Now I need to add the goal as a li...Converting Mutual Fund Acct To Brokerage Acct at Fidelity
I changed the my wife's IRA at Fidelity from a mutual fund account which
holds only mutual funds and cash to a brokerage account which also holds
stocks, bonds, etc. Fidelity handles the conversion by creating a new
brokerage account, transferring assets from the the mutual fund account
account into it, and then closing out the old account. If I handle it the
same way in M04, what happens to the historical transaction data? Does it
transfer over to the new account or stay with the closed brokerage account?
That is all.
It would stay with the closed IRA account, bu...Combination charts
Am having a problem with combination charts. Excell insists on dirtributing
8 sets of data evenly as 4 blocks and four lines.
Am aware of secondary axis and have one, but reallocation of data set to
secondary axis results in a very wide block rather than a line.
Also allocating a set fron sec. to primary axis has no effect. The plot
stays as a line.
Have tried using the combination alternative on offer in the program, and
have also tried the custom alternative, but to no effect.
Any ideas greatfully received.
Right-click on the series, and choose Chart Type
Select Line chart, click O...automaic "nice" display of the labels in a pie chart
I have a simple but very annoying problem:
Let's say you have a pie chart linked to a 2 cols/5 rows array.
I display the labels, the % and the value for each part of the pie.
My problem is the following:
Each time the data are updated, the pie is rebuilt but the labels ar
sometime out of the windows, sometime one on the other... in one word
So my question is the following : is there any way of "automati
readable arrangement" option in excel ?????
:confused: :confused: :confused:
Thanks to all
------------------------------------------------...mutual funds arbitrary value
My US Bank 401k allows me to buy First American Mutual Funds. However, they
set an arbitrary share price value which doesn't jive with the actual mutual
fund value. There are no download features either. Any ideas on how to factor
out this mess?
Isn't that the US Bank sweep vehicle? Is this an actual investment, or just
"The Glidster" wrote:
> My US Bank 401k allows me to buy First American Mutual Funds. However, they
> set an arbitrary share price value which doesn't jive with the actual mutual
> fund value. There are no download features...Waterfall chart difficulties
I have constructed a waterfall chart to show accounting data. The chart has a
line representing the positive final figure as a benchmark. The data starts
below this line then goes negative, returning to positive and finally
equalling the benchmark. The chart i have constructed is essentially static
despite attempts to make it update from a table - this just causes the whole
thing to fall apart. In order to get the chart to work in static form I had
to set the line to be the x axis so the chart does not cross the x-axis. Is
there a way of setting this type of chart up to update from a t...Portfolio
I am suddenly experiencing problems with MSN Money updating certain fund
prices properly. I think (but am not sure) that the problem is that it is
putting the decimal point in the wrong place (for example, £9,560.95 is being
shown as £95.60 because the price is wrong by two decimal places). It does
not happen with all funds, but with some.
Is anyone else experiencing the same problem? Does Microsoft know about it?
> I am suddenly experiencing problems with MSN Money updating certain fund
prices properly. I think (but am not sure) that the problem is that it
putting the de...Printing Excel Chart
After creating a line graph I tried to print only the graph. Print preview
shows the graph , but the first 8 inches of paper is blank., followed by the
first part of the graph. I am running Office 2007 with the latest updates
with XP. My printer works fine on other programs.
Was the chart active before you used Print Preview?
Bernard Liengme MVP
> After creating a line graph I tried to print only the graph. Print preview
> shows the graph , but the first 8 inches of paper is blank., followed by the
> first p...Excel Chart colors help
How do I create the faded color effect like the tornado chart example in
It's the orange and purple chart and the bottom of the page
paulabrozek's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30377
View this thread: http://www.excelforum.com/showthread.php?threadid=552751
Double click one of the sets of bars. On the Pattern tab of the format
dialog click Fill Effects. On the Gradi...How to include minor tick labels on logarithmic axes in charts
When I make a chart with a logarithmic axis (a xy chart with the y axis
logarithmic) I cannot get the minor tick labels plotted on the logarithmic
axis (I can get the minor grid lines). Is there a way to solve this?
XL's handling of a log scale is rather limited. You may be better off
simulating one. See
Flexible Log Scale
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <6EBFB1D9-35E2-4AAD-AF63-54A856F9F68B@...Keep Pivot Table custom chart type
I'm creating a pivot table custom chart type "Line - Column on 2 Axes". The
chart looks great when I create it. The problem is when the user does
anything to the chart (filters the data, adds a new flield of data, etc.),
the chart changes to where both data series are displayed as bar charts and
the second axis is gone. I can't find an event that fires when they modify
the chart, so I don't know that I can programatically change it back. Is
there a way to keep it from changing in the first place? I'm using Excel 2003.
Loss of formatting is a known prob...Charting help for a novice?
I have a value in Column A and a calculated value in column B
I want to plot column B on a chart, however where there is no data in A then
the chart plots B as a zero, but I don't want it to plot anything if there
is no data. Can anyone help this relative novice?
Thanks in anticipation
=if(A1,A1*14,NA()) should cure it on the chart.
If you don't want the NA# to show in your data sheet, you can hide it with
"Dave Jones" <firstname.lastname@example.org> wrote in message
I have Money 2005 Premium. I own a mutual fund which merged into another
mutual fund. Money will only process mergers on "stocks" owned. Any
suggestions on how to record this merger? I need to remove shares without
affecting the cost basis but cannot figure out to do it. As a last resort, I
will have to edit the number of shares of my original purchases to equal the
number of shares upon merger but this will be tedious since there have been
numerous reinvested dividends on a monthly basis.
"Roger K" <RogerK@discussion...charting equations
Is there a way to graph an equation without inputting x,
and the equation and charting the results?
[This followup was posted to microsoft.public.excel.charting with an
email copy to Jason.
Please use the newsgroup for further discussion.]
Stephen Bullen has one solution (visit
http://www.bmsltd.co.uk/excel/SBXLPage.asp#Charting for the
There is a solution on my site (see the Excel | Add-Ins | Plot Manager
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site
I need a way to select the color for the bars in a bar chart befor the
creation of the chart. I know how to select the colors once the chart is
created, is there a way to automatically change the chart colors?
You can change the default colours Excel uses for chart fills and lines
respectively, in Tools/Options/Color. The colours from left to right are the
ones Excel picks for your data series in order of selection. Select the
colour to be changed and click Modify... The rest is evident I gather. In
the same pane you can also import colours from another workbook (e.g., your
company...Adding a target line to two axes chart
I have created a two axes (line= yield (%) & bar= volume) chart & woul
like to add a target line (across y-axis) for targeted yield
Appreciate if anyone can help on this.
Thanks in advance
Message posted from http://www.ExcelForum.com
You can find so details on adding target lines here
Jovin < wrote:
> I have created a two axes (line= yield (%) & bar= volume) chart & would
> like to add a target line (across ...Calculate How Long Funds Will Last
I am not very good with financial worksheet functions and hope that someone
here can help. Is there a function that will return how long funds will last
if you earn a static interest rate and withdraw a static amount of money that
is more than the interest earned? Let's say, for example, the amount of
money is $1,000,000, the interest rate is 4% and the yearly withdrawal is
Microsoft MVP Excel
"ridgerunner" <email@example.com> wrote in message
news:EB...Functions and their Charts
Hi. In Excel it would be great to have sample charts of common functions
(e.g.: SIN, COS, LN, LOG, etc.).
In A1 and B1 enter heading such as X and Sin(X)
In columns A put a series of X values
In B2 use =SIN(A2) (or =LN(A2)); copy down the column and chart
Hold it! Did I tell you Excel's trig expects radians (the only REAL way to
So if you x-values are degrees we nee =SIN(RADIANS(A2)
remove CAPS in e-mail address
"Ana" <Ana@discussions.microsoft.com> wrote in message
news:B621F0F1-1795-4824...Money 2004 Prem. No Fund Matcher?
I'm running MS Money Premium 2004 on an up-to-date machine (latest and
greatest OS/Browser XP Home, SP2, IE
6, etc., all Windows-updated religiously). It seems that either the Fund
Matcher is no longer available or maybe there's a problem with my system.
I've been running MS Money for about a year, and last used Fund Matcher in
These days, when I go to look at the Fund Matcher it is hard to find; the
option only shows up when I have Money set up to use the default browser.
To get there from portfolio view, I select the 'research online' me...custom colors for pie charts
I have a pipe chart tracking resin colors. It would be nice to assign each
pie piece the color it represents. For instance, yellow resin has been
assigned a blue pie piece, blue has been assigned a purple pie piece, etc. I
have 13 colors to track. Any help would be greatly appreciated.
This would be helpful to know. I am confronted with a similar dilemma.
> I have a pipe chart tracking resin colors. It would be nice to assign each
> pie piece the color it represents. For instance, yellow resin has been
> assigned a blue pie piece, blue has been assigned...Charting in Columns
I have sales figures of two departments in columns on a monthly basis.
The third column is the monthly total for these two departments.
How can I show all this data in a single columnar chart?
For eg. 'A' sales figure for Jan is $500
'B' sales figure for Jan $1000
'C' total sales Jan is $1500
assuming that X axis is months and Y axis is amount in $
Is it possible to show this data in a columnar chart or any other type of
chart the way that I want to?
Many thanks in advance
Select only the data for your department sales (not to include the total
column) and create...Dates in chart
I have a chart that has data for Monday-Friday only of each week for 12
weeks. The dates are based upon a formula, so alternate every week showing a
rolling 12 week chart. Unfortunately, the chart is showing 5 days with 2
days for the weekend being blank as there is never data at the weekends and
so far attempts to rid the weekends, which are not in the original data at
all, have proved futile.
Can anyone suggest how to rid Saturday and Sunday from the chart?
All help appreciated.
You need to set the axis to be category rather than date.
Right click chart and pick Chart O...want to transfer out funds from a fund within an account to a fund within the same account.
I want to do this to preserve my cost basis. I have a 401k that lets
say has a fund that I bought for 100 bucks and it gained 10 dollars.
when I issue a buy/sell to transfer it to another fund (within the same
401k account) the new cost basis is 110 dollars instead of the 100 that
I actually spent. I know that using transfer in/out will preserve this
cost basis, but it doesnt seem to work within an account per other
threads of this nature.
How can I do something similar within the same account? I am using
I don't think your use of Cost Basis reflects tax la...mutual fund symbols
I have an IRA and a regular fund with the same mutual
fund. Money won't let me use the fund symbol twice. Is
there a work-around?
Thanks for any help.
On Sun, 8 Aug 2004 11:01:20 -0700, "Dena" <Denaf@hotmail.com> wrote:
>I have an IRA and a regular fund with the same mutual
>fund. Money won't let me use the fund symbol twice. Is
>there a work-around?
>Thanks for any help.
Your IRA account and Regular account should be set up as two separate
The mutual fund is then purchased within each account.
My IRA Account...