A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Offset Horizontal axis data



 
 
Thread Tools Display Modes
  #1  
Old April 21st, 2010, 03:38 PM posted to microsoft.public.excel.charting
Sucram
external usenet poster
 
Posts: 2
Default Offset Horizontal axis data

Excel 2007

My horizontal axis is made up of the week number values for the year week 1
to week 53.

I have two sets of data to plot as bars against thos axis.

The first set is data from 2009 and the second set is the data collected so
far from 2010.

My problem is that the 2009 data started being collected from week 8
however, when plotted in my chart is starts from week 1.

The data range I'm selcting uses a common week row for its values with the
two sets of data (2009 & 2010) contained in rows underneath.

Any ideas?


  #2  
Old April 22nd, 2010, 06:11 PM posted to microsoft.public.excel.charting
Karissa
external usenet poster
 
Posts: 43
Default Offset Horizontal axis data

It sounds as though you haven't included any blank spaces for sourcing your
data for 2009. Make sure that you have weeks 1-53 selected for 2009, even
though 1-7 will be blank. Consider them spacers. I hope this helps.

"Sucram" wrote:

Excel 2007

My horizontal axis is made up of the week number values for the year week 1
to week 53.

I have two sets of data to plot as bars against thos axis.

The first set is data from 2009 and the second set is the data collected so
far from 2010.

My problem is that the 2009 data started being collected from week 8
however, when plotted in my chart is starts from week 1.

The data range I'm selcting uses a common week row for its values with the
two sets of data (2009 & 2010) contained in rows underneath.

Any ideas?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.