I get gaps in bar chart when using weekday values only in x-axis

[Björn Elfvin]

Plotting a stock bar chart and using weekdays only (no weekend date values)
as the x-axis (category labels) leavs med with gaps in the bar chart.

How do i plot the chart without the gaps?

Regards

[Barb Reinhardt]

If you are talking about gaps between the bars for each day, double click on
the series you want to format and select the OPTIONS tab. Adjust the GAP
WIDTH as needed.

"Björn Elfvin" <Bjrn [email protected]> wrote in message
news:[email protected]...
> Plotting a stock bar chart and using weekdays only (no weekend date
values)
> as the x-axis (category labels) leavs med with gaps in the bar chart.
>
> How do i plot the chart without the gaps?
>
> Regards
>

[Debra Dalgleish]

The x-axis has defaulted to a time-scale. To change the setting:

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


Björn wrote:
> Plotting a stock bar chart and using weekdays only (no weekend date values)
> as the x-axis (category labels) leavs med with gaps in the bar chart.
>
> How do i plot the chart without the gaps?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html