Thread: Excel Charting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Smith[_4_] Paul Smith[_4_] is offline
external usenet poster
 
Posts: 3
Default 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!