Bar Charts

[YANKRAY]

Using Excel 2007.

I am having difficulty figuring out how to widen the bars on an excel bar chart. I have all my data plotted and the bars are very narrow. There are only two data points. How do I get the bars to widen to fill out the chart?

thanks,
Ray

 

[SkipVought]

Hi,

Hope this works in 2007.

Right-click one of the bars and select Format Selected Object or Selected Object.

Select Options TAB.

Change Gap Width.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[xlhelp]

Right click the series. Select Format Data Series. Under Series Options change Gap Width.

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents