Forum Statistics
- Forum Members:
- Total Threads:
- Total Posts: 9
There are 1 users currently browsing forums.
|
 |
07-03-2009, 09:34 AM
|
|
Registered User
|
|
Join Date: 22 Apr 2009
Location: Stockholm, Sweden
MS Office Version:Excel 2003
Posts: 17
|
|
|
Charting with weeknumbers over two years
Please Register to Remove these Ads
Hi all,
I am having a problem with a chart. I have a column with Year (2008-2009) which is not used in the chart and a column called Weeknumber (1-52 (for both 2008 and 2009)) and finally a column with values. I am trying to do a chart with this and 2008 works fine shows all values from 1 to 52, but when I put in year 2009 ie week 1 to 27 the scale does not accept that and just scales upwards from 52 to 79 how can I fool excel to accept that it puts out 1 to 27 for year 2009 (instead of 52 - 79)??
Xlbob
Last edited by XLBob; 07-06-2009 at 09:11 AM.
|
07-03-2009, 11:05 AM
|
 |
Forum Guru
|
|
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007 sp2
Posts: 7,223
|
|
|
Re: Charting with weeknumbers over two years
depends what type of chart you are using and how you data is set up
can you post example workbook
|
07-06-2009, 04:28 AM
|
|
Registered User
|
|
Join Date: 22 Apr 2009
Location: Stockholm, Sweden
MS Office Version:Excel 2003
Posts: 17
|
|
|
Re: Charting with weeknumbers over two years
Certainly Andy,
Please see attached!
XLBob
|
07-06-2009, 04:57 AM
|
|
Forum Guru
|
|
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007 sp2
Posts: 7,223
|
|
|
Re: Charting with weeknumbers over two years
The problem was both columns of information were plotted as a series.
What you actually needed was the first series to be used as category labels and the second as the data.
Simplest way would have been to remove the header above the category labels.
I have also changed the data so it's possible to get the year information included in group.
|
07-06-2009, 05:20 AM
|
|
Registered User
|
|
Join Date: 22 Apr 2009
Location: Stockholm, Sweden
MS Office Version:Excel 2003
Posts: 17
|
|
|
Re: Charting with weeknumbers over two years
That easy?? A really nice solution! But how would I do to show only the value on the X axis of every say fourth value?
XLBob
|
07-06-2009, 05:26 AM
|
|
Forum Guru
|
|
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007 sp2
Posts: 7,223
|
|
|
Re: Charting with weeknumbers over two years
double click X axis.
Scale tab > Number of categories between tick mark labels.
|
07-06-2009, 05:30 AM
|
|
Registered User
|
|
Join Date: 22 Apr 2009
Location: Stockholm, Sweden
MS Office Version:Excel 2003
Posts: 17
|
|
|
Re: Charting with weeknumbers over two years
Hum,
Cannot do that its greyed out...
XlBob
|
07-06-2009, 05:35 AM
|
|
Forum Guru
|
|
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007 sp2
Posts: 7,223
|
|
|
Re: Charting with weeknumbers over two years
I see, when you use the multi level category labels ALL labels are displayed.
If you want only some of the labels AND multi levels you will have to remove the unwanted values from the range.
|
07-06-2009, 06:17 AM
|
|
Registered User
|
|
Join Date: 22 Apr 2009
Location: Stockholm, Sweden
MS Office Version:Excel 2003
Posts: 17
|
|
|
Re: Charting with weeknumbers over two years
Aha, got it!
Cheers Andy
XLBob
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
