How do I manually adjust the width of my columns in a bar graph?

E

Excel User Neu1

In a graph, I would like to manually drag the columns to make them thicker or
thinner. I would also like to adjust the spacing between columns.
 
W

Wigi

Right click a series on the chart, choose Format data series... and then
in the Options tab, play a bit with overlap and gap width.
 
J

Jon Peltier

Note that you can only adjust the entire series, not each individual column
and gap.

- Jon
 
S

ShaneDevenshire

Hi,

1. You can't manually drag to adjust column widths on a chart.
2. You can use the menu methods already suggested.
3. You can "Fake" the display of a column chart so that some bars appear
wider than others but its a lot of work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Graph Line Width ? 1
Stacked Bar Graph 1
Graph to only include rows with data in 3
Excel How to create a stacked bar graph 0
Combining a 2-D column graph and a 2-D line graph on the same char 3
Excel 2007 problem with bar charts 1
Defining areas on a graph 1
Line graph colors 5

Top