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

Similar Articles

[PageSpeed] 14

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:

Regression
In Excel 2003, I used the Data Analysis Toolkit to perform a linear regression. Does anyone know how I see the variance of each datapoint away from the line of best fit? Tools - data analysis - regression (i dont know if there is an option in this process that will display the data i am looking for) Thanks. WA - The Regression tool has a checkbox for Residuals, in which case it provides Residuals (difference between actual Y and predicted/fitted Y) for each data point. - Mike http://www.MikeMiddleton.com "WA" <WA@discussions.microsoft.com> wrot...

How Can I Prevent Data Entry In Same Category on the Same Date?
Hello... I hope that someone can help me. I have a worksheet for which I randomly enter scores for students in several categories throughout the day. Column Headings: Date StudentName Category1 Category2 Category3, etc. I would like for Excel to display a warning message if I attempt to enter a score in the SAME category on the SAME day. Does anyone know how I may do something like this? Thanks!!! Jessi Jessi, Select the Category1 cells, C2:C10 in this example. The dates are in A2:A10. The following presumes C2 is the active (white) cell of your selection. In Data - Valida...

Chart to show response to a question. One of answer 15 choices.
I know this will be simple but I can't figure it out. On a number of given dates I ask how happy people are and get a number of responses between 1 and 15. I then need to plot the number of occurences of those individual respones i.e. two people were 2, three people were 7 etc. I guess it might be a simple X/Y but I just cannot fathom it out. Any help would be greatly appreciated. Regards, Nick. Hi, You need to create a summary table of possible responses and tally. Assuming responses are in A1:A15 in B1:B5 are the value 1 to 5, which are the available responses. ...

Transactionform: Split category section into two
I want to have a seperate entry box for categories and one for subategories In microsoft.public.money, Dennis Mc wrote: >I want to have a seperate entry box for categories and one for subategories In later versions, tick Tools->Settings->Categories->UseTheDualCategoryDropdownControl ...

Very strange problem when inserting a picture in a 3D Chart
When trying to format the salls or the data series of a 3D Chart with a picture fill, a copy of the Worksheet the data is being taken from appears behind the picture. This is the staangest thing I have ever seen. This does hnt ha[pen when the chart is not a 3D chart. This did not happen before. We are Using Windows XP & Excel 2003. I could not find anything in the knowledgebase or support center. Has anyone else ever seen anything like this? Suggestions? ...

Adding a Benchmark line in an Excel chart
I have created a great looking Excel chart. I now need to add a benchmark line to show what parts of my column bars are below or above the benchmarked data. Is there an easy way to do this and show the number on the line what the benchmark actually is? I have just been manually drawing a line with the line tool then using a text box to write in the number. I would love to be able to tell Excel what the benchmark is and have it draw it on the graph. Hi, Enter your benchmark figure in a cell. This will be your y value. Add a suitable x value in the cell to the left of your y value. Plot t...

How do I get charts to ignore results of a formula if it equals 0
Hi, Use NA() instead of zero. Depending on your chart type the point will not be plotted. Cheers Andy ChrisRox wrote: -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info ...

Multiple Pie Chart
How do you create a multiple pie chart? e.g. if you have 3 groups A, B and C, each which 3 different category X, Y and Z. Is it possible to put it all into one chart? I have done it but it has to be done individually and it takes time. There's no chart type that combines multiple independent pies in the same chart. Your approach (three sepaarate charts) is how I would do it. Unless you want to try one of the approaches in this article: http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=471 These look great, combining the data into a single apparent chart, but they act...

How do I label data points in a scatter graph
Hello, I am trying to label a data point in a scatter plot but it keeps returning the x value. I'd like to have the store # instead. Basically I have Store #, Acceptance % and $ Value Eligible. Right now I have Acceptance % as my x-value and $ Value Eligible as my y- value. I'd like the plot point to return the store # assoicated with the x and y value. On Oct 26, 8:43 am, Justin <JustinFeh...@iowatelecom.net> wrote: > Hello, I am trying to label a data point in a scatter plot but it > keeps returning the x value. I'd like to have the store # instead. > Basical...

I want to make the line twinkling, but why the line can not redraw?
void CMyView::OnButtonL() { CClientDC* pDC = NULL;; pDC = new CClientDC(this); ASSERT(pDC != NULL); CPen Pen1(PS_SOLID, 10, RGB(192, 192, 192)/*GetSysColor(COLOR_BTNTEXT)*/); CPen* pPenOld = pDC->SelectObject(&Pen1); pDC->MoveTo(100, 50); pDC->LineTo(200, 50); pDC->SelectObject(pPenOld); delete pDC; if(m_bTimerOkey == false) { SetTimer(IDT_TIMER_LINE, 5000, NULL); m_bTimerOkey = true; } } void CMyView::OnTimer(UINT nIDEvent) { if(nIDEvent == IDT_TIMER_LINE) { RECT LineRect = {100-5, 50-5, 200+5, 50+5}; //InvalidateRect(&LineRect); OnButtonL(); }...

REPLICATES ON CHART
i"m following an experiment and have several measurements each day under the same conditions> i want to chart all the data (scatter) with a line which shows mw the range or deviation of each day"s data group for each day> i know is a silly question but i cannot find the way could somebody help me with that-- Thanks Alejandro Do you mean you collect a number of reading each day, and you want to chart the average of these plotted against the date together with error bars showing either the min & max or the standard deviation (which) ? Can we assume the dates are in colu...

Resizing elements of Excel charts
Any ideas why Excel won't let me resize my plot area or legend, etc.? I can get the double arrow handles to show up, but they won't work. Oh - I just realized it is because I am working with a PivotChart. I can avoid that, but for the future is there any way to resize elements of PivotCharts, or is what you see what you get? "Artifactual" wrote: > Any ideas why Excel won't let me resize my plot area or legend, etc.? I can > get the double arrow handles to show up, but they won't work. Pivot charts do not have the same flexibility as normal charts. The...

bar chart on 2 axis
I am trying to create a bar chart. I have 9 series for which each have 2 sets of data value. I want to create a bar chart where each series is represented by 1 bar, with the chart having one set of values along the x axis and one along the y axis. I am having great difficulty with this. Can you help at all? Full instructions are found at http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Hannah" <Hannah@discussions.microsoft.com> wrote in message news:ED02B24D-AEA9-40E0-8D8C-4199...

2007 Charts not retaining formatting
We have a spreadsheet that we have put together with a number of calculations and charts. Several scheets have two charts on it with the data and some comments. The system keeps changing some of the chart formatting such as label sizes, color or even the size of the whole chart. This can happen when we get ready to print several sheets or even save the file exit Excel and reopen the file. It seems to have a lot of loose ends with things just happening to the formats in the file. This was a new spreadsheet created as a 2007 Macro Spreadsheet. (We had to use a custom function since ...

Hiding column/row labels --without hiding entire columns/rows
Hello, I have seen worksheets that somehow hide all the default worksheet column and row labels (A, B, C, ...; 1, 2, 3, ...). The result can look stunning. But, I don't know how it is done. I have scaned through the worksheet properties, comparing it to normal worksheets which do display the column/row headers, but I can find nothing. Any hints on how to show/hide the default labels for a worksheet? Thanks. <Tools> <Options> <View> tab, And *Uncheck* all the things you wish to not display (hide). -- HTH, RD ============================================== Please keep ...

On line statements in Money2005
I recently upgraded from Money 2003 to Money 2005. Money 2003 had a feature that showed under the accounts list page called "get online statements" which I could use to download activity from my bank re cleared transactions, etc. I don't find a similar feature in Money 2005. Would someone please point me to where in Money2005 I should go to get online statements or download bank activity? - Bob Internet Updates in the Tools menu?!? "Bob" <bob@serenitymail.com> wrote in message news:ucnW7$UpGHA.4236@TK2MSFTNGP03.phx.gbl... >I recently upgraded from ...

Can't Copy and Link Chart into new workbook
I've be trying to copy and paste (and link) a chart into a new workbook. I've tried: Paste Paste Special (paste link) Paste Picture The copy function seems to work. But after I close, reopen, and link to other workbook, I recieve the following error message: The instruction at "0x302b62c3" referenced memory at "0x01d00221". The memory cound not be "read". If I don't link to the new workbook it opens fine, but without updated data. ...

Closing Outlook from command line
Is there a way to close Outlook from a command line? I need to have it closed before I do my daily backup on a remote machine. Outlook runs on this machine to archive all the emails managed through Exchange. Thanks Steve Hi Steve, you could try our freeware addin "QuitOutlook": With QuitOutlook you can shut down Outlook at a particular time. To start QuitOutlook you only need to add the script into a scheduled task of Windows. Then you are able to backup your Outlook data file (*.pst file) easily and uncomplicated Download on this site: http://www.publicshareware.com/pu...

Excel
In Excel, although in Tools, Options, View, the grid lines box is checked, they don't show on my worksheet? Anyone know how to fix this? Thanks. Look in Tools, Options, View and in the color box under the gridline box, make sure it is set for automatic -- ElsiePO ----------------------------------------------------------------------- ElsiePOA's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=390 View this thread: http://www.excelforum.com/showthread.php?threadid=26183 Also Format the cells' background color to "No Color"(default) and not ...

draw a horizontal line at the end of report
My report draws vertical lines in details section. How can I draw a horizontal line after last record on each page to make the table complete? Thanks. -- Lydia Liu Access/VB Programmer Have you tried adding a horizontal line in the Page Footer? -- Duane Hookom Microsoft Access MVP "Lydia" wrote: > My report draws vertical lines in details section. How can I draw a > horizontal line after last record on each page to make the table complete? > Thanks. > > -- > Lydia Liu > Access/VB Programmer > ...

command line conversion from 97 to 2002
I have a couple of hundred laptops in the field that each have an Access 97 mdb that needs to be converted to Access 2003. Is it possible to do this with the command line /convert ? When we deployed these things five years ago we installed DATAACC for the drivers necessary. Access is not installed on these machines. Do I need to install the newest version of MDAC and then call the access exe with the /convert switch? Where can I find documentation on this switch? Thanks Doug Installing the latest version of MDAC isn't going to help, for a couple of reasons. MDAC hasn't included Jet...

How do I create a combination bar and XY chart?
I'm using Excel 2002 and would like to create a horizontal bar chart with some dots (or other symbols) overlayed on top. The idea is to show an operating range with the bar, and then highlight some key operating points within that range with the dots. Jon Peltier has instructions for a Bar-Scatter graph here: http://www.peltiertech.com/Excel/Charts/BarLineCombo.html Engineer_SM wrote: > I'm using Excel 2002 and would like to create a horizontal bar chart with > some dots (or other symbols) overlayed on top. The idea is to show an > operating range with the bar, and ...

Including "special" category transactions in a budget
Hello I was wondering if someone could help out with the following: I want to set a limit for the amount of credit card payments in my budget. To do that, I need to specify the category for the transactions that I want to track in the planner. However, when I enter a transaction for a credit card payment into the register, I have to enter it as a "special" transaction (i.e., "Credit Card Payment : MASTER card"), so that it is linked in both "From" and "To" accounts - otherwise, if I assign it to a different category, the budget planner will se...

Add a line in a chart....help...
I have a spreadsheet where your are supposed too archive curtain goals, based on different activities. I've got six different colums taht shows the activities, I wanna' have a line that shows how the activites mesures up to the goal. Ex. the goal (and the line) is to run 12 times a month, but you only run seven (activities) Anybody who could help, thanks Ns Jon Peltier has instructions for adding a horizontal line to a chart: http://www.peltiertech.com/Excel/Charts/ComboCharts.html#AddLine N Schei wrote: > I have a spreadsheet where your are supposed too archive curt...

User defined charts #2
Morning All Have set up a user defined chart - to chart a target percentage Bar 100% with another bar next to it with the performance target acheived eg 80%. In the user defined chart the Target percentage is the first bar and coloured blue and the performance percentage is red and the second bar. When I chart the next months data the above bars are reversed and the colours are swapped over; this means I have to go in and change the formatting over each time I create the chart using this user defined template. Would appreciate any ideas as to what I am doing wrong / right, TIA Ajay ...