can't center a category label on a line chart
in [Charts]
|
Prev: Chart series legend font size keeps shrinking - how to stop it?
Next: The scale on vertical axis equals to scale on vertical axis of ano
From: Harold Good on 4 Feb 2010 17:05 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%
From: Ed Ferrero on 9 Feb 2010 00:58
Hi Harold , Arrange Your data like this; 2008 Q1 0.2 15.70% Q2 0.2 15.80% Q3 0.2 16.80% Q4 0.2 21.40% 2009 Q1 0.3 24.60% Q2 0.3 26.90% Q3 0.3 28.00% Q4 0.3 28.00% 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 |