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

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

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 wrote in message
...
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

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

Select the chart
Choose ChartOptions
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