Axis Labels

[Paul Smith]

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]

To change the setting from a time-scale:

Select the chart
Choose Chart>Options
Select the Axes tab
For Category (X) axis, choose Category, click OK

 

[Guest]

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 here:

http://www.pdbook.com/index.php/excel/omitting_x_axis_labels_tied_to_zero_values/

 

[Jon Peltier]

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/
_______