can't center a category label on a line chart

This is a multi-part message in MIME format.
--------------000603030901060204040401
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

Yesterday I got some good help with figuring out the differences between 
the line chart and xy chart. I've had to go with the line chart.  I've 
pretty much got it the way I want it. I've posted my data below. The < 
means prior to 2007.

In Excel 2003 I could easily center the Year between the Major vertical 
gridlines (every forth one, since this is quarterly data). But with my 
present 2007 chart, I can't figure out how to do this. It seems to 
always associate the year, with the first quarter's data, thus when I 
click center, left, or right, it only moves it slighly within the space 
for Q1. If I move the 2007 down a row, then it associates with Q2.

How can I get each year to center neatly between Q1 and Q4, instead of 
just within Q1?

In Axis Options, I have: Interval between tick marks = 4 ; Interval 
between labels, specify = 4. I've tried numerous variations here but no 
help.

Thank you so much for any advice you can offer.  Harold

<2007 	0.1 	12.4%
  	0.1 	12.4%
  	0.1 	12.4%
  	0.1 	12.4%
2007 	0.1 	12.4%

	0.1 	12.4%

	0.2 	12.4%
  	0.2 	12.4%
2008 	0.2 	15.7%
  	0.2 	15.8%
  	0.2 	16.8%
  	0.2 	21.4%
2009 	0.3 	24.6%
  	0.3 	26.9%
  	0.3 	28.0%
  	0.3 	28.0%
2010 	0.4 	34.5%
  	0.4 	0.0%
  	0.5 	0.0%
  	0.5 	0.0%
2011 	0.6 	0.0%
  	0.6 	0.0%
  	0.7 	0.0%
  	0.7 	0.0%
2012 	0.7 	0.0%
  	0.8 	0.0%
  	0.8 	0.0%
  	0.9 	0.0%




--------------000603030901060204040401
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi,<br>
<br>
Yesterday I got some good help with figuring out the differences
between the line chart and xy chart. I've had to go with the line
chart.&nbsp; I've pretty much got it the way I want it. I've posted my data
below. The &lt; means prior to 2007.<br>
<br>
In Excel 2003 I could easily center the Year between the Major vertical
gridlines (every forth one, since this is quarterly data). But with my
present 2007 chart, I can't figure out how to do this. It seems to
always associate the year, with the first quarter's data, thus when I
click center, left, or right, it only moves it slighly within the space
for Q1. If I move the 2007 down a row, then it associates with Q2. <br>
<br>
How can I get each year to center neatly between Q1 and Q4, instead of
just within Q1?<br>
<br>
In Axis Options, I have: Interval between tick marks = 4 ; Interval
between labels, specify = 4. I've tried numerous variations here but no
help.<br>
<br>
Thank you so much for any advice you can offer.&nbsp; Harold<br>
<br>
<table style="border-collapse: collapse; width: 144pt;" border="0"
 cellpadding="0" cellspacing="0" width="192">
  <col style="width: 48pt;" span="3" width="64"> <tbody>
    <tr style="height: 15pt;" height="20">
      <td class="xl63" style="height: 15pt; width: 48pt;" height="20"
 width="64">&lt;2007</td>
      <td class="xl65" style="border-left: medium none; width: 48pt;"
 align="right" width="64">0.1</td>
      <td class="xl66" style="border-left: medium none; width: 48pt;"
 width="64">12.4%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl67" style="height: 15pt; width: 48pt;" height="20"
 width="64">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.1</td>
      <td class="xl66" style="border-left: medium none; width: 48pt;"
 width="64">12.4%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl67" style="height: 15pt; width: 48pt;" height="20"
 width="64">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.1</td>
      <td class="xl66" style="border-left: medium none; width: 48pt;"
 width="64">12.4%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl67" style="height: 15pt; width: 48pt;" height="20"
 width="64">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.1</td>
      <td class="xl66" style="border-left: medium none; width: 48pt;"
 width="64">12.4%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">2007</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.1</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">12.4%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl69" style="height: 15pt;" height="20"><br>
      </td>
      <td class="xl65" style="border-top: medium none;" align="right">0.1</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">12.4%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl69" style="height: 15pt;" height="20"><br>
      </td>
      <td class="xl65" style="border-top: medium none;" align="right">0.2</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">12.4%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="height: 15pt;" height="20">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.2</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">12.4%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">2008</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.2</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">15.7%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.2</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">15.8%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.2</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">16.8%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.2</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">21.4%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">2009</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.3</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">24.6%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.3</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">26.9%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.3</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">28.0%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.3</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">28.0%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">2010</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.4</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">34.5%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.4</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.0%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.5</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.0%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.5</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.0%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">2011</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.6</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.0%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.6</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.0%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.7</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.0%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.7</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.0%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">2012</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.7</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.0%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.8</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.0%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.8</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.0%</td>
    </tr>
    <tr style="height: 15pt;" height="20">
      <td class="xl68" style="border-top: medium none; height: 15pt;"
 height="20">&nbsp;</td>
      <td class="xl65"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.9</td>
      <td class="xl64"
 style="border-top: medium none; border-left: medium none;"
 align="right">0.0%</td>
    </tr>
  </tbody>
</table>
<br>
<br>
</body>
</html>

--------------000603030901060204040401--
0
Harold
2/4/2010 10:05:40 PM
excel.charting 18370 articles. 0 followers. Follow

1 Replies
717 Views

Similar Articles

[PageSpeed] 33

This is a multi-part message in MIME format.

------=_NextPart_000_0043_01CAA9A0.ACA582B0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Harold ,

Arrange Your data like this;

      2008      Q1 0.2 15.70%=20
         Q2 0.2 15.80%=20
         Q3 0.2 16.80%=20
         Q4 0.2 21.40%=20
      2009     Q1 0.3 24.60%=20
         Q2 0.3 26.90%=20
         Q3 0.3 28.00%=20
         Q4 0.3 28.00%=20


That is, add a column with quarters. Then select the lot and Insert - =
Chart.

After you have done that, try replacing Q1 with a space and copy down.

Ed Ferrero
www.edferrero.com

------=_NextPart_000_0043_01CAA9A0.ACA582B0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18882">
<STYLE></STYLE>
</HEAD>
<BODY background=3D"" bgColor=3D#ffffff text=3D#000000><FONT size=3D2 =
face=3DArial>Hi=20
Harold ,<BR><BR>Arrange Your data like this;<BR><BR></FONT>
<TABLE style=3D"WIDTH: 192pt; BORDER-COLLAPSE: collapse" border=3D0 =
cellSpacing=3D0=20
cellPadding=3D0 width=3D256>
  <COLGROUP>
  <COL style=3D"WIDTH: 48pt" span=3D4 width=3D64>
  <TBODY>
  <TR style=3D"HEIGHT: 15pt" height=3D20>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: =
#f0f0f0; BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl65 height=3D20 width=3D64 align=3Dright><FONT =
face=3DCalibri>2008=20
    </FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; =
BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl68 width=3D64><FONT face=3DCalibri>&nbsp;&nbsp;&nbsp; =
Q1</FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; =
BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl66 width=3D64><FONT face=3DCalibri>0.2</FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; =
BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl67 width=3D64><FONT face=3DCalibri>15.70%</FONT></TD></TR>
  <TR style=3D"HEIGHT: 15pt" height=3D20>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: =
#f0f0f0; BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl65 height=3D20 width=3D64><FONT =
face=3DCalibri></FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: =
#f0f0f0"=20
    class=3Dxl68><FONT face=3DCalibri>&nbsp;&nbsp;&nbsp; Q2</FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; =
BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl66 width=3D64><FONT face=3DCalibri>0.2</FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; =
BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl67 width=3D64><FONT face=3DCalibri>15.80%</FONT></TD></TR>
  <TR style=3D"HEIGHT: 15pt" height=3D20>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: =
#f0f0f0; BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl65 height=3D20 width=3D64><FONT =
face=3DCalibri></FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: =
#f0f0f0"=20
    class=3Dxl68><FONT face=3DCalibri>&nbsp;&nbsp;&nbsp; Q3</FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; =
BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl66 width=3D64><FONT face=3DCalibri>0.2</FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; =
BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl67 width=3D64><FONT face=3DCalibri>16.80%</FONT></TD></TR>
  <TR style=3D"HEIGHT: 15pt" height=3D20>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: =
#f0f0f0; BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl65 height=3D20 width=3D64><FONT =
face=3DCalibri></FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: =
#f0f0f0"=20
    class=3Dxl68><FONT face=3DCalibri>&nbsp;&nbsp;&nbsp; Q4</FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; =
BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl66 width=3D64><FONT face=3DCalibri>0.2</FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; =
BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl67 width=3D64><FONT face=3DCalibri>21.40%</FONT></TD></TR>
  <TR style=3D"HEIGHT: 15pt" height=3D20>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: =
#f0f0f0; BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl65 height=3D20 width=3D64 align=3Dright><FONT=20
face=3DCalibri>2009</FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: =
#f0f0f0"=20
    class=3Dxl68><FONT face=3DCalibri>&nbsp;&nbsp;&nbsp; Q1</FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; =
BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl66 width=3D64><FONT face=3DCalibri>0.3</FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; =
BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl67 width=3D64><FONT face=3DCalibri>24.60%</FONT></TD></TR>
  <TR style=3D"HEIGHT: 15pt" height=3D20>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: =
#f0f0f0; BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl65 height=3D20 width=3D64><FONT =
face=3DCalibri></FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: =
#f0f0f0"=20
    class=3Dxl68><FONT face=3DCalibri>&nbsp;&nbsp;&nbsp; Q2</FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; =
BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl66 width=3D64><FONT face=3DCalibri>0.3</FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; =
BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl67 width=3D64><FONT face=3DCalibri>26.90%</FONT></TD></TR>
  <TR style=3D"HEIGHT: 15pt" height=3D20>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: =
#f0f0f0; BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl65 height=3D20 width=3D64><FONT =
face=3DCalibri></FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: =
#f0f0f0"=20
    class=3Dxl68><FONT face=3DCalibri>&nbsp;&nbsp;&nbsp; Q3</FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; =
BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl66 width=3D64><FONT face=3DCalibri>0.3</FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; =
BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl67 width=3D64><FONT face=3DCalibri>28.00%</FONT></TD></TR>
  <TR style=3D"HEIGHT: 15pt" height=3D20>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: =
#f0f0f0; BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl65 height=3D20 width=3D64><FONT =
face=3DCalibri></FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: =
#f0f0f0"=20
    class=3Dxl68><FONT face=3DCalibri>&nbsp;&nbsp;&nbsp; Q4</FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; =
BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl66 width=3D64><FONT face=3DCalibri>0.3</FONT></TD>
    <TD=20
    style=3D"BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; =
BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; =
BORDER-RIGHT: #f0f0f0"=20
    class=3Dxl67 width=3D64><FONT =
face=3DCalibri>28.00%</FONT></TD></TR></TBODY></TABLE>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2 face=3DArial>That is, add a column with quarters. =
Then select=20
the lot and Insert - Chart.</FONT></DIV>
<DIV><FONT size=3D2 face=3DArial></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2 face=3DArial>After you have done that, try replacing =
Q1 with a=20
space and copy down.</FONT></DIV>
<DIV><FONT size=3D2 face=3DArial></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2 face=3DArial>Ed Ferrero</FONT></DIV>
<DIV><FONT size=3D2 face=3DArial><A=20
href=3D"http://www.edferrero.com">www.edferrero.com</A></FONT></DIV>
<DIV><FONT size=3D2 face=3DArial></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_0043_01CAA9A0.ACA582B0--

0
Ed
2/9/2010 5:58:08 AM
Reply:

Similar Artilces:

Linking a cell to a chart title
How do I link a chart title to a cell reference in another worksheet? I have over 200 graphs in one spreadsheet and need a quick way to update the titles when mgmt changes for each sales team. ...

Help With CD Label Design In Publisher
Can anyone point me to a (I suppose) downloadable template to create a CD label in Publisher 2003? I'm looking for: 1) A label template where I can adjust the position of the CD Label to match the sticky labels that I use. 2) A template where the text on the CD wraps (internally) to the curve of the CD. Thanks to all who are able to help me on this. Gary Clarke -- It's a 106 miles to Chicago. We got a full tank of gas, half a pack of cigarettes, it's dark and we're wearing sunglasses. "Gary Clarke" <clarke7052@hotmail.com> wrote in message news:...

Charts Question
When creating a simple bar chart, how can i create it so that it doe not include items which have a zero value. For example, my data may go like this: cars 4 vans 0 Bikes 2 Assuming that the values change on refresh, how can i avoid the grap including the empty "vans" item showing zero????? WITHOUT Having t re-plot it each time. Thanks. JJ -- jj ----------------------------------------------------------------------- jjj's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=742 View this thread: http://www.excelforum.com/showthread.php?thread...

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 ------- Jon Peltier, Microsoft...

M05 Category and Sub-Categorys
Without a doubt, this is the coolest Money program yet. I purchased Microsoft Money 2005 Deluxe and have spent time today finding that all my banks have been added to direct downloads. It is so much better. My experience thus far makes me think that the doom and gloom naysayers here are just not doing things correctly, or they screwed up at some point because this program is excellent. To be fair though, while I do enjoy the software as is, I wonder if anyone has figured out how to change the program to have one entry box for the category and the next box for sub category? I mean, this...

Chart color.
Excel 2000 chart is losing color when pasted into Outlook 2000 email message. Any suggestions? Donna - How are you copying/pasting the chart? If you copy the chart as a picture, using the As Printed options, and if you have a black and white printer installed, you may well get a gray scale image. Try copying as a picture (hold down Shift while selecting Copy Picture from Excel's Edit menu), using On Screen options. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Donna L. Olson wrote: > Excel 2000 chart is losing co...

What are the zig zag lines under text?
I've got tiny black zig zag lines under my text. They're not spelling errors, because spell check is completed. I can't view what the document layout looks like because of these nasty little lines. Word 2007, print layout view. It indicates hidden text. If you toggle off the ShowAll command, the text will disappear. -- Terry Farrell - MSWord MVP "Pamoola55" <Pamoola55@discussions.microsoft.com> wrote in message news:703BB6D0-A3AD-4A8E-B10C-901BD7EAE3E5@microsoft.com... > I've got tiny black zig zag lines under my text. They're not s...

Recovering Master Category List 'after' reformatting C
I have made a "ghost" copy of my computer to an external hard drive, then reformatted "C" and reinstalled everything, via original disks (Win XP), including Outlook 2002. By making a ghost copy, I have a fully functional external hard drive. If I connect it via the USB to the computer, partitions receive a new letter in sequence. The old C drive is now S in the external drive and all the files are fully accessible, except, as it turns out, access to the old registry. In this process I lost all my own Categories in the Outlook Contact book, even so they were...

Visio Gnatt Chart
Curious as to how you create page breaks. I click on the the apropriate box Under view drop down) which shows that the page break function is on. However, I can't figure out how it works. I assumed it works much like the page break function in Exel, Word, etc. Subsequently, when I attempt to print, it only prints one page. Try the Page Setup function under File \ Page Setup. It is dependent on your printer settings -- -ronnie [MS] This posting is provided "AS IS" with no warranties, and confers no rights. "Bill Heckel" <WHeckel@mco.edu> wrote in message...

New Email to a Category of Contacts
Strange problem, I have set up a number of categories to easily allow blast emails to my network of contacts. I select a category (no more then 19 contacts), then action, create, new message to contact, and receive the following warning: "Some of the contacts do not have email addresses ......" The email is then missing a number of contacts. When I look at those contacts, their email addreses are populated correctly. Also, I can create emails to them one by one, but never grouping more then one together. I'm using Outlook 2007 on Windows 7 64 bit. Thanks in adv...

widows media centers tv
I have installed a tv card that actually came with the computer. Some german name haupp something. It used to work, now it doesn't. The media center tells me that it is a hardware failure, but I doubt that. How can I reinstall media center? ...

need variable time axis available in XY chart for area chart #2
I am unable to use different X axis in the Area chart, which is available in the X Y charts. How do I use the X Y chart features of variable X axis to make the area chart? ...

Multiple Numbers on ONE Label
I have several thousand labels I need to print. I would like to put up to 4 part numbers on each label (Avery 5164). These labels will placed on boxes that hold product. Some labels may only get 2 or 3 part numbers per label depending on size of the part. My part numbers are classified as S,M,L. Can this be done? Example... ABC123 - small ABC234 - large (max 2 numbers per label) ABC345 - small ABC456 - med (max 3 numbers per label) BCD123 - small BCD234 See: Print a Quantity of a Label at: http://allenbrowne.com/ser-39.html The article assumes you have a Q...

Memory Leak when copying charts to another worksheet
Hi I have a BAD memory leak when I copy a chart... even a blank chart to another worksheet. It eventually causes excel to crash. In my example, the sequence to crash excel was as follows: - Copy Chart 5000 times (loop) - less times would work too, and you'd see the increase in private bytes as you go along - Copy method of range class failed - Clicked End button on debug message box - Closed Excel - Message: The picture is too large and will be truncated - Excel.exe - Application error. The instruction at "0x300dc756" referenced memor...

Category sync Outlook 2007 WM6.5
Hi all, My boss had brought a new smartphone and want to reorganize his contacts... He is actually sorting all his contacts in his Exchange contact list (via Outlook) and he would like that his assistants helps him. I've shared his contacts list to his assistants and they cans see and add contacts in his list. Now the problem is about categories... The assistants can see some categories (about 9) but not all of them (about a dozen)... they see them without colours but we dont care :) Can someone explain me that? Is there a limitation? I give "Editor" p...

Synchronizing off line folders, off exchange.
Hi all. I have setup the synchronization of an exchange mailbox, into an ost an a laptop. My problem is that each time the sync gets half way, at the exact same place, the process hangs and outlook hangs. I have been told to try resetting some type of list in exchange. Does this mean anything to anybody? Tks. Al. What version of Outlook and Exchange? Any errors in Application Event log on server? al wrote: > Hi all. > > I have setup the synchronization of an exchange mailbox, into an ost > an a laptop. > > My problem is that each time the sync gets half way, at the ex...

Outlook & Word XP: How do I print labels for Christmas cards?!
I get some incredibly frustrated with MS Word & Outlook sometimes! Especially when it comes to trying and make it print a bunch of labels for me, for addressing Christmas cards. According to the online help I can start in Outlook's Contacts and select those I want to send messages to. Fine. I've done that. Now what?! The instructions don't say, and I just can't lay my head on the keyboard and hope to learn what I'm supposed to do next. I suppose the online help could help, but I don't know what the "correct" key words would be, so I cannot enter the k...

Printing labels for an Assembly item
RMS 2.0 - We've created and Assembly item that includes two separate pieces to be sold together. We want to be able to sell these items as one piece, but need to order them as separate pieces. When we sell the one piece, we need the inventory to detract from each item quantity separately. We've set up an Assembly item to do this. But, now we cannot figure out how to print a barcode label for the Assembly item set up. Is there a way to do this? Nope. RMS cannot print a label for an assembly item. I wish I had better news, but that's the facts. Pathetic, but true. You...

center-center text in a table
In microsoft word I can format the text center-center, or center-left, or center-right, ... in a table. But can publisher do so? If Yes, how am I going to accomplish this. Sure can! Right Click > Format Table -- "If you don't know where you are going, any road will take you there!" ...

Media Center problems.
Hi, I am having a bit of a problem with Media Center on my new Windows 7 x64 bit system. Firstly, I am unable to remove a folder from the media libraries list for 'Recorded TV.' When I try to remove this folder from the list, I am unable to. There is a tick beside it that I am unable to remove. I am also unable to remove it manually windows explorer as access is denied due to needing permission from NETWORK SERVICES. Secondly, I am unable to start the Windows Media Center Receiver Service. When I try to, I receive the following error message: "Error 0x80070...

How do I make a chart I have generated in Excel into a jpeg file.
I have a chart that I generated in Excel that I need to make into a jpeg file so I can resize it and drop it into a web site article. Any help would be greatly appreciated. I have ACDSee 8 software for the resizing and dropping into the web article I am working on. Hello, Patty! You wrote on Sat, 19 Aug 2006 14:04:25 -0700: PT> I have a chart that I generated in Excel that I need to PT> make into a jpeg file so I can resize it and drop it into a PT> web site article. Any help would be greatly appreciated. PT> I have ACDSee 8 software for the resizing and dropping int...

Partial Grid Lines
I have the same problem as 'newbie' posted on 8/4/05 (see below). Some of my grid lines have vanished and do not print at those same cells. I have tried hiding them and saving the worksheet then turning them back on and saving the worksheet again. It seems that only certain cells are missing. The data in those cells does not overrun the cell to hide the grid. Any suggestions? TIA, Keith ----------------------------- Subject: Where are my partially missing grid lines? 8/4/2005 9:57 AM PST By: newbie In: microsoft.public.excel.misc In some of my worksheets it s...

Want to use left and center footer in same page
Enter the left footer text in the left footer box, and the center footer text in the center footer box (and use the right footer too, if you want). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "wjs-matt" <wjsmatt@discussions.microsoft.com> wrote in message news:739E7094-EB92-4B15-BC2C-7B640A7FD108@microsoft.com... > ...

Timesheet Add Lines function ?
There are times when filling out the timesheet, folks will need to add lines to the timesheet via the "Add Lines" button. Does the list that holds the projects/tasks to choose from get larger and larger? Is there some event or trigger that causes a project/task to no longer display in the Add Lines dialog box of the timesheet? Thanks, Andy Novak UNT Andy -- To the best of my knowledge, the Add Lines feature will continue to show every project to which a user is assigned at least one task until the Project Server administrator deletes the project. This means the l...

Change the label in bottom menu.
Hi, guys, I am rather new to the whole Microsoft CRM thing, and perhaps m question will seem silly or is directly answered somewhere else, bu after a day of googling i couldnt find any solution So back to my question: is there any supported way of changing th labels for the built-in items at the bottom of MS CRM 1.2 we interface. If there isnt any supported way for achieving this, - the where this data is kept, and what are the chances that changes lik this will be the same for the next releases of MS CRM The question extends to a larger problem though: we need to translat every single item ...