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
...pulling certain characters from a string of text
I need to look up "certain critera" within a string of characters, then
return that "certain criterea" to a new column.
Some examples of a strings of characters may look like these:
My "Certain Critera" I have listed on another sheet, named "REP ID"
How do I pull out the 3 characters of "Certain Criterea" from the string of
text and copy or enter it into a new column?
> I need to look up "c...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 firstname.lastname@example.org> 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...Data migration - Adventure Works
I have a company where the adventure works db has been used and had a
lot of data populated into the system. We have now purchased MSCRM and
have obtained the company reg keys.
What is the easiest way to get the data from the 1 system to the next?
We will be establishing a new AD domain and users for the new
Data Migration Framework?
Microsoft CRM MVP
"funboy...Mem leak when implement Singleton pattern on CWinApp derived class
Coded my MFC app to have singleton pattern, my code looks like this:
class CMyApp : public CWinApp
// static obj
static CMyApp* MyAppInstance;
// some other obj composed in this class
// private cons, I init the COtherObj here
obj = new COtherObj();
// only way to access cons
static CMyApp* GetInstance()
//check if already instantiated
if( MyAppInstance == NULL)
MyAppInstance = new CMyApp();
virtual int ExitInstance()
// I use ExitInstance to delete all ...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...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?
...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...cannot ping certain workstations through hostnames
We have a problem where certain pcs cannot be pinged through a VPN session.
Please note that other pcs that are in the same DHCP scope can be pinged from
a workstation connected to the VPN. I have tried to change the IP setting on
the affected workstations to NetBios over TCP/IP, but that didn't work. The
local windows firewall is disabled on all pcs (its set this way in group
policy), so that isn't an issue. I have flushed the DNS tables on the
"problem" pcs, but that didn't work either
I am at a loss here....anyone have any thoughts? Something in...XY Scatter Map with Test Labels
Sorry if this is a repeated request, but I'm trying to show the distribution
of 16 points (labelled A through P) using X-Y coordinates. When I turn on
labels, I can show either the X-positions (label) or Y-positions (value), but
I really want to show the text name "A" through "P". Can this be automated
Thanks for any advice.
The easiest thing to do is use a free addin utility to allow you to link
data labels to cells.
Try Rob Bovey's XY Chart Labeler add-in
Mike K. wrote...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...I Want a Warning Before Sending Email to Certain Contacts
Can someone tell me how to configure Outlook so that I will get a
warning message before sending email to certain contacts? For example,
I have certain contacts categorized as "adversary" or "client" and I
would like Outlook to make me confirm that I do, in fact, want to send
an email to anyone from those categories. The idea is to prevent
myself (and colleagues) from accidentally sending an internal email to
the wrong person because of Autocomplete, inadvertence, or some other
mistake. Thanks in advance. Extra points for a firm-wide
solution--something the s...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" <email@example.com> 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...Data validation list from another worksheet?
Is it possible that the value list for data validation be populated fro
puneetarora_12's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1840
View this thread: http://www.excelforum.com/showthread.php?threadid=38572
Sure is! Use a named range as described here:
"punee..."external data sources" and "external data ranges"
what is the difference between these?
i have run the vb macro code on http://support.microsoft.com/kb/330383 to
check if i have any external data sources or data ranges but there are none.
the reason i need to know is becuase i'm working with office sharepoint
server 2007 and i cannot access a file thru the web access web part because
"The workbook that you selected cannot be loaded because it contains the
following features that are not supported by Excel Services:
External data ranges (also called query tables)"
...Outlook 2003 on Exchange
despite of searching for days now, I couldn't find a solution to the
We are a 3-person team in a small news agency, that all three have
access to a mailbox that is hosted on an exchange system. We use
Outlook 2003 on our workstations.
If we get new emails, we sort the ones out that are worthy to read
later and drop them into a subfolder of that mailbox. Let's call that
subfolder "to_check". The chief editor then checks this folder once a
day and then deletes the emails or moves them further to other
Now, we have a new colleague in...Source data, in Chart Menu, is grey and not accessible.
I set up a pivot table and designed a chart, saved and closed out of the
workbook. Upon returning to work on this project, when selecting the chart
menu to work with my source data, the source data is grey and not accessible.
What might be causing this and can I correct it?
It's a pivot chart. As soon as it's created, it's linked permanently to the
pivot table, and you cannot change the source data. you cannot add more data
that's not in the pivot table to the chart, nor can you remove data that is
in the pivot table from the chart.
Jon Peltier, Microsoft...combination clustered column and stacked bar chart
I have data concerning the repair turn-around for three products over several
months. There are two components to the turn-around time for any item, i.e.,
actual labor time and wait time. I want to graph this as a clustered column,
each cluster representing the data for a given month and each bar in a
cluster representing one of the products. Now for the tricky part: I want
each of the bars to be stacked showing the relationship between the actual
labor time and the wait time.
I don't know if I'm fully understanding what you want. Possibly these two
examples can hel...Error in chart wizard
The following error occured in Excel 97:
-> User clicked on chart wizard
-> clicked the customer types tab and got the following
errors one after the other:
1st - Microsoft Visual Basic Permission to use object
2nd - Microsoft Excel Error accessing user-defined custom
3rd - Program error Excel.exe has generated errors and
will be closed by windows. You will need to restart the
program. An error log is being created.
This happened on more than one machine. I do not get this
error message on my machine. I have a screenshot of the
errors if it would help.
Has...How to run ajax implemented .Net 3.5 to an old version 2.0
I have developed a Web Application in .Net 2008 and implemented
<asp:UpdatePanel /> in it.
But now I am trying to build it in .Net Version 2.0.
But it gives an error -- "Error 1 Unknown server tag 'asp:UpdatePanel' ".
I have downloaded earlier version of AjaxControlToolKit, but it does not
What I have to do to build this code in version 2.0
Thanks and Regard
The UpdatePanel is not part of 2.0 or the Ajax Toolkit. This is an
additional "Ajax extension for 2.0" download...
Also as 3.5 is just 2.0 plus additional stuff, I wo...Chart of Accounts #4
We're looking to move to GP and currently have a 1 segment chart of account -
we would like to change to a multi-segemtn chart. Can anyone point me to some
documentation on ideas of how to set our chart up.
I've done many chart of accounts setups over the years. The format I
like is a 3 segment account number where the first segment is the
"division", the second segment is the "main" account, and the third
segment is the "department". Even if you don't need the "division"
segment now, you may in the future.
This format...Pasting html table to Excel reformats certain values
When I paste an html table into Excel some cells are automatically
formatted to a different datatype.
My html table contains identifiers such as "6632/04" which I want to
store as text. Excel assumes that data like this is some sort of date
and displays "apr-32" instead when I paste the table. If I try to apply
the text format to the column, Excel converts the values to some type
of integer "1728420" which looks like it could be the integer value of
the date. It isn't possible to get the original value back!
How do I turn off Excels automatic formatting...