How do I resize the columns in a graph chart?

J

Jon Peltier

Is this what you want? Double click the series, click on the Options
tab, and change the Gap Width setting.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
R

Rita

That helped, but I did not phrase my question correctly the first time.
Following what you said, I was able to increase the width of the bars in the
bar graph, but it also decreased the gap between each bar. I want to keep the
gap the same while at the same time increasing the width of each bar in the
bar graph.
 
J

Jon Peltier

Hi Rita -

It's a zero sum game. The only way to increase one without decreasing
the other is to increase the sum, that is, make the entire chart wider.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
N

Nora R

Jon, is there any way to make the width of the bars vary one from another? I
have 10 items whose perfomance I measure performance and I plot their
performance indices. I'd like the one that is the biggest dollar-wise to
have the widest bar. As you indicated below, I can make them all wider or
narrower, and vary the gap between them, but haven't been able to figure out
how to make them different widths. Thanks for any help! Nora
 

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

Change data range graph from 0-60 to 40-60 0
How can I put two variables with different scales on the same char 0
How do I reset the default colours in a line graph 0
How do I create charts having non absolute reference values? 0
Can I make a graph using several tabs in an excel spreadsheet 0
How do you get more chart days on Blood pressure tracker 0
I want to produce a log-log chart. Logrithmic scale on both axis. 1
How can I create a stacked bar chart with stacked bars side by si. 2

Top