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
325 Views

Similar Articles

[PageSpeed] 44

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:

Please Help!!! credit/debit card processing
I know there is way to set up the credit/debit card processing without actually using ICVERIFY or PCCHARGE. I am guessing you would have to emulate something but, I am not really sure on how it is done. Any kind of input will be greatly appreciated. RMS does come with an integrated Credit Card processing solution. Before you can set up Store Operations to process credit and debit card transactions through Citibank, you must have an Internet connection. Your connection must support SSL (Secure Sockets Layer) and HTTPS: (Port 443). Processing through Citibank does not support direct...

help with separate email accounts
hi- i have multiple email accounts with roadrunner- i've set up the accounts using the wizard On my Microsoft Outlook 200 sr-1 and entered all the pertinent info. however i don't know how to manage the accounts from the tool bar--in other words...i don't know how to check each and every email separtly. in my old Outlook Express 6.0., i would normally go to File-->Switch Identites---> and then i would select which email i wanted to go to--to write or read my Inbox....with my upgrade to Microsoft Outlook 2000 SR-1---i don't know how to do the same. I'm stuck ...

Help! error while installing CRM 3.0
Hi, During the installation of the CRM SBE 3.0 on SBS server 2003 premium, performing binary install of Microsoft CRM server components, I got en error, CRM 3.0 server setup failed, here is the last part of the crm30svrsetup.log. .... Installing MSCRM prepopulated data 08:49:50| Info| Creating indices in MSCRM database 08:49:51| Error| Install exception.System.Exception: Action Microsoft.Crm.Setup.Server.InstallDatabaseAction failed. ---> System.Data.SqlClient.SqlException: The Microsoft Search service cannot be administered under the present user account at System.Data.SqlClien...

Printing Pivot Table Pie Charts
I have 1400 names in a list each, person has their own data. I created a pivot pie chart to display that data. Can anyone tell me how to print the pivot table so I get a separate sheet for each name selected...without me having to click on the dropdown list each time? Also does anyone know how to hide a field, but have the data still be displayed in the pie chart? thanks ...

Seaside Helps Shutdown the MSBlaster Worm!
Seaside Helps Shutdown the MSBlaster Worm! Internet Worm Shuts Out Email Users On Monday, August 11th, a new worm was discovered infecting machines across the Internet. The worm is spreading rapidly by exploiting a Microsoft Windows DCOM RPC vulnerability. The worm spreads itself by attacking port 135, the port used by Outlook Exchange clients to connect to Microsoft Exchange servers. In an effort to stop the spread of the worm, many organizations, including numerous ASPs and ISPs, have shutdown Internet access to port 135. Unfortunately, this also shuts down Outlook clients using MAPI t...

Date prompt appearing twice due to chart in report
Hi All, I am creating a report based on a query. I have a prompt to ask for the Beginning Date and the Ending Date. When I run the query I get the correct results. I also get the correct results when I run the report. However, I have just added a pie chart in my report footer, and because of this, I am always forced to enter the beginning and ending dates twice when running the report. What do I need to do to make the prompt only appear 1 time for each date? Thank you! decklun The prompt appears each time Access needs to run the query. Once for the report and a second time for ...

Help with Transpose problem
I trade in the stock market & use excel to convert a list of ticker symbols to a csv file to import to a charting program. I start with a vertical list in excel, I copy then paste special & tell it to transpose. It seems if the list is too long I get an error message: "The information cannot be pasted because the copy area and the paste areas are not the same size and shape. Try one of the following: Click a single cell then paste. Select a rectangle that's the same size and shape, and then paste" I assume what is happening is that I don't have enough columns across...

Help! Money 2k4 wont work!
Everytime I try to run M2004, I get an error message, including restart M2004. But it will not load. Tried reinstalling etc... Nothing seems to work. Can anyone help me to get money 2004 up and running again? THANKS! And that error message would be............ "Malcolm" <anonymous@discussions.microsoft.com> wrote in message news:0e6201c3c685$018d66e0$a501280a@phx.gbl... > Everytime I try to run M2004, I get an error message, > including restart M2004. But it will not load. Tried > reinstalling etc... Nothing seems to work. Can anyone > help me to get money 200...

Angling Label Text on a Chart
I have a user with a Multi-Level Category Label on his chart. The label has the following data: 2 4 6 8 Nov-09 Dec-09 Jan-10 Feb-10 He's wanting the text to be aligned at an angle and so far I'm only able to get the top values to display at an angle and not both. Any ideas? -- -Karen Excel does not allow for changing the orientation of lower layers of multiple level labels. - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and...

Excel Chart How do I create Y axis to represent numbers I am using
I am attempting to create a chart that is populating its data from another worksheet in the same book. I am pulling in numbers that range from 75000 to 3000000 and I would like my y axis to be 50K to 350K in multiples of 25K but I can not figure out how to adjust the axis key. Thanks for your help in advance. Krefty Select the axis and press Ctrl+1 (numeral one). Excel 2003 and earlier: In the dialog that appears, click on the Scale tab, and enter the values you want for min, max, and major unit, and don't check the corresponding Auto boxes. Excel 2007: Check Fixed for each of mi...

Excel graphs should allow copy & paste of individual bar formats
In excel graphs - bar charts, I make the last bar a hashed shading as it is a forcast. To do this I select only the last bar and change its formating. At the end of the month I want to change the format back to the same as all the other bars and make the new coming month's predicted value that hashed shading etc. Unfortunately excel will not allow copy and paste in this situation - so I have do open the format tab etc and then change. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggest...

Date function help
I have order received date. I will start the order on the next comin THURDAY always. My delivery date is 9 days from the start. eg. Received date = 5/7/2004. Start Date is = 8/7/2004. Delivery dat will be 17/7/2004. Can somebody help with a formula to calculate delivery date. By the wa we are into furniture manufacturing. Thanks in advance, Itt -- Message posted from http://www.ExcelForum.com > ... My delivery date is 9 days from the start. > .. a formula to calculate delivery date. If col B contains the start dates, from row2 down just put in say, C2: =B2+9 (think Excel will fo...

Help Freezing Multiple Rows
In earlier versions, you clicked below the rows you wanted frozen in place or to the right of the rows you wanted frozen. Now I see only how to freeze row 1. I have a main title in row 1, row 2 is blank and row 3 has column headings, so I want row 3 to stay frozen in place. I am having trouble accomplishing this and need help, please. Thank you. -- Virgo click on cell A4 then on the menu bar Window/Freeze Panes "Virgo" wrote: > In earlier versions, you clicked below the rows you wanted frozen in place or > to the right of the rows you wanted frozen....

Data types
How do you mach the data type in excell with the data type in access? In excess I have have for SSN the category as special and type social security number, ans in Access I have the data type as" number". What can I do to get them to mach so I can update my records? Also with Zip code and Phone number in excel and "number" in Access. Andrew Hi it is generally accepted that zip code, phone number (maybe SSN, but i don't use these) are stored as TEXT in Access as you're not performing calculations with them and might like to store non-numeric symbols (e.g. t...

Error problem ?! Someone help ?
Account: 'Windows Mail', Server: 'pop3.live.com', Protocol: POP3, Server Response: '-ERR command not implemented', Port: 995, Secure(SSL): Yes, Server Error: 0x800CCC90, Error Number: 0x800CCC18 Try these settings: Live.com Settings: Server names and ports: POP3 = pop3.live.com Port = 995 SMTP = smtp.live.com Port = 587 Checkboxes you need to check include: Server Tab: "My server requires authentication" (Click "Settings" button also and fill in "Log on Using" email address - *** but do NOT check the ...

Budget Help for Refinance of Mortgage
Refinanced my mortgage in September. Closed the old mortgage and opened new mortgage. Under Budget Debt in the budget repoorts now totals the amount of the old mortgage payment plus the new one. Obviously would like to eliminate the old one...When actually using the budget module to set up budget only shows the new mortgage payment Any suggestions ...

Windows ME and excel compatibility Help!!!!!
I am in urgent need of some help!!! I have Windows Millenium on my computer and this came with Microsoft works. I hate it! It does not contain microsoft excel for some reason, only microsoft works spreadsheet. This program is horrible and will not do any of the functions that excel does. Does anyone know what I need to do to get some sort of version of excel 97? I see that you can get excel 2003 (very expensive) but I just need the oldest version that is compatible with most excel files out there. I am ina frantic state because I recently signed up for an online class that requi...

Help
Hi guys! I need a formula that does this: OK I'm going to draw a spreadsheet ......A..........B...... 1..100.....dog.... 2..150...<blank> 3..200......cat..... so all I want is a formula that looks in Column B and if there is ANY text at all, returns the value in Column A So I want it to look into B1 and it will see text there and return "100", but if it looks in B2 and sees that it is blank, it just won't return anything. Can I do this? Seems like it would be a combination of IF and LOOKUP or something. Thank you. -- Bran987 ----------------------------------...

Losing permissions in folders!! Help!
This is a multi-part message in MIME format. ------=_NextPart_000_0219_01C67A75.EE0C3EA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Since there are admins lurking here, i thought i'd post this here... Anyone else experiencing this problem? Subfolders all of a sudden losing permissions? IE. zero permissions; = you can't take control using administrator accounts. Notta!! I had = this happen on a Windows 2k Adv Server and also on a Win2k3 Server. Subsequently you can't access it at all.=20 What's going on here...

Help With Graphs
Are there any issues to be aware of when creating graphs that plot time formatted vales? I have 2 columns on a sheet. One contains date values and the other time. Some Date Some Time 31/08/2002 03:25.4 26/10/2002 03:22.5 23/11/2002 03:17.3 25/01/2003 03:12.1 22/03/2003 03:14.4 26/04/2003 03:10.5 28/06/2003 03:10.5 29/08/2003 03:16.0 19/09/2003 03:12.1 If I select the data in these two columns and click on the chart wizard to create a line graph and then finish, the output is a mess. I have to manually reset the data series names, values and x-Axis labels to get the outp...

Help with Proceedures 101
I opened a form in design view Clicked on View Code Saw... Option Compare Database then added the code below... Sub SayHello() MsgBox "Hello" End Sub with my cursor in the proceedure I tried F5 to Run the sub... But that opened a window window named "Macro" and asked for a Macro Name... my sub wasn't visiable as an option I tried F8 (Debug - Step Into) but same results What am I doing wrong? thanks for any help. Mel vba is not like vb, you need to trigger the code from and object. the play button dont run code it ask to run macro. if you want to start it with ...

Help Can't Find Automatic Security Settings in OL SP3???
I installed SP3 for MS Office 2003. I liked the feature in OL that prevented images from downloading unless you right clicked on them. I thought the settings were in tools->options->security but I could not find a place to set this useful feature. Did SP3 erase this feature or is it located somewhere else? TIA, Pete I was really stupid on this one. When installing Office, I grabbed the wrong set of disks by accident. I installed XP instead of 2003, and should have been tipped off by the different security patches. Sorry, Pete "Peter de B. Harrington" <peter.harr...

pediatric growth charts
I am looking for something such that I can supply a list of dates, heights and weights for a given baby, and the graph can automatically plot these data points onto the pre-set growth chart that may be printed out. Any suggestion? There's a template on the Microsoft site that you could download and modify: http://office.microsoft.com/en-ca/templates/TC010709401033.aspx?pid=CT101443491033 namsilat wrote: > I am looking for something such that I can supply a list of dates, > heights and weights for a given baby, and the graph can automatically > plot these data points onto the...

Scatter Charts
I am using Excell 2000 I feel like a dummy. While I use Excell on a regular basis, about 1 a month, I have not created a chart (graph) in Excell in years. Now I am trying to create a scatter graph of which I have never done. This is for our salary budget. I have been asked to show how many people are in each salary range percentile by wages. Example Emp #1, making $25000 may be in the 70% range for a specific classification, while emp #2, making $25000 is in the 80% range for his classification. I began by making a chart with the salary range percentiles in each column Ex: 70...

workflow email content is bolocked please help!
hi, I have a problem with sending email from workflow when i add the filed on the email message and save ( ex case number , title , subject) we get the following message The email below might contain script or content that potentially harmfull and has been blocked and when message is sent all data in the email message come like this: {Title(Case)} {Customer(Case)} {Subject(Case)} {Contract(Case)} contract i have already installed the rollup update 1 can somebody help please ...