Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Formatting dates on x axis of chart...! | Excel Discussion (Misc queries) | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |