Excel Charting
I am trying to chart data for each day of the week except Sunday.
I am using a stacked bar graph with volume on the y axis and the date along the bottom. My week runs Friday to Thursday. My problem: In my data series I have six slots (Fri, Sat, Mon, Tue, Wed, Thu) and these are dates. When I chart these I get a x value for Sunday. Sunday's date is not present bit it appears. I can only assume this is because the X Axis' scale has set itself to days, as the A axis series are indeed dates. How can I just chart the six days for whgich I am entering Data?????? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Excel Charting
Paul,
I think it is objChart.Axes(xlCategory).CategoryType = xlCategoryScale Excel seems to default to xlTimeScale or xlAutomatic for this property, either of which will pick up that there are dates present and add intervening dates (very annoyingly). Robin Hammond www.enhanceddatasystems.com "Paul Smith" wrote in message ... I am trying to chart data for each day of the week except Sunday. I am using a stacked bar graph with volume on the y axis and the date along the bottom. My week runs Friday to Thursday. My problem: In my data series I have six slots (Fri, Sat, Mon, Tue, Wed, Thu) and these are dates. When I chart these I get a x value for Sunday. Sunday's date is not present bit it appears. I can only assume this is because the X Axis' scale has set itself to days, as the A axis series are indeed dates. How can I just chart the six days for whgich I am entering Data?????? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
All times are GMT +1. The time now is 04:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com