100% stacked column chart shows wrong information
I wonder if someone can help me. I have created a table that tracks the
profitability of a particular project and I’m using the table as a source for
a 100% Stacked Column graph.
The source data for the graph is in three rows:
• B21:M21 - contain the names of the months from Nov – Oct
• B22:M22 - money taken in
• B24:M24 - profit
B23:M23 contains the money paid to supplier each month. I need this in the
table but I don’t need to show it in the graph. I just want to show profit as
a proportion of what we bill to customers on that project.
My problem is that the graph seems to show in...Queries and Charts
Does anyone know why the expressions in queries work fine for reports but not
...Multiple domains on one Exchange server / All but one domain shows up as spam #2
I am sorry if this is on the board somewhere but I have been searching
forever and havn't found a hint yet.
I have multiple domains setup on my exchange server. Lets say abc.com,
def.com, and hij.com. We only send email with @abc.com but can receive
from any domain name. Recently we merged with another company and we
brought back their email to our server, lets say xyz.com. Now I
configured a new recipient on Exchange 2003, so I now have two
policies. The first policy has the three original domains in it with
@abc.com as the primary domain. In the second policy I have configured
xyz.com t...VB Macro #2
I have a macro that is generating Excel files. When the macro runs, it saves
two different tabs in the workbooks as values. It needs to test and wait
until the formulas that are pulling amounts from another database are
correctly populated with the amounts.
Right now, I am getting N/A# instead of amounts for some, but not all, of
the files. I think the problem is that the formulas have not completed
pulling the amounts before the macro pastes that tab as zeros. (N/A# is what
appears when the formulas have not completed calculating - once they have
completed, the N/A# is replaced ...VCR to DVD Part 2
Many thanks for previous answers.
Yes, finalizing the DVD worked
I found that DVD-R need finalizing but DVD+RW disks do not
But why was I able to play the unfinalized DVD-R on one machine and not on
What was special about the first PC?
Bernard Liengme wrote:
> Yes, finalizing the DVD worked
> I found that DVD-R need finalizing but DVD+RW disks do not
> But why was I able to play the unfinalized DVD-R on one machine and not on
> two others.
> What was special about the first PC?
Almost anything will play a finalised D...Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data
columns. Can the data in the columns of a chart table be right justified?
In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf-
8?B?c2FtIGVhZ2xl?= <sam email@example.com> says...
> Ecxel 2003 and previous versions of the product center the data in the data
> columns. Can the data in the columns of a chart table be right justified?
Have you tried to format the table? If yes, and you haven't been
successful it is probably because XL allows very limited cust...set print area #2
Where is the "set print area" button in Excel 2002 that was in Excel '97?
> Where is the "set print area" button in Excel 2002 that was in Excel '97?
Are you sure it was "standard"? Only way I could get in was to right-click
the toolbar|Customise and drag it to the toolbar from Commands|File
...Updating a chart Automatically
Hi, i update a spreadsheet with new data from Access
everyweek. I have a chart that displays the last thrity
days, how do i do this automatically, so i dont have to
keep updating the chart manually ?
Thanks in advance Jay
Jay Richardson wrote:
> Hi, i update a spreadsheet with new data from Access
> everyweek. I have a chart that displays the last thrity
> days, how do i do this automatically, so i dont have to
> keep updating the chart manually ?
> Thanks in advance Jay
See www.tushar-mehta.com, Dynamic Charts.
dvt at psu dot edu
...Label a chart of counts with other percentage data
Here's the data:
Group 2005 2006 2007 LTM Data
A 19.4% 22.8% 21.2% 19.9% Profitability
A 6 7 7 7 Count
B 9.5% 31.6% 30.4% 30.7% Profitability
B 2 3 3 3 Count
C 22.4% 23.6% 16.6% 17.6% Profitability
C 15 16 17 18 Count
D 19.2% 20.5% 15.9% 13.7% Profitability
D 8 8 9 10 Count
I have successfully generated a stacked bar chart that shows the counts per
group by year.
Now I would like to include a label for each group to show profitability for
each group in each year in the 4 stacks. How would I do that?
--...line chart with NA() values
12 month line chart, with some values being 0.
I am using an if statement that turns any 0 values to #N/A so they do
not show on the graph (which is what I want).
My problem arises when the 0 values fall in the middle of my data.
So for example:
1) data for all months (Jan-Dec), the line shows across all 12
2) I have data for only 6 months (Jul-Dec), the line starts in Jul and
ends in Dec (perfect);
3) When I have data from Jan-Mar, and Oct-Dec, the line connects
between Mar and Oct. I want 2 distinct lines with no line where there
is no data (#N/A).
gri...OEM publisher 2002 Sp1-2
I have the OEM version of Publisher 2002 and cannot find the Export as web page under File. Is there a way I can get that feature with a standalone disk?
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from Chicagogal <firstname.lastname@example.org>...
> I have the OEM version of Publisher 2002 and cannot find the Export
> as web page under File. Is there a way I can get that feature with a
> standalone disk?
The OEM version of Publisher is exactly the same as the release in every way
but the license, so the standalone version will be no differen...How do I set up a 98% baseline across my chart?
I am trying to show on a bar chart the baseline that represents SLA
requirement of system up time of 98%. How do I do this?
You can find information on adding a datum line here.
Andy Pope, Microsoft MVP - Excel
"Deb" <Deb@discussions.microsoft.com> wrote in message
>I am trying to show on a bar chart the baseline that represents SLA
> requirement of system up time of 98%. How do I do this?
...GP SP#2 hangs with sa and Collections Issue
I just installed 8.0 SP#2 (ran the script that it says to run cuz we had
upgraded from previous version to remove dups in smartlist tables) and when I
log into GP as sa, it hangs and CPU sits at 100%.
When I was able to log in previously to SP#2, I constantly received errors
about the CN_Collector_MAIN table with invalid column names etc. I've
deleted the table, then re-ran the create tables, but it keeps coming back
with this error. I've even gone into file > maintenance > sql and deleted
and recreated the table, but then get "number of results doesn't match ...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...Changing ip address of exchange server #2
I have a back-end server and a smtp server in DMZ.
I want to change ip address of back-end server. are there any issues?
all incoming and outgoing emails are going via smart host.
No issues at all as long as you remember to change all the references to
this server in your firewall, SMTP scanner etc.
"Jack Dorson" <JackDorson@discussions.microsoft.com> wrote in message
> I have a back-end server and a smtp server in DMZ.
> I want to change ip address of back-end server. are ...How can I print on 8 1/2"x17" paper?
I have cut down an 11x17 paper to 8 1/2" x 17". I cannot figure out how to
change the paper size to accept and print anything bigger than 14." any
suggestions would be greatly appreciated
First make the size settings in the Printer Setup. You may need to use the
"mickilena" <email@example.com> wrote in message
>I have cut down an 11x17 paper to 8 1/2" x 17". I cannot figure out how to
> change the paper size to accept a...when opening an excel file, 2 files open (one is book1)?
When I click on an excel file, 2 excel documents open up. One document is
called Book1 and the other document is the actual document that I want to
open. How do I stop this from happening?
To prevent Book1 from opening you can append /e to your shortcut for opening
"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e
Alternative to the above............
Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit> select "Open" and Edit.
If using WinXP OS you would scroll down to...Money Updates #2
Was wondering about money updates. What exactly is the program downloading
during the update process? And if the program is updated on a daily basis,
why would I ever need to upgrade to a newer version?
In microsoft.public.money, invalid wrote:
>Was wondering about money updates. What exactly is the program downloading
>during the update process? And if the program is updated on a daily basis,
>why would I ever need to upgrade to a newer version?
It is mainly changes in online bank setup.
Despite appearances is typically does not change anywhere daily.
"invalid" <...Can't create the item #2
I use Outlook from MS Office 2003 Business Edition.
Everything has worked fine until the past few days. Now,
whenever I click on an E-mail address link inside a
webpage, I get a message from Outlook that says "Can't
create the item."
One person on this group gave me the following advice:
>Close Outlook, find and rename the frmscache.dat to .old
I did searches on all my drives and the file named above
was not found. I doubled checked the search to confirm
that it included hidden files and system folders in the
search. Still no luck.
...Does POS 2.0 support price-embedded barcodes?
Does anyone know if Microsoft Point of Sale 2.0 supports price-embedded
barcodes (also known as random weight barcodes)?
I have Digi scales that print out 12-digit barcodes with UPC and price info.
I would like to implement POS and not RMS because it is much less complex.
Thanks for any info.
POS 2.0 does not support price-embedded barcodes.
> Does anyone know if Microsoft Point of Sale 2.0 supports price-embedded
> barcodes (also known as random weight barcodes)?
> I have Digi scales that print out 12-digit barcodes with UPC and price info.
&...Excel 2007 Line Chart
Is it possible to configure a line chart in Excel 2007 to ignore the
intervals and graph straight to the next value. For example if I have
Jan with the value 1000
Feb with the value 900
March with the value 500
April with the value 0
May with the value 0
June with the value 0
I want the March value to drop directly from 500 to 0 ignoring the
interval to April, I do not want a curved line it must drop directly
to zero then the line is straight across to April.
I have no idea if this is possible, any ideas?
On Tue, 11 Oct 2011 15:40:45 -0700 (PDT), TyreDu...Freeze the side column/top row & scroll others
what is the function to set (lock in or freeze) the first column and / or top
of a spreadsheet, so the words and numbers remain in the same place as you
scroll the other columns and rows.
(so you can add more columns..yet keep the main information in the first
In older versions of Excel, it is under Window.
In 2007 version of Excel, it is under View.
You first select a cell, then activate the command. Excel uses the selected
cell's upper left corner to define the freeze point.
Play with it. You can also Unfreeze panes that were fro...Chart Linking
How can a cell in one workbook be linked to data in another workbook.
try the following:
- open both workbooks
- in the target workbook enter the equatrion sign '='
- now select with your mouse the source cell in the other workbook and
"Kenneth" <firstname.lastname@example.org> schrieb im Newsbeitrag
> How can a cell in one workbook be linked to data in another workbook.
Or copy the source cell, select the target cell, choose Paste Special
from the Ed...IMAP address on exchange sever #2
how can I find the IMAP address of my exchange server?
I need help with the following:
I need to plot a 2-D column graph comparing the profit margin (y-axis)
for the 3 items (x-axis) for Malaysia and Singapore, using the data
Item Mfr's Agent's Retailer's Selling GST Profit Total
Cost Charge Markup Price Margin
Lipstick 9.85 15.76 12.81 38.42 1.54 27.03 105.40
Toner 11.90 19.04 15.47 46.41 1.86 32.65 127.33
Cleanser 15.90 25.44 20.67 62.01 2.48 43.63 170.13
Total 37.65 60.24 48.95 146.84 5.87 103.31 402.86
Item Mfr's Agent's Retailer's Selling GST...