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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Axis Labels
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?????? |
#2
|
|||
|
|||
To change the setting from a time-scale:
Select the chart Choose ChartOptions Select the Axes tab For Category (X) axis, choose Category, click OK Paul Smith wrote: 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?????? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Paul,
In addition to Debra's suggestion, you could use an array formula to exclude any dates with zero values. If I'm interpretting correctly, the dates would fall on Sunday in your example. The process is described he http://www.pdbook.com/index.php/exce...o_zero_values/ ---- Regards, John Mansfield http://www.pdbook.com "Paul Smith" wrote: 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?????? |
#4
|
|||
|
|||
But if Excel draws a time scale X axis, it will show Sunday even if
there's no data for Sunday. I suspect Paul has no Sundays in his X data anyway, so your arrays will probably not filter the data in a helpful manner. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ John Mansfield wrote: Paul, In addition to Debra's suggestion, you could use an array formula to exclude any dates with zero values. If I'm interpretting correctly, the dates would fall on Sunday in your example. The process is described he http://www.pdbook.com/index.php/exce...o_zero_values/ ---- Regards, John Mansfield http://www.pdbook.com "Paul Smith" wrote: 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?????? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Labels on Chart with Negative Value Axis | David F. Schrader | Charts and Charting | 6 | December 17th, 2004 06:25 PM |
center labels in x axis while skipping 3 of every 4 categories | HGood | Charts and Charting | 5 | August 26th, 2004 02:24 PM |
align labels on X axis | HGood | Charts and Charting | 3 | August 24th, 2004 03:14 AM |
Y axis start value, and minor value labels formatting | StainlessSteelRat | Charts and Charting | 1 | March 24th, 2004 08:27 PM |
category x axis labels | scott23 | Charts and Charting | 2 | February 2nd, 2004 06:06 PM |