Asked By Harold Good
04-Feb-10 05:05 PM
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 have had to go with the line chart. I have
pretty much got it the way I want it. I have 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 cannot 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 have tried numerous variations here but no
help.
Thank you so much for any advice you can offer. Harold
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
Hi,<br>
Yesterday I got some good help with figuring out the differences
between the line chart and xy chart. I have had to go with the line
chart. I have pretty much got it the way I want it. I have posted my data
below. The < means prior to 2007.<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 cannot 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>
How can I get each year to center neatly between Q1 and Q4, instead of
just within Q1?<br>
In Axis Options, I have: Interval between tick marks = 4 ; Interval
between labels, specify = 4. I have tried numerous variations here but no
help.<br>
Thank you so much for any advice you can offer. Harold<br>
cellpadding="0" cellspacing="0" width="192">
width="64"><2007</td>