DEADLINE... PLEASE HELP! Stacked Bar chart?

I'm not even sure how to ask the question so here's what I have...
                          2003              2004              2005   
                     Actual/Goal     Actual/Goal     Actual/Goal
Me                 1009/1061       591/866          658/897
Comp. A          966/1012       633/811          624/808
Comp. B          699/744         450/593          480/607
Comp. C          957/1005       642/821          665/838

I wanto to show a bar for each competitor, for each year, so there will be 4 
bars for each year.  Each bar showing Actual performance & Performance Goal 
in the same bar (diff colors).  For example, if Competitor A had a goal of 
100, but Actual Performance of 50, I want a bar that goes up to 100 with half 
of it (50%) in a different color - showing performance vs goal in the same 
bar.  How the hec do I do this???  I'll name my first born after you if 
you'll help!
0
ArmyGuy (1)
7/26/2006 2:18:02 PM
excel 39879 articles. 2 followers. Follow

1 Replies
259 Views

Similar Articles

[PageSpeed] 7

This is a multi-part message in MIME format.

------=_NextPart_000_002B_01C6B0A9.C7D38E90
Content-Type: text/plain;
	charset="Utf-8"
Content-Transfer-Encoding: quoted-printable

Hey Army Guy,

You need to set up your data table like this, where Goal is actually =
Goal - Actual (from your original data).  Excel ADDS the numbers when =
doing a stacked bar chart, so you need to use a difference for the Goal =
numbers.  Note that this table is 7 columns by 13 rows, with one row or =
headers and one column of labels. Each group of data is offset from all =
the others, and the rest of the cells are blank.  You can either use =
stacked bar or percentage stacked bar charts.

     Actual 2003 Goal 2003 Actual 2004 Goal 2004 Actual 2005 Goal 2005=20
      Me 1009 52    =20
      Comp A 966 46    =20
      Comp B 699 45    =20
      Comp C 957 48    =20
      Me   591 275  =20
      Comp A   633 178  =20
      Comp B   450 143  =20
      Comp C   642 179  =20
      Me     658 239=20
      Comp A     624 184=20
      Comp B     480 127=20
      Comp C     665 173=20

=20
HTH,
Bernie
MS Excel MVP


"Army Guy" <ArmyGuy@discussions.microsoft.com> wrote in message =
news:EA3CFBBE-CACD-4F0E-8419-D93CD7D1EB9D@microsoft.com...
> I'm not even sure how to ask the question so here's what I have...
>                          2003              2004              2005  =20
>                     Actual/Goal     Actual/Goal     Actual/Goal
> Me                 1009/1061       591/866          658/897
> Comp. A          966/1012       633/811          624/808
> Comp. B          699/744         450/593          480/607
> Comp. C          957/1005       642/821          665/838
>=20
> I wanto to show a bar for each competitor, for each year, so there =
will be 4=20
> bars for each year.  Each bar showing Actual performance & Performance =
Goal=20
> in the same bar (diff colors).  For example, if Competitor A had a =
goal of=20
> 100, but Actual Performance of 50, I want a bar that goes up to 100 =
with half=20
> of it (50%) in a different color - showing performance vs goal in the =
same=20
> bar.  How the hec do I do this???  I'll name my first born after you =
if=20
> you'll help!
------=_NextPart_000_002B_01C6B0A9.C7D38E90
Content-Type: text/html;
	charset="Utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.2900.2722" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Hey Army Guy,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>You need to set up your data table like =
this, where=20
Goal is actually Goal - Actual (from your original data).&nbsp; Excel =
ADDS the=20
numbers when doing a stacked bar chart, so you need to use a difference =
for the=20
Goal numbers.&nbsp; Note that this table is 7 columns by 13 rows, with =
one row=20
or headers and one column of labels. Each group of&nbsp;data is offset =
from all=20
the others, and the rest of the cells are blank.&nbsp; You can either =
use=20
stacked bar or percentage stacked bar charts.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>
<TABLE style=3D"WIDTH: 474pt; BORDER-COLLAPSE: collapse" cellSpacing=3D0 =

cellPadding=3D0 width=3D631 border=3D0 x:str>
  <COLGROUP>
  <COL style=3D"WIDTH: 48pt; mso-width-source: userset; mso-width-alt: =
2340"=20
  width=3D64>
  <COL style=3D"WIDTH: 77pt; mso-width-source: userset; mso-width-alt: =
3766"=20
  width=3D103>
  <COL style=3D"WIDTH: 65pt; mso-width-source: userset; mso-width-alt: =
3145"=20
  width=3D86>
  <COL style=3D"WIDTH: 77pt; mso-width-source: userset; mso-width-alt: =
3766"=20
  width=3D103>
  <COL style=3D"WIDTH: 65pt; mso-width-source: userset; mso-width-alt: =
3145"=20
  width=3D86>
  <COL style=3D"WIDTH: 77pt; mso-width-source: userset; mso-width-alt: =
3766"=20
  width=3D103>
  <COL style=3D"WIDTH: 65pt; mso-width-source: userset; mso-width-alt: =
3145"=20
  width=3D86>
  <TBODY>
  <TR style=3D"HEIGHT: 19.5pt" height=3D26>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; WIDTH: 48pt; BORDER-BOTTOM: #c0c0c0; HEIGHT: 19.5pt; =
BACKGROUND-COLOR: transparent"=20
    width=3D64 height=3D26></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; WIDTH: 77pt; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: =
transparent"=20
    width=3D103><FONT face=3D"Comic Sans MS">Actual 2003</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; WIDTH: 65pt; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: =
transparent"=20
    width=3D86><FONT face=3D"Comic Sans MS">Goal 2003</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; WIDTH: 77pt; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: =
transparent"=20
    width=3D103><FONT face=3D"Comic Sans MS">Actual 2004</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; WIDTH: 65pt; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: =
transparent"=20
    width=3D86><FONT face=3D"Comic Sans MS">Goal 2004</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; WIDTH: 77pt; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: =
transparent"=20
    width=3D103><FONT face=3D"Comic Sans MS">Actual 2005</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; WIDTH: 65pt; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: =
transparent"=20
    width=3D86><FONT face=3D"Comic Sans MS">Goal 2005</FONT></TD></TR>
  <TR style=3D"HEIGHT: 19.5pt" height=3D26>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 19.5pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D26><FONT face=3D"Comic Sans MS">Me</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">1009</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">52</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD></TR>
  <TR style=3D"HEIGHT: 19.5pt" height=3D26>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 19.5pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D26><FONT face=3D"Comic Sans MS">Comp A</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">966</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">46</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD></TR>
  <TR style=3D"HEIGHT: 19.5pt" height=3D26>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 19.5pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D26><FONT face=3D"Comic Sans MS">Comp B</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">699</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">45</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD></TR>
  <TR style=3D"HEIGHT: 19.5pt" height=3D26>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 19.5pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D26><FONT face=3D"Comic Sans MS">Comp C</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">957</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">48</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD></TR>
  <TR style=3D"HEIGHT: 19.5pt" height=3D26>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 19.5pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D26><FONT face=3D"Comic Sans MS">Me</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">591</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">275</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD></TR>
  <TR style=3D"HEIGHT: 19.5pt" height=3D26>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 19.5pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D26><FONT face=3D"Comic Sans MS">Comp A</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">633</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">178</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD></TR>
  <TR style=3D"HEIGHT: 19.5pt" height=3D26>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 19.5pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D26><FONT face=3D"Comic Sans MS">Comp B</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">450</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">143</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD></TR>
  <TR style=3D"HEIGHT: 19.5pt" height=3D26>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 19.5pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D26><FONT face=3D"Comic Sans MS">Comp C</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">642</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">179</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD></TR>
  <TR style=3D"HEIGHT: 19.5pt" height=3D26>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 19.5pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D26><FONT face=3D"Comic Sans MS">Me</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">658</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans =
MS">239</FONT></TD></TR>
  <TR style=3D"HEIGHT: 19.5pt" height=3D26>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 19.5pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D26><FONT face=3D"Comic Sans MS">Comp A</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">624</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans =
MS">184</FONT></TD></TR>
  <TR style=3D"HEIGHT: 19.5pt" height=3D26>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 19.5pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D26><FONT face=3D"Comic Sans MS">Comp B</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">480</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans =
MS">127</FONT></TD></TR>
  <TR style=3D"HEIGHT: 19.5pt" height=3D26>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 19.5pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D26><FONT face=3D"Comic Sans MS">Comp C</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"><FONT=20
      face=3D"Comic Sans MS"></FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT face=3D"Comic Sans MS">665</FONT></TD>
    <TD class=3Dxl24=20
    style=3D"BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: =
#c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"=20
    align=3Dright x:num><FONT=20
face=3D"Comic Sans MS">173</FONT></TD></TR></TBODY></TABLE></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;<BR>HTH,<BR>Bernie<BR>MS Excel=20
MVP</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>"Army Guy" &lt;</FONT><A=20
href=3D"mailto:ArmyGuy@discussions.microsoft.com"><FONT face=3DArial=20
size=3D2>ArmyGuy@discussions.microsoft.com</FONT></A><FONT face=3DArial =
size=3D2>&gt;=20
wrote in message </FONT><A=20
href=3D"news:EA3CFBBE-CACD-4F0E-8419-D93CD7D1EB9D@microsoft.com"><FONT =
face=3DArial=20
size=3D2>news:EA3CFBBE-CACD-4F0E-8419-D93CD7D1EB9D@microsoft.com</FONT></=
A><FONT=20
face=3DArial size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>&gt; =
I'm not even sure=20
how to ask the question so here's what I=20
have...<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;=20
2003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;=20
2004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;=20
2005&nbsp;&nbsp;=20
<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Actual/Goal&nbsp;&nbsp;&nbsp;&nbsp; Actual/Goal&nbsp;&nbsp;&nbsp;&nbsp;=20
Actual/Goal<BR>&gt;=20
Me&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;=20
1009/1061&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
591/866&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
658/897<BR>&gt;=20
Comp. A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
966/1012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
633/811&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
624/808<BR>&gt;=20
Comp. B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
699/744&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
450/593&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
480/607<BR>&gt;=20
Comp. C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
957/1005&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
642/821&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
665/838<BR>&gt;=20
<BR>&gt; I wanto to show a bar for each competitor, for each year, so =
there will=20
be 4 <BR>&gt; bars for each year.&nbsp; Each bar showing Actual =
performance=20
&amp; Performance Goal <BR>&gt; in the same bar (diff colors).&nbsp; For =

example, if Competitor A had a goal of <BR>&gt; 100, but Actual =
Performance of=20
50, I want a bar that goes up to 100 with half <BR>&gt; of it (50%) in a =

different color - showing performance vs goal in the same <BR>&gt; =
bar.&nbsp;=20
How the hec do I do this???&nbsp; I'll name my first born after you if =
<BR>&gt;=20
you'll help!</FONT></BODY></HTML>

------=_NextPart_000_002B_01C6B0A9.C7D38E90--

0
Bernie
7/26/2006 3:51:07 PM
Reply:

Similar Artilces:

VBA Worksheet Event Change or Selection Question, please assist me
Two fantastic people were kind enough to provide me these two codes below, and now I'm trying to see if I can expand it to include other columns and data in a worksheet. Code 1: Private Sub Worksheet_Change(ByVal Target As Range) Dim myC As Range If Intersect(Target, Range("P:P")) Is Nothing Then Exit Sub Application.EnableEvents =3D False For Each myC In Intersect(Target, Range("P:P")) Range("Q" & myC.Row).Value =3D Date - Target.Value Next myC Application.EnableEvents =3D True End Sub Code 2: Private Sub Worksheet_Change(ByVal Tar...

Combine Bar with Single Line Chart
Hello, Please can someone help me with this question. I am trying to create a bar chart with a single line chart. The bars will display the totals for various years i.e. 2004 104 2005 107 2006 108 2007 110 2008 101 The line chart will show how 2008 is performing on a weekly basis i.e. 01/01/2008 = 100 07/01/2008 = 101 14/01/2008 = 102 The bar chart for 2008 will reflect this also, updating each time a new week is added. The Y Axis I will assume display a total i.e. 99-111 for example. The X Axis needs to show the dates plotted for the line chart 01/01/2008 - 31/12/2008 (weekly) but how...

Routing Engine not starting, please help ASAP
Exchange and Windows 2003 I cannot get the Exchange Routing engine to start up. Upon startup I get an event ID 7023 telling me that the path is not found. Everything else works and starts up just fine, people can open mailboxes, but cannot send/receive emails. I read online that it sounds like the metabase.bin file is corrupted. I uninstalled/reinstalled IIS, reinstalled Exchange 2003, and have reinstalled Exchange 2003 SP1, everything works except that I still cannot get the routing engine to kick back on. Any suggestions! Thanks! Was this an OEM preinstall? I recently bought a ser...

Help Microsoft Office 2003
After now using Microsoft Office 2003 for about 3 months now, have suddenly noticed that my email messages have just started showing strange symbols for certain punctuation. This does not show as I type... but the recipent sees these symbols when the message is received. I can see it when they reply back. The strange symbols show for the apostrophe and sometimes for the exclaimation. I do not recognize the symbols. I do not have caps lock on, do have number lock on. None of the symbols show on my keys. Help?! Thanks! Kim it's caused by character encoding. What email client and...

.pst folder help
How do I put a .pst folder in My Documents for constant up to date copying? Mine seems to be in a folder called Office Data File which I cannot open but do not see any pst file...can someone kindly help me out here? Thanks! Right click the pst in outlook and select properties and then click Advanced You will see the location of the file. Depending on your view settings it may be hidden. Close the pst, (right click it, close) Move the file to the location you desire. Open Outlook select File - Open - Outlook Data File Browse to the file and select it. OK Done Regards Mark Dormer &quo...

illegal name? [noobie, please be gentle]
re: xl2k I am attempting to name a column as "fy2007" xl refuses to accept this. Why? Note that "fy2007" appears to satisfy all the naming guidelines, as listed in the help file. Also note, "fy_2007" is acceptable. cheers, jw FY2007 looks like a cell in column FY in row 2007. You could name it FY_2007 or _FY2007 Or most anything that doesn't look like an address. mr_unreliable wrote: > > re: xl2k > > I am attempting to name a column as "fy2007" > > xl refuses to accept this. Why? > > Note that "fy2007"...

Help with macro to choose printer
Hi, I am new to macros in Excel and this is what I did to print a worksheet: ------------------------------------------------------------------------ Range("A1:W35").Select ActiveSheet.PageSetup.PrintArea = "$A$1:$W$35" Selection.PrintOut From:=1, To:=1, Copies:=1, Collate:=True End Sub ------------------------------------------------------------------------ Works great except that I want to select the printer to use and the macro won't stop at the point to choose printer. Any way to work around this? Any help is greatly appreciated. Emilio Emilio,this wil...

Help with an expression to calculate a profit from one of three fi
Using Access 2003 SP3 - in Forms I know I'm probably asking a very complex question, so a very big THANK YOU to whomever can help. I am doing a detailed inventory and need help with an expression in my form that will calculate my profit based on one of three fields. Only one field would have the end data. To clarify what I am working with: Most stock items come by the "unit" and contain multiple "subunits" which, in turn, contain smaller "pieces." However, some "units" only come with "subunits" and some only come as &quo...

Excel Tool Bars
Lately, when I open Excel, the top Excel name bar and the bottom tool bar are not on the screen. It appears that the worksheet is too large to be contained on the screen. Hi Bailey, Can't tell from your description, so just trying to grasp at straws.. -- are the toolbars floating, if so drag to correct position so the become docked Applies to toolbars but not the name box and address bar. -- do you have problems in other applications, i.e. Display settings, screen resolutions -- is the zoom control at 100% -- What happens in Full Screen mode and in restore (buttons upper right...

Changing Chart SourceData in VBA
Excel 97. Can anyone spot where I'm going wrong? I'm trying to change the source data in code so it only shows upto the last cell that has a value in it. My code at the mo is.. Dim intActiveCell As Integer Dim strCell As String Dim strrange As String Sheets("Financial Tracker").Select Range("C13").Select If ActiveCell <> "" Then Do Until ActiveCell.Value = "" ActiveCell.Offset(0, 1).Select Loop End If ActiveCell.Offset(0, -1).Select 'Selection.End(xlLeft).Select strCell = "R" & ActiveCell.Row & "C" &...

import chart of acount
I use GP7.5 I export chart of account to excel sheet and modify but i don't know how i can import agine to new company please is there any way to make it this. thanks for help M.Own If you have Integration Manager, then you would find it to be the easiest tool to use. If you do not have it, then the data can be loaded using SQL Server tools and other products that work with SQL Server. However, if you are not familiar with these tools, you should get help from somebody who does. -- Charles Allen, MVP "M.Own" wrote: > I use GP7.5 I export chart of account to e...

switching investment charts in microsoft money plus deluxe
I'm using Microsoft Money Plus Deluxe 17.0 As in Money 2004 clicking on a listed investment on the Home tab goes directly to a price chart. In the earlier program I could switch quickly between investment charts using a drop down list on the chart page. In money plus deluxe 17.0 I have to go back to Home first or the Portfolio tab. Can I make this work as before? Thanks for any help. "Dave K" <p_sellars-at-hotmail-dot-com> wrote in message news:eqMaGmEcIHA.4712@TK2MSFTNGP05.phx.gbl... > > I'm using Microsoft Money Plus Deluxe 17.0 > > As...

Help with Lookup #2
I have an excel worksheet that has approximately 20,000+ records. I would like to classify these recorded based on two columns. The first column's name is "YB Description" and the other is "Sold Date". The YB column mainly contains 4 digit numerical values, with approximately 300-400 records that are text, ie. "classified", "not verified", "public use". The Sold Date column is pretty self-explanatory, all the records are dates with the following formatting - M/D/Y. What I would like to do is create a third column called YB/Sold that classi...

Help with ACT! to CRM migration
Hi to anyone that can help. I am trying to do a trial data migration from our ACT! database to MSCRM to see what it will look like. I have installed the migration framework and appear to have CRM running fine on a server in our network (no errors on install and all windows appear ok). Since I do not have a strong database background I was wondering if someone could confirm what I believe is MS's way of migrating my data accross. I have exported the data from ACT! to a text file. I imported this into excel and repleaced the Free/busy data with a unique number for each record. I the...

Multiple 2d charts in a 3d display
I'm trying to get a visual representation of a database of info regarding loan analysis using a line graph. I want the data to show line items of widely varying values, and the lines I have come out flat in some instances because the y-axis is calibrated for up to six figures for some values, but single digits for others. Is there any way to create several 2d charts, then "stack" them up on a non-contiguous z-axis? ...

Enhancing pie chart with pointers
Belated thanks to Andy Pope for guidance on my problem, which was to display two 'needles' on a circular chart - like a traditional barometer - and to colour the sector appropriately. This post is also to record the points I needed to understand, to assist others. 1. 'Chart Type' belongs to a series, not the Chart. (This isn't evident from the user interface, although I guess the pre-assigned combination charts presented offer that promise.) So a pie chart and an X-Y chart may be happily belong to the same chart object. 2. The axes of such a combination pie chart / X-Y ...

Need help backing up OL2002 items (or folders)
HELP says: "If you want to create a folder to which you can drag items for safekeeping or to distribute to another computer. Create a new data file (.pst) and drag items to it. If you used the default name for the folder when you created the data file, the folder will be called Personal Folders . In the Folder List (Folder List: Displays the folders available in your mailbox. To view subfolders, click the plus sign (+) next to the folder. If the Folder List is not visible, on the View menu, click Folder List.), drag any item from your current folders to the new folder. Press CTRL...

Help with Links to Files
Hello, I have a file in Word 97-2003 compatibility mode. When I select the Office Button / Prepare I see an option to Edit Links to Files. If I convert the file to 2007 format the option for Edit Links to Files is no longer there. Where did they go? thanks, mitch This is strange. The Edit Links to Files option should be available even if you save in Word 2007 format. Are you sure you didn't inadvertently break the link to the automation object? You could press Alt+F9 to see that the field code for the object is still intact. (Note that you can only see the field co...

Pie charts #11
I am trying to create a pie chart to add up to 100%. I have 2 values which I have calculated as students results from tests and I would like to have a third series which is 100-(the 2 test figures). Can this be done on a pie chart series range or must I add another cell on the spreadsheet to calculate this option and then uses these 3 figures as the series for the pie chart. Hi, You need to calculate the 3 values before charting them. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "HillsinHolland" <HillsinHolland@discussions.microsoft.com> ...

Problem with empty cells when creating chart using vba
Hello, I am facing difficulties to create a chart from a sheet containing empty cells (I use Excel 2003 SP2). My sheet looks similar to this: A B C 1 0.1 2 0.2 25 34 3 0.3 23 27 4 0.4 24 6 5 0.5 25 16 6 0.6 27 21 7 0.7 Column A contains data (some depth in my case). Each cell in column A contains data. Column B and C contain some measurements made at the depth indicated in column A. I need to combine two graphics on one chart: the content of B in function of A and the content of C in function of A. The ...

Flexible Y-Axis in a Waterfall chart
Hi, I have created a waterfall chart based on the following website http://peltiertech.com/Excel/Charts/Waterfall.html The chart shows the changes from Budgeted Revenue to Actual Revenue. Problem : The chart is based on revenue numbers on a regional level with a drop down to select any country within the region also. For eg. The Budgeted Revenue is $50m with a variance of +/-2m to arrive at Actual Revenue. Inorder to amplify the impact of the changes, I have set the Y-axis scale to start at $47m. The changes (Plus and Minuses) become too small to have any impact if the scale is set to sta...

password
Hi I have problem with Microsoft Outlook XP. Very often Outlook won't remember the password. Thx I am having a similar problem. Using Outlook 2002 (XP). I have several POP3 accounts, and Outlook requires the passwords every time. I've tried everything, and it still forgets them. Thanks to anyone that can help. >-----Original Message----- >Hi >I have problem with Microsoft Outlook XP. Very often >Outlook won't remember the password. > >Thx >. > Earlier reply had the incorrect e-mail address. This address is correct. Jim V >-----Original Mess...

Customizing Chart Type
I have a a data that has 6 series or coloms of information - I need to create a bar chart that stacks the first 5 series and will allow me to have a line series. The options in the present custom template - only allow for a non-stacked bar...Can anyone tell me how to do this? JD So make your own combination chart. Make a stacked column chart with all of the data, then select the one series you want to change, choose Chart Type from the Chart menu, and select a different chart type for that series. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Ex...

Help w/ Accounts
Hi, I have Outlook 2003, I used to have four email accounts in Outlook. One of those accounts was set up to check the email but leave the original in the server. It was working fine until all of a sudden it started downloading the same email twice and deleting it from the server. I deleted the account from Outlook, but it is still downloading the email from that account. I went to Email accounts and I don't see that particular email account listed there. Does anyone have any idea how to get rid of this "invisible" email account that does not show up in the email accounts an...

two charts on one chart page
Hi, I have made multiple line charts and have placed them each in their own chart sheet. I am trying to figure out if it is possible to have 2 or even 4 charts posted in one chart page. The only way I see to do this may be to copy and paste and resize the charts or possibly to paste them in the worksheet. I ultimately just need to be able to print out 2 or 4 charts on a page. thanks kd a �crit : > Hi, > > I have made multiple line charts and have placed them each in their own > chart sheet. I am trying to figure out if it is possible to have 2 or even 4 > charts p...